oracle用存儲過程插入一條數(shù)據(jù)（用序列實(shí)現(xiàn)）？首先創(chuàng)建一個序列create sequence seq1increment by 1start with 1maxvalue 999999999測試表

oracle用存儲過程插入一條數(shù)據(jù)（用序列實(shí)現(xiàn)）？

首先創(chuàng)建一個序列create sequence seq1increment by 1start with 1maxvalue 999999999測試表create table a(a number(20)，b varchar2(10))其次創(chuàng)建存儲create or replace procedure pro_insert(a_p in varchar2)isbegin insert into a (a，b) values (seq1.nextval，a_p) ---seq1.nextval是表示已經(jīng)有的序列上加1 commitend pro_insert插入數(shù)據(jù)SQL> set serveroutput onSQL> execut pro_insert("a") PL/SQL procedure successfully completed SQL> select * from a A B--------------------- ---------- 2 a

oracle存儲過程查數(shù)據(jù)并生成文件怎么實(shí)現(xiàn)？

create or replace procedure p_cnt(p_time in varchar2，---查詢的條件p_cur out SYS_REFCURSOR)---游標(biāo)返回ISv_sql varchar2(1000) :=""v_date varchar2(20)BEGIN v_date := replace(p_time， "-"， "")---時間的格式轉(zhuǎn)換 v_sql := "select * from dapartment d where d.d_time ="""|| v_date||""""END OPEN p_cur FOR v_sqlEND p_cnt