Oracle
miomitac
Hi
展开
-
Oracle锁表解决办法
SELECT sid, serial#, username, osuser FROM v$session; ALTER SYSTEM KILL SESSION sid,serial;转载 2007-03-07 17:48:00 · 952 阅读 · 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 · 483 阅读 · 0 评论 -
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 · 470 阅读 · 0 评论 -
在所有表中查询
SELECT 92073,Table_name FROM ALL_TABLES原创 2007-03-20 16:42:00 · 389 阅读 · 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 · 748 阅读 · 1 评论