pl/sql program to insert a space after each letter in a given string.
Procedure:
declare
str varchar(10):='&str';
len number(2);
i number(3):=1;
newstr varchar(20);
begin
len:=length(str);
while i<=len
loop
...
Monday, 30 June 2014
undefined
undefined
ORACLE-FORU - PL/SQL code for SPACE AFTER EACH LETTER
Posted by Unknown in PL_SQL
No comments
undefined
undefined
ORACLE-FORU - PL/SQL code for LETTER BY LETTER
Posted by Unknown in PL_SQL
No comments
pl/sql program to print a string in a letter by letter format.
Procedure:
declare
str varchar(10):='&str';
len number(2);
i number(3):=1;
begin
len:=length(str);
while i<=len
loop
Dbms_output.put_line(substr(str,i,1));
...
undefined
undefined
ORACLE-FORU - PL/SQL code to check given number is EVEN OR ODD
Posted by Unknown in PL_SQL
No comments
pl/sql program to find given number is even or odd.
Procedure:
Declare
n number(4):=&n;
Begin
if mod(n,2)=0
then
dbms_output.put_line(n||' even number');
else
dbms_output.put_line(n||' odd number');
end if;
end;
/
Execution:
SQL> @e:\plsql\even.sql
Enter...
undefined
undefined
ORACLE-FORU - PL/SQL code for FIBINOCCI SERIES
Posted by Unknown in PL_SQL
No comments
pl/sql program to generate fibinocci series.
Procedure:
declare
a number(3):=1;
b number(3):=1;
c number(3);
n number(3):=&n;
begin
Dbms_output.put_line('the fibinocci series is:');
while a<=n
loop
dbms_output.put_line(a);
...
undefined
undefined
ORACLE-FORU - PL/SQL code for Reverse Of A Number
Posted by Unknown in PL_SQL
No comments
pl/sql program to generate reverse for given number.
Procedure:
declare
n number(4):=&n;
s number(4):=0;
r number(4);
begin
while n>0
loop
r:=mod(n,10);
s:=(s*10)+r;
n:=trunc(n/10);
end loop;
dbms_output.put_line(‘the...
undefined
undefined
ORACLE-FORU - PL/SQL code for FACTORIAL OF A NUMBER
Posted by Unknown in PL_SQL
2 comments
pl/sql program to finding factorial of given number.
Procedure:
declare
i number(4):=1;
n number(4):=&n;
f number(4):=1;
begin
for i in 1..n
loop
f:=f*i;
end loop;
Dbms_output.put_line('the factorial of '||n||'...
undefined
undefined
ORACLE-FORU - PL/SQL code for PRIME NUMBER
Posted by Unknown in PL_SQL
4 comments
pl/sql program to check weather given number is Prime or not.
Procedure:
declare
num number;
i number:=1;
c number:=0;
begin
num:=#
for i in 1..num
loop
if((mod(num,i))=0)
...
undefined
undefined
ORACLE-FORU - PL/SQL code for MULTIPLES OF 5
Posted by Unknown in PL_SQL
No comments
To write a pl/sql program for finding Multiples of 5.
Procedure:
declare
i number(3):=5;
n number(3):=&n;
Begin
Dbms_output.put_line('the multiples of 5 are:');
while i<=n
loop
dbms_output.put_line(i);
i:=i+5;
...
undefined
undefined
ORACLE-FORU - PL/SQL Code for Sum of two number
Posted by Unknown in PL_SQL
5 comments
To write a pl/sql program to find sum of two numbers.
Procedure:
Declare
i number(3);
j number(3);
k number(3);
Begin
i:=&i;
j:=&j;
...
Saturday, 28 June 2014
undefined
undefined
ORACLE-FORU - Oracle all Important Functions with Examples
Posted by Unknown in PL_SQL
No comments
Oracle Functions
ASCII
Returns the ASCII value (NUMBER) that represents the specified character.
ASCII(SINGLE_STRING)
ASCII('t')...
undefined
undefined
Normalization In SQL
Posted by Unknown in SQL
No comments
Normalization In SQL,MY SQL and Oracle
What is normalization ?
Defination : Normalization is the process of efficiently organizing data in a database.
There are two goals of the normalization process:
1. eliminating redundant data (for example, storing the same data in more than one table) and
2. ensuring data dependencies make sense (only storing related data in a table).
Both...
Friday, 27 June 2014
undefined
undefined
How to attach a Menu to a oracle form
Posted by Unknown in Oracle
No comments
Here are the following steps to attach Menu to a oracle forms:
1. I create a form named as form1. i save it to c:\form1. A file name form1.fmb created at c drive.
2. now i run the form from within form builder a file generated to c drive with name form1.fmx
3. i create a menu in form builder. save it to drive c with name test. A file test.mmb created there.
4. i compile this menu module using CTRL...
undefined
undefined
MDI Form in Oracle Forms Maximize
Posted by Unknown in Oracle
No comments
For Example:-
In the Form
module 1
trigger
Create New trigger
WHEN-NEW-FORM-INSTANCE
Begin
set_window_property('window1', window_state, maximize);
SET_WINDOW_PROPERTY(FORMS_MDI_WINDOW, WINDOW_STATE, MAXIMIZE);
end;
Window1 is Your Form Window Na...
undefined
undefined
SQL Functions(ddl,dml,dcl & tcl) with Examples
Posted by Unknown in SQL
No comments
There are 4 types of sql functions
1.DML
2.DDL
3.DCL
4.TCL
Now lets see one by one
1.DML
DML is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify, delete, insert and update data in database.
Examples: SELECT, UPDATE, INSERT statements
Select :- This Sql Statement is used to extract the data from one or combination of tables
Update:- This Sql Statement is used...
Subscribe to:
Posts (Atom)