Technical Blog

Create table " " (EMPNO NUMBER(3)); Creates a table with 4 spaces as its name. When you select the list of tables from all_tabl...

This topic deals with the exporting the table and its data from Access to Oracle database . For this first you need is to create a datasourc...

Everything (Table Creation including Primary ,Foreign key ,Check constraint and giving user defined CONSTRAINT NAME for NOT NULL CONSTRAINT...

dbms_wm.gotodate begin dbms_wm.gotoworkspace('B_focus_1'); end; insert into test values (6,'Wayanad','YS',...

To Refresh workspace begin dbms_wm.gotoworkspace('B_focus_9'); dbms_wm.refreshworkspace('B_focus_9'); end; But if th...