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 »
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 »