Skip to main content

Oracle pl sql queries


                        Oracle pl sql queries 


 1.Write a program to print the following format


2.Write a program to print the numbers from 1 to 100


3.write a program to print the even numbers from 1 to 100


4.Write a program to print the odd numbers from 1 to 100


5.write a program for multiplication table


6.write a program to find the sum of numbers from 1 to 100


7.Write a program to find the sum of all odd numbers from 1 to 100


8.Write a program to find the sum of all even numbers from 1 to 100


9.Write a program to accept a number and find how many digits it


10.Write a program to accept a number and find the sum of the digits


11.Write a program to accept a number and print it in reverse order


12.Write a program to accept a no and check whether it is Armstrong

number or not 


13.Write a porgram to generate all the Armstrong numbers from 1 to 1000


14.Write a program to generate all prime numbers between 1 to 100


15.Write a program to aceept a number and check whether it is prime

number or not


16.Write a program to display the fibonacci series from 1 to 10


17.Write a program to aceept a number and print it in binary format


18.Write a program to accept a number and find the factorial of the

number


19.Find the factorials of numbers from 1 to 10


20.Write a program to aceept a number and display it in the Octal

format

Comments

nikhil said…
This comment has been removed by the author.
June 16, 2021 at 2:21 AM
nikhil said…
Very informative.
June 16, 2021 at 2:24 AM
Akshay patil said…
very easy to understand.
June 16, 2021 at 2:24 AM
SURAJ S said…
The content is very helpful for Beginners.
Please continue posting such informational post on your blog👍
June 16, 2021 at 2:25 AM
BASANT KUMAR said…
What is the Factorial of One Hundred Before diving into the depths of the factorial of one hundred, let us first grasp the concept of factorials.

pikashow Picasso Apps is a video streaming platform from where you can watch TV Shows, Web Series, IPL Live, and the Latest Movies for free.
May 28, 2023 at 12:17 AM
Post a Comment

Popular posts from this blog

RDBMS MINI PROJECT

  Capgemini class room training.   RDBMS MINI PROJECT ( SPRINT ) LIBRARY MANAGEMENT SYSTEM   Table of Contents Serial No. Topic Name Content Page No. 1.   Introduction 1.1 Setup checklist for mini project 3     1.2 Instructions 3 2.   Problem statement   2.1 Objective 4     2.2 Abstract of the project 4     2.3 Functional components of the project 4     2.4 Technology used 5 3.   Implementation in RDBMS LOT 3.1 Guidelines on the functionality to be built 6 4.   Evaluation 4.1 Evaluation 7   ...
1 comment
Read more

PL / SQL practice programs

  PL / SQL  practice programs 1. Write a program to print the following format WELCOME TO PL/SQL PROGRAMMING   BEGIN   DBMS_OUTPUT.PUT_LINE('WELCOME   TO   PL/SQL   PROGRAMMING'); END; /   2. Write a program to print the numbers from 1 to 100   DECLARE N NUMBER(3):=1; V VARCHAR2(1000); BEGIN WHILE N <=1000 LOOP V:=V||''||N; N:=N+1; END LOOP; DBMS_OUTPUT.PUT_LINE(V); END; / 3. write a program to print the even numbers from 1 to 100 DECLARE N NUMBER(3):=0; BEGIN WHILE N <=100 LOOP N:=N+2; DBMS_OUTPUT.PUT_LINE(N); END LOOP; END; / 4. Write a program to print the odd numbers from 1 to 100 DECLARE N NUMBER(3):=1; BEGIN WHILE N <=100 LOOP N:=N+2; DBMS_OUTPUT.PUT_LINE(N); END LOOP; END; / 5. write a program for multiplication table DECLARE A NUMBER(2):=&A; B   NUMBER(2):=1; C ...
5 comments
Read more

sample tables

  --sample tables DROP TABLE EMP; DROP TABLE DEPT; DROP TABLE BONUS; DROP TABLE SALGRADE; DROP TABLE DUMMY;   CREATE TABLE EMP        (EMPNO NUMBER(4) NOT NULL,         ENAME VARCHAR2(10),         JOB VARCHAR2(9),         MGR NUMBER(4),         HIREDATE DATE,         SAL NUMBER(7, 2),         COMM NUMBER(7, 2),         DEPTNO NUMBER(2));   INSERT INTO EMP VALUES         (7369, 'SMITH',   'CLERK',      7902,         TO_DATE('17-DEC-1980', 'DD-MON-YYYY'),   800, NULL, 20); INSERT INTO EMP VALUES         (7499, 'ALLEN',   'SALESMAN',   7698,    ...
Post a Comment
Read more