How to write Store procedure in Oracle SQL plus?

Answer 1

First of all, you should get go to the Oracle site and download their free SQL Developer product. Unless there is a reason you want to use SQL*Plus.

http://www.oracle.com/technology/products/database/sql_developer/index.html

If you must use SQL*Plus, then develop your stored procedure code in a text file then execute it in SQL*Plus. Using the default editor in SQL*Plus is no fun. And with tools available that take the pain out of it, why would you want to?

Answer 2

Here is the sql:


create or replace procedure proc_name as (select 'x' from dual)


where proc_name is the name of the procedure you wish to make, and the SQL you wish to write is within the parans.

Overall SQL statement can be made into a stored proc. Also if you are curious you do not have to use the [or replace] part. It just allows you to make changes to a proc with out dropping and recreating it.

Hope this helps,

Leo