Assignments And Worksheet Solutions

Create a trigger that checks if "value" is greater than 1000 for any new row inserted to "Test" table, then insert a row to Audit table?

Write a trigger to ensure that no employee of age less than 25 can be inserted in the database.

Create a package which contains a procedure to accept a text and to check whether it is palindrome or not.

Write a PL/SQL program to convert a temperature in scale Fahrenheit to Celsius and vice versa.

Create department table with the following structure. Name Type Deptno Number Deptname Varchar2(10) location Varchar2(10)