摘要:
create or replace procedure myprocedure is CURSOR CUR_TEST IS --声明显式游标 SELECT ECODE,ENAME FROM EMP; CUR CUR_TEST%ROWTYPE; --定义游标变量,该变量的类型为基于游标C_EMP的记录 阅读全文
摘要:
CREATE SEQUENCE seqTestminvalue 1maxvalue 99999999START WITH 233 -- 从233开始计数INCREMENT BY 1 -- 每次加几个--NOMAXvalue -- 不设置最大值--NOCYCLE -- 一直累加,不循环CACHE 20 阅读全文
摘要:
#/bin/shprocess_=`sqlplus -s dcm/dcm@215.8.7.57:11521/dcsdb<<EOFset linesize 300;set heading off feedback off pagesize Overify off echo numwidth 40ins 阅读全文