Scribd
Upload
68 views1 page

PLSQL Assignment

The document outlines a series of PL/SQL programming tasks related to an Employee table, including calculating incentives, adjusting salaries, and checking conditions such as even/odd numbers and weekend dates. It also includes instructions for using comments, creating implicit cursors, and displaying records using cursors with exit conditions. Each task requires writing specific PL/SQL blocks or procedures to achieve the desired functionality.

Uploaded by

Sruti Mishra
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
68 views1 page

PLSQL Assignment

The document outlines a series of PL/SQL programming tasks related to an Employee table, including calculating incentives, adjusting salaries, and checking conditions such as even/odd numbers and weekend dates. It also includes instructions for using comments, creating implicit cursors, and displaying records using cursors with exit conditions. Each task requires writing specific PL/SQL blocks or procedures to achieve the desired functionality.

Uploaded by

Sruti Mishra
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

Consider an Employee table having the attributes Employee_ID, First_Name, Last_Name, Email,

Phone_Number, Joining_Date, Salary, Manager_ID and Employee_ID).

Solve the given questions

Q1 Write a PL/SQL Block to calculate the incentive of employee whose ID is 110

Q2 Write a PL/SQL block to explain the single line and multiline comments

Q3Write a PL/SQL Block to adjust the salary of employee whose ID is 122

Q4 Write a PL/SQL Procedure to calculate the incentive on a target achieved and display the message
whether record updated or not.

Q5 Write a PL/SQL program to check whether a number is even or odd.

Q6 Write a PL/SQL program to check whether a date falls on weekend i.e. SATURDAY or SUNDAY.

Q7 Write a PL/SQL program to display the description against GRADE using case statement

Q8 Write a program in PL/SQL to create an implicit cursor with for loop.

Q9 Write a program in PL/SQL to retrieve the records from the employees table and display them
using cursors using Exit When loop.

You might also like