- Category:
- Oracle
- Tags:
-
[WORD]
- File Size:
- 25kb
- Update:
- 2016-04-14
- Downloads:
- 0 Times
- Uploaded by:
- 郭帅
Description:
The Oracle stored procedure 1
Basic knowledge of Oracle stored procedure 1
2 the Oracle stored procedure of the basic grammar
Several problems about the Oracle stored procedure memo 4
1. In Oracle, alias added as data table. 4
2. In the process of storage, a field, must follow into behind, if the entire record, using a cursor is another matter. 5
3. In the use of the select... Into... Grammar, have to ensure that the has a record of this, or you will quote us \ no data found\ exception. 5
4. In the process of storage, alias not same with the field name, otherwise while compiling can pass, but an error in the operation phase 5
5. In the process of storage, null problem about 5
6. Hibernate calls the Oracle stored procedure 6
With Java calls the Oracle stored procedure summarizes six
A stored procedure 6, no return value
Second, returns a value of the stored procedure (not list) 8
Three, the returned list
In the process of sto
To Search:
File list (Check if you may need any files):
oracle.doc