S.No. Shortcut Functionality Toad SQL Developer 1 Ctrl + Enter Ctrl + Enter Executing Query or selected script (multiple queries […]
Toad and SQL Developer shortcuts for Database Developers Read More »
CREATE OR REPLACE FUNCTION rev_str_f(str VARCHAR2) RETURN VARCHAR2ISv_str VARCHAR2(10); –you can specify your own sizev_str_rev VARCHAR2(10); –specify same size as
Function to display reverse string of the given string in PL/SQL Read More »
Replace will replace the character or string with the given character/string for every occurrence of the character/string.Translate will replace the
Difference between REPLACE and TRANSLATE in SQL? Read More »
Procedure without Parameters: CREATE OR REPLACE PROCEDURE dept_sal_pISCURSOR C1 ISselect d.department_name,e.tot_sal from(SELECT department_id,sum(salary) tot_salFROM employeesGROUP BY department_idHAVING SUM(salary) > 50000)
Procedure to display the departments, which are having total salary greater than? Read More »
