DATABASE MANAGEMENT SYSTEM _Write a PL/SQL block to change address of a particular employee by taking his/her, Write a PL/SQL block to display number of employees for each department. Write a PL/SQL block to display employees who are top three earners in
DATABASE MANAGEMENT SYSTEM 1. Write a PL/SQL block to change address of a particular employee by taking his/her 2. Write a PL/SQL block to display number of employees for each department. 3. Write a program to delete employee details who are having age 60. 4. Write a PL/SQL block to display employees who are top three earners in the company. 5. Write a PL/SQL to delete a records whose basic salary is 20000 from Emp table. Aim: To know the usage of different sequential and conditional control structures in PL/SQL blocks. 1. Write a PL/SQL block to find the greatest of three numbers. 2. Write a PL/SQL code to print the employee’s cadre based on their basic scales as given below (hint use: case selector….)
Escuela, estudio y materia
- Institución
- DATABASE MANAGEMENT SYSTEM
- Grado
- DATABASE MANAGEMENT SYSTEM
Información del documento
- Subido en
- 12 de abril de 2023
- Número de páginas
- 18
- Escrito en
- 2022/2023
- Tipo
- Examen
- Contiene
- Preguntas y respuestas
Temas
-
database management system write a plsql block to change address of a particular employee by taking hisher
-
write a plsql block to display number of employees for each department write a plsql b