Monday, 30 June 2014

undefined undefined
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        ...
undefined undefined
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
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
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
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
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
pl/sql program to check weather given number is Prime or not. Procedure:   declare        num number;        i number:=1;        c number:=0;   begin         num:=&num;        for i in 1..num        loop           if((mod(num,i))=0)  ...
undefined undefined
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
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 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 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
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
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
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...
Copyright © 2025 ORACLE-FORU - SQL, PL/SQL and ORACLE D2K(FORMS AND REPORTS) collections | Powered by Blogger
Design by N.Design Studio | Blogger Theme by NewBloggerThemes.com