Jump to content

  • twitter
  • youtube

Welcome to UPES - Tech Community | Dehradun


Sign In 

Create Account
Welcome to UPES - Tech Community | Dehradun, like most online communities you must register to view or post in our community, but don't worry this is a simple free process that requires minimal information for you to signup. Be apart of UPES - Tech Community | Dehradun by signing in or creating an account.
  • 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.
 

About US

UPES - Tech Community helps the students to find study materials for different engineering specialties like mechanical, civil, electrical, computer science and electronics etc.The community is also sharing the year wise question papers of UPES, Dehradun and even comprised up with latest technology aspects, news, events, tutorials and various types of digital gadget reviews.

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 ..





49 user(s) are online (in the past 15 minutes)

0 members, 49 guests, 0 anonymous users



Discussion | Topics
Community Guidance
Useful Resources
Connect With Us

Copyright © 2018 UPES - Tech Community | Dehradun. All Rights Reserved.