Skip to main content

Oracle Procedure

/*CREATING PROCEDURE
/*DBMS:SCOTT/TIGER:ORACLE 9i*/

create or replace
PROCEDURE addNewEmp(
VEMPNO EMP.EMPNO%TYPE,
VENAME EMP.ENAME%TYPE,
VJOB EMP.JOB%TYPE,
VMGR EMP.MGR%TYPE,
VHIREDATE EMP.HIREDATE%TYPE,
VSAL EMP.SAL%TYPE,
VCOMM EMP.COMM%TYPE,
VDEPTNO EMP.DEPTNO%TYPE)
AS
 BEGIN
   INSERT INTO EMP(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO)
   VALUES(VEMPNO,VENAME,VJOB,VMGR,VHIREDATE,VSAL,VCOMM,VDEPTNO);
 END addNewEmp;




/*EXECUTING PROCEDURE

BEGIN
  addNewEmp(7999,'DIBYENDU','ANALYST',9999,'03-JAN-2008',25700,1250,30);
END;
Labels:

Comments

Post a Comment

Popular posts from this blog

Sample : String Reverse In Java

import java.io.*; class test {     public static void main(String args[])     {         DataInputStream in=new DataInputStream(System.in);         try         {             String text;             System.out.println("\nEnter The Text");             text=in.readLine();             System.out.println("\nIn Reverse Order::\n");             for(int i=text.length()-1;i>=0;i--)             {                 System.out.print(text.charAt(i));             }          ...
Post a Comment
Read more

Getting Browser Information in javaScript

<html> <head> <script> function getBrowserName() { tag_link.innerHTML="You are surfing internet through  "+'<b>'+navigator.appName+'</b>'+" browser family." } </script> </head> <body onLoad="getBrowserName()"> <center> <p id="tag_link" style="font-size:30"></p> </center> </body> </html>
Post a Comment
Read more