How to Create Stored Procedure in Oracle 11g and Excute.

Question

hi Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:Table Normal; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:Calibrisans-serif; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Times New Roman; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin;} I need Free Download Oracle 11G For Windows 7 url needed then How to create stored Procedure From Oracle and Execute from Oracle window.

nallya · Answer

Some Basic Procedures For Oracle: 1)INSERT_EMPLOYEE: CREATE OR REPLACE procedure MEGATEST.INSERTEMPLOYEE(name_ varchar2address_ varchar2deptid_ varchar2) as begin insert into employee(nameaddressdeptid) values(name_address_deptid_); end; / 2)UPDATE_EMPLOYEE: CREATE OR REPLACE procedure MEGATEST.UPDATEEMPLOYEE(id_ integername_ varchar2address_ varchar2deptid_ varchar2) is begin update employee set NAME=nameADDRESS=addressDEPTID=deptid where ID=id_; end; / 3)DELETE_EMPLOYEE: CREATE OR REPLACE procedure MEGATEST.DELETE_EMPLOYEE(ID_ varchar2) as begin delete from employee where ID_=id; end; / 4)GET_EMPLOYEE: CREATE OR REPLACE procedure MEGATEST.getemployee(cv_results in out sys_refcursor) is begin open cv_results for select idnameaddressdeptid from employee; end; /