SQL
miomitac
Hi
展开
-
PL/SQL参数作为表
CREATE OR REPLACE PROCEDURE SIGN_REJECT IS mail_list long; context long; r_mail varchar2(50); a_mail varchar2(50); sqlstr1 long; sqlstr2 long;BEGIN context:=If you can not see the原创 2007-03-14 17:35:00 · 459 阅读 · 0 评论 -
员工卡PL/SQL
CREATE OR REPLACE PROCEDURE TO_IODATAMRC ISin_t VARCHAR2(8);out_t VARCHAR2(8);tmp_date VARCHAR2(8);num integer;tmp_empno VARCHAR2(8); CURSOR Cur1(THISDATE VARCHAR2 default TO_CHAR(trunc(sysdate)))原创 2007-03-14 17:36:00 · 474 阅读 · 0 评论 -
在所有表中查询
SELECT 92073,Table_name FROM ALL_TABLES原创 2007-03-20 16:42:00 · 382 阅读 · 0 评论 -
从数据库随机抽取固定行数的数据
select * from (select * from ps_employee where (salary_type=1 or salary_type=7) and status=1 order by dbms_random.value) where rownum原创 2007-04-10 16:55:00 · 738 阅读 · 1 评论