ORA-30926: unable to get a stable set of rows in the source tables
We will get this when we are trying to update a row in a table, for which there will be […]
ORA-30926: unable to get a stable set of rows in the source tables Read More »
ORA-06502: PL/SQL: numeric or value error
We may get this error, when we try to assign a value to a variable which is bigger than the
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
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
Toad and SQL Developer shortcuts for Database Developers Read More »
Function to display reverse string of the given string in PL/SQL
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 »
Difference between REPLACE and TRANSLATE in SQL?
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 to display the departments, which are having total salary greater than?
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 »