摘要:
1、无返回值的存储过程create or replace procedure test_procisbegin insert into student values('003','mark',27,'s2012090503','15000778382'); commit;end test_proc;2、有单个数据值返回的存储过程create or replace procedure test_proc_return(temp_name in varchar2,temp_age out number) isage_1 number; 阅读全文
摘要:
1、建立两张表进行存储过程深入学习create table STUDENT(USER_ID VARCHAR2(64),STUDENT_NAME VARCHAR2(64),AGE NUMBER(2),STUDENT_ID VARCHAR2(64),MOBILE VARCHAR2(64));create table STUDENT_INFO(STUDENT_ID VARCHAR2(64),HOBBY VARCHAR2(64),HEIGHT NUMBER(3,2),WEIGHT NUMBER(4,2));STUDENT_INFO表中STUDENT_ID字段关联STUDENT表2、往两个表中分别插入数 阅读全文