February 2014

Finding characters in a string (VARCHAR-VARCHAR2) column

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 »

Toad and SQL Developer shortcuts for Database Developers

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 »

Scroll to Top