1. Write a PL/SQL code to retrieve the employee name, join_date, and designation of an employee whose number is input by the user (employee table).
2. Write a row trigger to insert the existing values of the employee table into a new table when the salary table is updated.
3. Create a stored function that accepts 3 numbers and 2 operators (+/-*) and performs the calculations based on the input. Also write the code to call your function.
4. Write a PL/SQL Program which raises a user defined exception if the input date is Friday?
Hint: char(DATE,’DY’) returns the DAY NAME
5. Write a PL/SQL Program which can handle 3 different predefined oracle exceptions?
6. Write a PL/SQL cursor program to display all employee names and their salary from employee table by using % not found attributes?
7. Create a package which consists of procedure and functions and having one procedure called in another procedure? also write the code to call your function and procedure from package?
8. Write After insert PL/ SQL Trigger which uses all the conditional Predicates (ex: Updating etc..,)
9. Create a view on Employee and works table and update the view using instead of trigger?
10. Plsql program to reverse a string with out using string function?
11. How Can we execute DDL statements in PLSQL? Give an example procedure which creates a table?
12. What are the different types of loops in PLSQL? Write a program to print odd numbers from 1000 to 500?
13. Write a PLSQL Program to increase the salary by 10% for top 5 employees and 5% for the remaining employees?
2. Write a row trigger to insert the existing values of the employee table into a new table when the salary table is updated.
3. Create a stored function that accepts 3 numbers and 2 operators (+/-*) and performs the calculations based on the input. Also write the code to call your function.
4. Write a PL/SQL Program which raises a user defined exception if the input date is Friday?
Hint: char(DATE,’DY’) returns the DAY NAME
5. Write a PL/SQL Program which can handle 3 different predefined oracle exceptions?
6. Write a PL/SQL cursor program to display all employee names and their salary from employee table by using % not found attributes?
7. Create a package which consists of procedure and functions and having one procedure called in another procedure? also write the code to call your function and procedure from package?
8. Write After insert PL/ SQL Trigger which uses all the conditional Predicates (ex: Updating etc..,)
9. Create a view on Employee and works table and update the view using instead of trigger?
10. Plsql program to reverse a string with out using string function?
11. How Can we execute DDL statements in PLSQL? Give an example procedure which creates a table?
12. What are the different types of loops in PLSQL? Write a program to print odd numbers from 1000 to 500?
13. Write a PLSQL Program to increase the salary by 10% for top 5 employees and 5% for the remaining employees?
