Welcome to UPES - Tech Community | Dehradun
- Start new topics and reply to others
- Subscribe to topics and forums to get email updates
- Get your own profile page and make new friends
- Send personal messages to other members.
- Online chat support - 24/7 for your queries,engage with others.
Submitter
File Information
- Submitted: Oct 03 2016 03:56 PM
- Last Updated: Oct 03 2016 03:56 PM
- File Size: 10.16KB
- Views: 2397
- Downloads: 830
Download ADBMS LAB 4th, 5th & 6th Solutions - Download
ADBMS LAB 4th, 5th & 6th Solutions - Download
EXPERIMENT-4 and 5
Title: PL/SQL Programming
1. Write a PLSQL code block to swap two numbers without taking third variable.
2. Write a PL/SQL code to accept the value of A,B & C display which is greater .
3. Using PL/SQL Statements create a simple loop that display message “Welcome to PL/SQL Programming” 20 times.
4. Write a PLSQL code block to reverse the string.
5. Write a PL/SQL code block to find total and average of 6 subjects and display the grade.
6. Write a PL/SQL code block to check whether the given number is Armstrong number or not.
7. Write a PLSQL code block to accept table name and display number of rows in a table.
8. Write a PLSQL code block generate table of a given number and store result in two column table.
9. Write a PLSQL code block to generate simple interest and store Principal, Interest rate, time and simple Interest in a table.
10. Write a PL/SQL Code block program to accept a deptno and display who are working in that dept?
11. Consider the following table to write PL/SQL code as specified under
Teacher (t_no, f_name, l_name, salary, supervisor, joiningdate, birthdate, title)
Class (class_no, t_no, room_no)
Payscale (Min_limit, Max_limit, grade)
· Accept a range of salary and print the details of teachers from teacher table.
· Calculate the bonus amount to be given to a teacher depending on the following conditions:
o if salary > 10000 then bonus is 10% of the salary.
o if salary is between 10000 and 20000 then bonus is 20% of the salary.
o if salary is between 20000 and 25000 then bonus is 25% of the salary.
o if salary exceeds 25000 then bonus is 30% of the salary.
· Using a simple LOOP structure, list the first 10 records of the ‘teachers’ table.· Accept the room number and display the teacher details like t_no, f_name, l_name,
· birthdate, title from table Teacher.
EXPERIMENT- 6
Title: Working with Functions/Procedures
12. Write a PL/SQL function that accepts 2 numbers and returns the addition of passed values.
13. Write a PL/SQL function that accepts number and returns the reverse of that number.
14. Write a PL/SQL procedure to calculate the sum of first N number where N is passed as parameter.
15. Write a PL/SQL function that accepts department number and returns the total salary of the department. Use table EMPLOYEE.
16. Write a PL/SQL procedure to display the average salary of each department. Use the above mention EMPLOYEE table.
Other files you may be interested in ..
- 75 Total Files
- 4 Total Categories
- 5 Total Authors
- 63,575 Total Downloads
- DCN Lab File Record With Solutions - Download Latest File
- Guest Latest Submitter
49 user(s) are online (in the past 15 minutes)
0 members, 49 guests, 0 anonymous users