|
Hello World in PlSql:
|
|
Sum of number between 1 to 100:
|
|
Calculate The Net Salary:
|
|
Find the greatest among three numbers:
|
|
Calculate area and perimeter of circle:
|
|
Sum of odd number between 1 to 100:
|
|
How to define Variable(just adding two numbers):
|
|
Using Iteration In Pl/sql:
|
|
Looping(Print Even Number 1 to 100):
|
|
Print Odd numbers between 1 to 100:
|
|
Reverse Of a Number:
|
|
Factorial of a number:
|
|
Check a no amstrong or not:
|
|
Print Fibonacci Series:
|
|
Prime number:
|
|
How to use substitution variables :
|
|
Comosite type example:
|
|
Composite Rowtype example:
|
|
Composite Record Type:
|
|
How to raise error:
|
|
Using Cursor Select the Common deptno In Emp and Dept Table:
|
|
Simple Cursor Example:
|
|
Implecit Cursor Example:
|
|
Insert Update Delete in a Table:
|
|
How to Create procedure:
|
|
Inserting Using Procedure and Cursor:
|