1. stored Procedures, functions, and triggers are all written in plsql. the process, function, and trigger are in the Oracle database. plsql is a very powerful database process Language 4. stored Procedures and functions can be used to call more Oracle Data in Java. video tutorial: 2.taobao.comitem.htm? Id42922011874spm686.1000925.0
1. stored Procedures, functions, and triggers are written in pl/SQL. procedures, functions, and triggers are 3.pl/ SQL statements in Oracle databases, which are very powerful database Process Languages. 4. stored Procedures, functions can be called in Java program more Oracle data, video tutorial: http://2.taobao.com/item.htm? Id = 42922011874spm = 686.1000925.0
1. Stored Procedures, functions, and triggers are all written in pl/SQL.
2. The process, function, and trigger are in the Oracle database.
3. pl/SQL is a very powerful database process Language
4. stored procedures and functions can be called in Java programs.
More Oracle documents and video Tutorials:
Http://2.taobao.com/item.htm? Id = 42922011874 & spm = 686.1000925.0.0.ZVvkz6 & mt =
Pl/SQL concepts:
Benefits:
Disadvantages:
Poor pl/SQL portability
Modular Design Concept: (Instance) Paging process, order process, transfer process ......
More Oracle documents and video Tutorials:
Http://2.taobao.com/item.htm? Id = 42922011874 & spm = 686.1000925.0.0.ZVvkz6 & mt =
Sqlplus Programming
Instance:
1. Write a stored procedure that can add records to a table
Create procedure sp_pro1 is // name of the stored procedure
Begin
-- Execution part
Insert into mytest values ('zhang san', '201312'); // table name
End;
Note: how to view error information,
Write: show error;
How to call this process:
1): exec process name (parameter value 1, parameter value 2 ......);
For example, the above process is called: exec sp_pro1;
2 ):
Write SQL/Developer:
Create procedure sp_pro2 is
Begin
-- Execution part
Delete from mytest where name = 'zhangsan ';
End;
Introduction:
More Oracle documents and video Tutorials:
Http://2.taobao.com/item.htm? Id = 42922011874 & spm = 686.1000925.0.0.ZVvkz6 & mt =
Pl/SQL block:
More Oracle documents and video Tutorials:
Http://2.taobao.com/item.htm? Id = 42922011874 & spm = 686.1000925.0.0.ZVvkz6 & mt =
Pl/SQL block instances:
Set serveroutput off -- disable the output option
More Oracle documents and video Tutorials:
Http://2.taobao.com/item.htm? Id = 42922011874 & spm = 686.1000925.0.0.ZVvkz6 & mt =
Expansion:
More Oracle documents and video Tutorials:
Http://2.taobao.com/item.htm? Id = 42922011874 & spm = 686.1000925.0.0.ZVvkz6 & mt =