Assignments And Worksheet Solutions

Create a package which contains function to ask the user to enter the student’s marks and determine the GRADE according to the following criteria.

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.

Create a procedure or function to calculate electricity bill as per the following criteria: For first 100 units: Rs. 5 per unit For 101-150 units: Rs. 7 per unit For 151-300 units: Rs. 7.50 per unit For 301 onward units: Rs. 8 per unit

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)