Click here to Skip to main content
15,886,664 members
Please Sign up or sign in to vote.
3.00/5 (1 vote)
See more:
Dear Developer,
I want to create simple stored procedure in oracle with passing parameter and creating select statement with where condition and with if..else clause. I am new in oracle. Its grateful for me if any body help me creating simple procedure in oracle database.
Posted

Thks 4 ur help, but I've any problem that u can answer my question. Plz create store procedure(Select, change, delete) in orcl Db

Best reguards
 
Share this answer
 
Comments
Member 12547531 28-Mar-17 1:23am    
How to create store procedure without parameter in Oracle. please help me
SQL> CREATE OR REPLACE PROCEDURE AddNewEmployee (<br />
      p_FirstName  employee.first_name%TYPE,<br />
      p_LastName   employee.last_name%TYPE,<br />
      p_Salary      employee.salary%TYPE) AS<br />
    BEGIN     INSERT INTO employee (ID, first_name, last_name,<br />
                            salary)<br />
      VALUES (student_sequence.nextval, p_FirstName, p_LastName,<br />
             p_Salary);<br />
      COMMIT;<br />
 END AddNewEmployee;<br />
   /



You can see full example Oracle Stored Procedure[^]
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900