(adsbygoogle = window.adsbygoogle || []).push({});
Experiment-18
Object: Write a PL/SQL code to find the
greatest number among the given set of numbers.
Requirement: Windows XP, Oracle 9i.
Program Code:
SQL> declare
2 a number:=&enter_a;
3 b number:=&enter_b;
4 ...
Sunday, 28 April 2013
Write a PL/SQL code to create and use process.
Experiment-17
Object:
(adsbygoogle = window.adsbygoogle || []).push({});
Write a PL/SQL code to create and use
process.
Requirement: Windows XP, Oracle 9i.
Program Code:
SQL> create or replace procedure PROCESS(A in number,B in
number,C out number,D out number,E out number,F out number) is
2 begin
3 ...
Write a PL/SQL code to get the Fibonacci Sequence
First, I will explain what is Fibonacci Sequence and how to get this series.
So, Fibonacci Sequence is a series of numbers 0,1,1,2,3,5,8,13,21.............
In Fibonacci Sequence, first and second elements are 0 and 1 and to get the next elements we will add the previous elements and it will generate the next element.
So, first element=0
...
Write a PL/SQL code to implement after row trigger.
Experiment-15
(adsbygoogle = window.adsbygoogle || []).push({});
Object: Write a PL/SQL code to implement
after row trigger. Create two tables as student_master and audit_student.
Requirement: Windows XP, Oracle 9i.
Program Code:
SQL> create table
student_master(rollno number(2), name varchar2(20), age number(2
),city varchar2(20));
Table...
Write a PL/SQL code to calculate total sal of emp having empno 100. Table emp1 having following columns: empno,ename,bp,da,hra,total.
Experiment-14
(adsbygoogle = window.adsbygoogle || []).push({});
Object : Write a PL/SQL code to calculate
total sal of emp having empno 100. Table emp1 having following columns:
empno,ename,bp,da,hra,total.
Requirement: windows XP, Oracle 9i.
Program Code:
SQL>
create table emp1
2
(empno varchar(5),
3
empname...
Cursor in PL/SQL.
Experiment-13
Object: Write a program in PL/SQL to display
the employee number and name of top 5 highest paid.
(adsbygoogle = window.adsbygoogle || []).push({});
Requirements: Windows XP, Oracle 9i.
Program Code:
SQL>
create table empdb
2
(empname char(25),
3
empsal number(10));
Table
created.
SQL>
insert...
