ITPub博客

<style.</style.第二十章 管理过程、函数、触发器管理过程 过程是命名的PL/SQL程序，被保存到数据库中。 匿名的PL/SQL块无法保存到数据库中，它...

<style.</style.promptprompt Creating sequence DVR_CHIEF_DVR_ID_SEQprompt ======================================promptcreate sequence MRP.DVR_CHIEF_DVR_ID_SEQminvalue 1...

 selectt2.username,t2.sid,t2.serial#,t2.logon_time,t2.OSUSER,t2.PROGRAM,t3.OBJECT,t3.TYPEfrom v$session t2,v$locked_object t1,v$access t3 wheret3.OWNER=t2.USERNAME and t2.SID=t1.SESS...

http://space.itpub.net/15843490/viewspace-584423

SELECT * FROM  (SELECT PARSING_USER_ID EXECUTIONS,SORTS,COMMAND_TYPE,DISK_READS,sql_text FROM  v$sqlarea ORDER BY disk_reads DESC)  WHERE ROWNUM<10

select 'drop table '||table_name||' cascade constraints;' fromuser_tables;

如：select  * from table_name where column1 like 'w\_%'escape'\'

http://gjm008.itpub.net/

  1 #!/bin/sh  2 date=date;  3 ss=`$date +%Y%m%d`;  4 sd=$[ss-1];  5 #sd="20080630";  6 cp -a  /mnt/cnsrv158/mpe_db_$sd.txt  /mnt/hd06/DB_backup&...

::::::::::::::backup_0_sun.rms::::::::::::::run{allocate channel c1 type disk maxpiecesize=8G;allocate channel c2 type disk maxpiecesize=8G;allocate channel c3 type disk maxpiecesize...

    1 LANGUAGE=zh_TW.UTF-8:zh_TW.Big5:zh_TW:zh_HK:zh      2 GTK_IM_MODULE=gcin      3 LC_ADDRESS=zh_TW.UTF-8  &nb...

1.1 need package<style.</style.make-3.79.1gcc-3.2.3-34glibc-2.3.2-95.20compat-db-4.0.14-5c...