Oracle learning notes: stored procedures with returned lists

Create sqlCREATETABLEstudent (student_idNUMBERPRIMARYKEY, student_namevARCHAR2 (30) NOTNULL) inserti

Create table SQL create table student (student_id number primary key, student_name vARCHAR2 (30) not null) insert I

Oracle learning notes: stored procedures with returned lists

[Date: 2012-01-03] Source: Linux Author: zxingchao2009 [Font:]

Table creation SQL

Create package

Java call

Output result:

Student ID = 1, Student Name = John
Student ID = 2, Student Name = Li Si
Student ID = 3, Student Name = Wang Wu
Student ID = 4, Student Name = ma 6
Student ID = 5, Student Name = Sun Qi
Student ID = 6, Student Name = wang ba

,