Program to perform Simple Switch CASE in PL/SQL In this Switch case is same as in C language. Only the differenc...
Read More
Program to perform EXIT statement in PL/SQL
Program to perform EXIT statement: DECLARE A int; BEGIN A:=10; LOOP DBMS_OUTPUT.PUT_LINE(A); A:=A+10; IF A>10...
Read More
Program to perform Searched Switch CASE in PL/SQL
Program to perform Searched Switch CASE in PL/SQL In this Switch case is same as in C language. Only t...
Read More
Program to perform GOTO statement in PL/SQL
Program to perform GOTO statement in PL/SQL In PL/SQL GOTO statement is same as in C language.It move the c...
Read More
Schema Table Used For Queries
****************************************************************************** Employee Table: CREATE TABLE EMP(EMPNO INT UNIQUE,ENAME V...
Read More
Write the Query in Oracle For Employee table
****************************************************************************** Employee Table: CREATE TABLE EMP(EMPNO INT UNIQUE,ENAME V...
Read More
PL/SQL NOTES
PL/SQL NOTES
Read More
STATE THE OUTPUT FOR PL/SQL CODE
--1>STATE THE OUTPUT DECLARE I NUMBER:=0; BEGIN LOOP DBMS_OUTPUT.PUT_LINE('I='||I); I:=I+1; EX...
Read More
WRITE A PL/SQL PROGRAM FOR ACCEPTING THREE NUMBER AND DISPLAY LARGEST ONE
ACCEPT THREE NUMBER AND DISPLAY LARGEST ONE DECLARE A INT; B INT; C INT; LARGE INT; BEGIN A:=&A; B:=&B; C:=&C; IF A...
Read More
WRITE A PL/SQL PROGRAM FOR EVEN NUMBER BETWEEN 1 TO 100
EVEN NUMBER BETWEEN 1 TO 100 DECLARE NUM INT; BEGIN DBMS_OUTPUT.PUT_LINE('EVEN NUMBERS: '); FOR NUM IN 1..100 LOOP IF MOD(N...
Read More
Trees and Graphs Notes
Trees and Graphs Notes Download Notes
Read More
STACKS AND QUEUES NOTES
STACKS AND QUEUES NOTES Download Notes
Read More
PRACTICAL EXAM QUESTIONS C++
PRACTICAL EXAM QUESTIONS
Read More
Linked List Notes
Linked List Notes Download Notes
Read More
WRITE A PL/SQL PROGRAM FACTORIAL OF GIVEN NUMBER BY USING WHILE LOOP
FACTORIAL OF GIVEN NUMBER BY USING WHILE LOOP DECLARE NUM NUMBER(3); FACT NUMBER(10); BEGIN NUM:=# FACT:=1; DBMS_OUTPUT.PUT...
Read More
WRITE A PL/SQL PROGRAM TO DISPLAY 1 TO 10 IN REVERSE ORDER USING FOR LOOP
TO DISPLAY 1 TO 10 IN REVERSE ORDER DECLARE I NUMBER:=10; BEGIN DBMS_OUTPUT.PUT_LINE('REVERSE NUMBER 1-10 '); FOR I IN REVER...
Read More
WRITE A PL/SQL PROGRAM UPDATE THE SALARY BY 15% WORKING IN RESEARCH AND STORE USING CURSOR
--SINGLE QUERY SELECT * FROM EMP WHERE SAL IN (SELECT * FROM (SELECT DISTINCT SAL FROM EMP ORDER BY SAL DESC) WHERE ROWNUM<5) --...
Read More
STATE THE OUTPUT FOR CURSOR
--> 1 STATE THE OUTPUT DECLARE CURSOR C1 IS SELECT * FROM EMP WHERE SAL=7000; EMP_REC C1%ROWTYPE; BEGIN DBMS_OUTPUT.PUT_LINE...
Read More
WRITE A PL/SQL PROGRAM TO PRINT RECORD OF 4TH,6TH AND 8TH USING CURSOR
TO PRINT RECORD OF 4TH,6TH AND 8TH DECLARE CURSOR C1 IS SELECT * FROM EMP; I INT:=0; BEGIN FOR R IN C1 LOOP I:=I+1; IF ...
Read More
WRITE A PL/SQL PROGRAM USING CURSOR TO PRINT NAME JOB IF EMPLOYEE HAVING DESIGNATION AS MANAGER OR ANALYST
PROGRAM USING CURSOR TO PRINT NAME JOB IF EMPLOYEE HAVING DESIGNATION AS MANAGER OR ANALYST DECLARE CURSOR C1 IS SELECT ENAME,JOB FROM ...
Read More
WRITE A PL/SQL PROGRAM FOR DISPLAYING EMPLOYEE WORKING IN COMPUTER DEPARTMENT USING CURSOR
PROGRAM FOR DISPLAYING EMPLOYEE WORKING IN COMPUTER DEPARTMENT DECLARE CURSOR C1 IS SELECT ENAME,SAL,DNAME FROM EMP,DEPT WHERE EMP.DEPTN...
Read More
STATE THE OUTPUT In Exception Handling
--1> STATE THE OUTPUT DECLARE stock_price number := 9.73; NET_EARNINGS NUMBER:=0; PE_RATIO NUMBER; BEGIN PE_RATIO := STOC...
Read More
Write a program to display star pattern 1
//this is a program to display star pattern 1 #include<iostream> #include<conio.h> using namespace std; int main() { i...
Read More
Write a program to display star pattern 2
//this is a program to display star pattern 2 #include<iostream> #include<conio.h> using namespace std; int main() { i...
Read More
Write a program to find the square of the given number
//this is a program to find the square of the given number #include<iostream> #include<conio.h> using namespace std; int ma...
Read More
Write a program to display the square and the cube of 10 numbers
//this is a program to display the square and the cube of 10 numbers #include<iostream> #include<conio.h> using namespace s...
Read More
Write a program of sorting the given array
//This is a program of sorting the given array #include<iostream> #include<conio.h> using namespace std; int main() { ...
Read More
Write a program to find the smallest among 3 numbers
//this is a program to find the smallest among 3 numbers #include<iostream> #include<conio.h> using namespace std; int ...
Read More
Write a number to find the smallest among two numbers
//this is a number to find the smallest among two numbers #include<iostream> #include<conio.h> using namespace std; int m...
Read More
Write a program to find the smallest element of the given array
//this is a program to find the smallest element of the given array #include<iostream> #include<conio.h> using namespace st...
Read More
Write a program Of searching of the array element METHOD 2
//this is a program Of searching of the array element METHOD 2 #include<iostream> #include<conio.h> using namespace std; ...
Read More
Write a program Of searching of the array element
//this is a program Of searching of the array element #include<iostream> #include<conio.h> using namespace std; int main(...
Read More
Write a program to demonstrate scope resolution operator in c++
//this is a program to demonstrate scope resolution operator in c++ #include<iostream> #include<conio.h> int x=10; using na...
Read More
Write a program to find the reverse of the entered number
//This is a program to find the reverse of the entered number #include<iostream> #include<conio.h> using namespace std; i...
Read More
Write a program to find whether the number is positive negative or zero
//this is a program to find whether the number is positive negative or zero #include<iostream> #include<conio.h> using name...
Read More
Write a program to print the star pattern in pyramid form
//this is a pattern to print the star patter in pyramid form #include<iostream> #include<conio.h> using namespace std; int ...
Read More
Write a program to find whether the entered number is palindrome or not
//This is a program to find whether the entered number is palindrome or not #include<iostream> #include<conio.h> using name...
Read More
Write a program to display number pattern 1
//this is a program to display number pattern #include<iostream> #include<conio.h> using namespace std; int main() { i...
Read More
Write a program to display number pattern 2
//this is a program to display number pattern 2 #include<iostream> #include<conio.h> using namespace std; int main() { ...
Read More
Write a program to display number pattern 3
//this is a program to display number pattern 3 #include<iostream> #include<conio.h> using namespace std; int main() { ...
Read More
Write a program of matrices addition
//this is a program of matrices addition #include<iostream> #include<conio.h> using namespace std; int main() { int a[...
Read More
Write a program to find the whether the entered year is a leap year or not
//this is a program to find the whether the entered year is a leap year or not #include<iostream> #include<conio.h> using n...
Read More
Write a program Fibonacci series
//this is a program Fibonacci series #include<iostream> #include<conio.h> using namespace std; int main() { int f1=0,f...
Read More
Write a program to find the factorial of the given program
//This a program to find the factorial of the given program #include<iostream> #include<conio.h> using namespace std; int...
Read More
Write a program to find the square of the given number
//this is a program to find the square of the given number #include<iostream> #include<conio.h> using namespace std; int m...
Read More
Write a program to find the sum of even and odd numbers
//this is a program to find the sum of even and odd numbers #include<iostream> #include<conio.h> using namespace std; int...
Read More
Write a program to demonstrate conditional operator
//this is a program to demonstrate conditional operator #include<iostream> #include<conio.h> using namespace std; int mai...
Read More
Write a program for the addition of two arrays
//this is a program for the addition of two arrays #include<iostream> #include<conio.h> using namespace std; int main() ...
Read More
Write a program of addition of two numbers and their average in C++
/*This is a program of addition of two numbers and their average in C++*/ #include<iostream> #include<conio.h> int main() {...
Read More
Write a program to find the sum of the digits
//this is program to find the sum of the digits #include<iostream> #include<conio.h> using namespace std; int main() { ...
Read More
Write a program to demonstrate inside class definition
//this is a program to demonstrate inside class definition #include<iostream> #include<conio.h> using namespace std; clas...
Read More
Write a program for Member Function for each task
/*Member Function for each task */ #include<iostream> using namespace std; class Rectangle { int l,b; public: ...
Read More
Write a program to demonstrate the out side class definition
//this is a program to demonstrate the out side class definition #include<iostream> #include<conio.h> using namespace std; ...
Read More
Write a program for Private Member Function for each task
/* Private Member Function for each task */ #include<iostream> using namespace std; class Rectangle { int l,b; void a...
Read More
Write a program for Private member function
/* Private member function */ #include<iostream> using namespace std; class Sample { int a,b; void accept() { ...
Read More
Write a program to perform Nesting of member function
/* Nesting of member function */ #include<iostream> using namespace std; class Sample { int a,b; public: ...
Read More
Write a program to perform Function Returning Object
/* Function Returning Object */ #include<iostream> using namespace std; class Sample { int a,b; public: voi...
Read More
Write a program for Array within Classes
/* Array within Classes */ #include<iostream> using namespace std; class Sample { int a[5]; public: void accept(); ...
Read More
Write a program for Array in classes
/* Array in classes */ #include<iostream> using namespace std; class Sample { int a[100],n; public: void ...
Read More
Write a program for Array of Object
/*Array of Object */ #include<iostream> using namespace std; class Student { int roll; float per; public: ...
Read More
Subscribe to:
Posts (Atom)
