get tables and their number of rows in Oracle Database Schema
Simplest way is to use the data dictionaries provided by Oracle. And you can depend on the results if the […]
get tables and their number of rows in Oracle Database Schema Read More »
DBMS_UTILITY.FORMAT_ERROR_BACKTRACE in PLSQL
In Big/complex applications, it is essential to call Sub-programs (Procedures/Functions) from other sub-programs. In that case it will be difficult
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 »
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 »
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 »