Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
-- DISABLE -- accept tab prompt "Enter the name of the table to disable its constraints: " set serveroutput on declare sql_stm varchar2(2000); begin dbms_output.enable(1000000); for x in (select constraint_name ,decode(constraint_type,'P',' cascade') casc from user_constraints where table_name = upper('&tab')) loop sql_stm := 'alter table &tab disable constraint '|| x.constraint_name||x.casc; dbms_output.put_line(sql_stm); execute immediate sql_stm; end loop; end; /
|Getting TNS:Connect timeout occurred while opening the application||5||77|
|Migrate Oracle Database from ASM to Non-ASM on a Windows server.||1||45|
|use lov values||2||49|
|Function to return one result based on data in first query||11||44|