Oracle Stored Procedure example

Create procedure procedue_name
[@ Parameter data_type] [output]
[With] {recompile | encryption}
As
SQL _statement
Output: this parameter can be returned.

With {recompile | encryption}

Recompile: Indicates re-compiling every time this stored procedure is executed.

Encryption: the content of the created stored procedure is encrypted.

The table book content is as follows:

Title price

001 C language entry $30

002 PowerBuilder report development $52

Example 1: query the table Book content

Create proc query_book
As
Select * from book
Go
Exec query_book

1 2 Next Page

[Content navigation]
Page 1st: oracle Stored Procedure instance description	Page 2nd: oracle Stored Procedure instance description