https://blog.youkuaiyun.com/EricQLiuzh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/EricQLiu/article/details/6115673https://blog.youkuaiyun.com/EricQLiu/article/details/6115673EricQLiuTue, 04 Jan 2011 15:38:00 +08001.区分大小写--一笔记录
select * from hph where  row_id COLLATE CHINESE_PRC_CS_AS='AAAoOTAAMAAABJTAAM';

2.不区分大小写--两笔记录
select * from hph where  row_id COLLATE CHINESE_PRC_Ci_AS='AAAoOTAAMAAABJTAAM';
]]>https://blog.youkuaiyun.com/EricQLiu/article/details/6115647https://blog.youkuaiyun.com/EricQLiu/article/details/6115647EricQLiuTue, 04 Jan 2011 15:30:00 +0800https://blog.youkuaiyun.com/EricQLiu/article/details/6106858https://blog.youkuaiyun.com/EricQLiu/article/details/6106858EricQLiuThu, 30 Dec 2010 12:58:00 +0800CREATE TABLE db_ddl
    (ddl_time                       VARCHAR2(30),
    session_id                     NUMBER,
    os_user                        VARCHAR2(200),
    ip_address                     VARCHAR2(200),
    terminal]]>https://blog.youkuaiyun.com/EricQLiu/article/details/6106854https://blog.youkuaiyun.com/EricQLiu/article/details/6106854EricQLiuThu, 30 Dec 2010 12:57:00 +0800CREATE OR REPLACE VIEW db_table_used (
   segment_name,
   used_mb )
AS
SELECT   segment_name, SUM (BYTES) / 1024 / 1024 as Used_MB
    FROM user_extents
GROUP BY segment_name
order by Used_MB desc
/]]>https://blog.youkuaiyun.com/EricQLiu/article/details/6106851https://blog.youkuaiyun.com/EricQLiu/article/details/6106851EricQLiuThu, 30 Dec 2010 12:56:00 +0800CREATE OR REPLACE VIEW db_used
AS
select b.file_id　　,
　　b.tablespace_name　　,
　　b.file_name　　　　　,
　　b.bytes　/1024/1024　　　　　　total_mb,
　　(b.bytes-sum(nvl(a.bytes,0)))/1024/1024　　　used_mb,
　　sum(nvl(a.bytes,0))/1024/1]]>https://blog.youkuaiyun.com/EricQLiu/article/details/6106849https://blog.youkuaiyun.com/EricQLiu/article/details/6106849EricQLiuThu, 30 Dec 2010 12:55:00 +0800CREATE OR REPLACE VIEW db_lock (
   username,
   lock_level,
   owner,
   object_name,
   object_type,
   sid,
   serial#,
   terminal,
   machine,
   program,
   osuser )
AS
SELECT /*+]]>https://blog.youkuaiyun.com/EricQLiu/article/details/5666170https://blog.youkuaiyun.com/EricQLiu/article/details/5666170EricQLiuSat, 12 Jun 2010 11:57:00 +0800https://blog.youkuaiyun.com/EricQLiu/article/details/4039010https://blog.youkuaiyun.com/EricQLiu/article/details/4039010EricQLiuTue, 31 Mar 2009 16:40:00 +0800https://blog.youkuaiyun.com/EricQLiu/article/details/4038984https://blog.youkuaiyun.com/EricQLiu/article/details/4038984EricQLiuTue, 31 Mar 2009 16:29:00 +0800https://blog.youkuaiyun.com/EricQLiu/article/details/4008052https://blog.youkuaiyun.com/EricQLiu/article/details/4008052EricQLiuFri, 20 Mar 2009 15:10:00 +0800https://blog.youkuaiyun.com/EricQLiu/article/details/3547407https://blog.youkuaiyun.com/EricQLiu/article/details/3547407EricQLiuThu, 18 Dec 2008 10:43:00 +0800https://blog.youkuaiyun.com/EricQLiu/article/details/3450120https://blog.youkuaiyun.com/EricQLiu/article/details/3450120EricQLiuFri, 05 Dec 2008 09:04:00 +0800https://blog.youkuaiyun.com/EricQLiu/article/details/3435704https://blog.youkuaiyun.com/EricQLiu/article/details/3435704EricQLiuWed, 03 Dec 2008 11:11:00 +0800https://blog.youkuaiyun.com/EricQLiu/article/details/3435086https://blog.youkuaiyun.com/EricQLiu/article/details/3435086EricQLiuWed, 03 Dec 2008 10:04:00 +0800https://blog.youkuaiyun.com/EricQLiu/article/details/1294833https://blog.youkuaiyun.com/EricQLiu/article/details/1294833EricQLiuWed, 27 Sep 2006 16:22:00 +0800https://blog.youkuaiyun.com/EricQLiu/article/details/920043https://blog.youkuaiyun.com/EricQLiu/article/details/920043EricQLiuFri, 14 Jul 2006 11:28:00 +0800https://blog.youkuaiyun.com/EricQLiu/article/details/889494https://blog.youkuaiyun.com/EricQLiu/article/details/889494EricQLiuFri, 07 Jul 2006 14:43:00 +0800https://blog.youkuaiyun.com/EricQLiu/article/details/878831https://blog.youkuaiyun.com/EricQLiu/article/details/878831EricQLiuWed, 05 Jul 2006 08:40:00 +0800https://blog.youkuaiyun.com/EricQLiu/article/details/710605https://blog.youkuaiyun.com/EricQLiu/article/details/710605EricQLiuSat, 06 May 2006 15:11:00 +0800https://blog.youkuaiyun.com/EricQLiu/article/details/653354https://blog.youkuaiyun.com/EricQLiu/article/details/653354EricQLiuThu, 06 Apr 2006 20:53:00 +0800