Database Management > QUESTIONS & ANSWERS > DATABASE MANAGEMENT SYSTEM _Write a PL/SQL block to change address of a particular employee by takin (All)
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 the company.
Document Content and Description Below
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….) [Show More]
Last updated: 2 years ago
Preview 1 out of 18 pages
Buy this document to get the full access instantly
Instant Download Access after purchase
Buy NowInstant download
We Accept:
Reviews( 0 )
$7.50
Can't find what you want? Try our AI powered Search
Document information
Connected school, study & course
About the document
Uploaded On
Apr 12, 2023
Number of pages
18
Written in
All
Additional information
This document has been written for:
Uploaded
Apr 12, 2023
Downloads
0
Views
105
