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:'Calibri','sans-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_ varchar2,address_ varchar2,deptid_ varchar2) as begin insert into employee(name,address,deptid) values(name_,address_,deptid_); end; / 2)UPDATE_EMPLOYEE: CREATE OR REPLACE procedure MEGATEST.UPDATEEMPLOYEE(id_ integer,name_ varchar2,address_ varchar2,deptid_ varchar2) is begin update employee set NAME=name,ADDRESS=address,DEPTID=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 id,name,address,deptid from employee; end; /

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

Answers (1)