We will get this when we are trying to update a row in a table, for which there will be two or more corresponding records. Table 1: tc11 tcl2 t1 a t2 b t3 c t4 d Table 2: tc21 tc22 b1 a b2 b b3 c b4 d Table 3: tc31 tc32 t1 b1 …
ORA-30926: unable to get a stable set of rows in the source tables Read More »
We may get this error, when we try to assign a value to a variable which is bigger than the maximum size of the variable.Find the following code for example: DECLARE v_data VARCHAR2(1); BEGIN v_data := ‘YES’; END; / Error starting at line : 1 in command –DECLAREv_data varchar2(1);BEGINv_data := ‘YES’;END;Error …
Compile the following Function in Oracle Database by copying it and Pressing F5 or F9 create or replace function test_num (v_card varchar2) return varchar2 is v_num number; begin select v_card into v_num from dual; return 1; exception when others then return v_card; –DBMS_OUTPUT.PUT_LINE(v_card); –DBMS_OUTPUT.PUT_LINE(SQLCODE); –DBMS_OUTPUT.PUT_LINE(SQLERRM); end test_num; Now fire the query as follows to find …
Finding characters in a string (VARCHAR-VARCHAR2) column Read More »
S.No. Shortcut Functionality Toad SQL Developer 1 Ctrl + Enter Ctrl + Enter Executing Query or selected script (multiple queries execution is not available in Toad) 2 F9 F9 Executing Query or selected script (multiple queries execution is not available in Toad) 3 F4 Shift + F4 Viewing Object properties i.e. Code of Functions/Packages/procedures and …
Toad and SQL Developer shortcuts for Database Developers Read More »
