Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "oracle PL/SQL and stored procedure Analysis". In the operation of actual cases, many people will encounter such a dilemma. Then let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

PL/SQL

PL/SQL is the corresponding program language in ORACLE. Its basic structure is as follows:

Declare

Variable declaration

Begin// program starts.

...

/ / Program topic

End

/ / Program ends

If it is executed in the DOWS command, you need to execute set serverout on first and then add a backslash / to represent the command at the end of the program.

It is not necessary if it is executed in PL/SQL software

But there are two ways.

Method 1: open the SQL command window to execute

Method 2: execute directly in the SQL window

Stored procedure

Stored procedure is equivalent to the functional module in PL/SQL and has the ability to complete part of the function.

Language structure:

Create or replace procedure stored procedure name (arbitrary, just a name, easy to call) (parameters) tips: the parameters here can have output parameters as well as output parameters.

Is

Declare variable

Begin// function module starts

...

/ / body part

End

Mode of use:

Execute the stored procedure name (parameter) in PL/SQL

Function

If you implement the functional block, but there is still a difference between good stored procedures.

Language structure:

Create or replace function function name

Return data type (the data type of the last value returned by your function)

Define variable

Begin

/ / Program body

Return

End

/ / Program ends

The difference between functions and stored procedures:

This is the end of "oracle PL/SQL and stored procedure Analysis". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.