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

Oracle Merge Statement Delta Detection

The MERGE Syntax by Ajay Nerumati Delta Detection in Oracle SQL Posted on  8. October 2016 Delta detection is a common task in every Data Warehouse. It compares new data from a source system with the last versions in the Data Warehouse to find out whether a new version has to be created. There are several ways to implement this in Oracle. Your source system delivers a full extraction every night, and you have to load only the changed rows into your Core Data Warehouse? You receive incremental loads from another source system every few minutes, but only a few columns are loaded into the Data Warehouse. In all these situations, you need a delta detection mechanism to identify the rows that have to be inserted or updated in your Data Warehouse tables. In this blog post, I want to show different methods in Oracle SQL that provide the subset of rows of a source table that were changed since the last load. All these methods are set-based, i.e. they can be executed in one SQL sta...
199 comments
Read more

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

FOREIGN KEY

Pre-requisits : General understanding of integrity constraints. Constrains are used to prevent invalid data into the table. Integrity constrains are business rules enforced on the data in a table. The enforced rules trigger whenever a row is inserted, updated, or deleted from that table and prevent data that does not meet the set rules. FOREIGN KEY :  Establishes and enforces a relationship between two tables or to the same table itself. The foreign key or referential integrity constraint, designates a column or combination of columns as a foreign key and establishes a relationship between a primary key or a unique key in the same table or a different table.  In the example below   Emp_child  table's deptno   has been defined as the foreign key ; it references the deptno column of the Dept_parent table. Implementation: Step 1 Create parent table DEPT_PARENT as follows: Create table DEPT_PARENT ( Deptno n...
79 comments
Read more