Category: PL/SQL Hands-on

Insert Record into Anonymous Block - cover image

Feb. 14th, 2024 • PL/SQL

Insert Record into Anonymous Block

Create a PL/SQL block to insert a new record into the Department table..

Calculate-Area-of-a-Circle-Using-PL-SQL - cover image

Feb. 25th, 2024 • PL/SQL

Calculate Area of a Circle

Write a PL/SQL block to calculate the area of a circle for the radius..

Delete all records of Department which is located in CHN-102 - cover image

Mar. 5th, 2024 • PL/SQL

Delete all records of Department

Create a PL/SQL Block to delete all the records of department,..

Display department names using cursor - cover image

Apr. 11th, 2024 • PL/SQL

Display department names using cursor

Create a PL/SQL block to display all the department names,..

Display department name and total salary expenditure of the Department - cover image

Apr. 28th, 2024 • PL/SQL

Display department name & total salary

Create a PL/SQL block to display all the department names,..

Retrieve all the information about each department - cover image

May 12th, 2024 • PL/SQL

Retrieve all information about each department

Create a PL/SQL block to retrieve all the information,..

1 2 3 4 ...