Oracle
w396657279
这个作者很懒,什么都没留下…
展开
-
Oracle查询表结构语句
Oracle中使用SQL查询表结构SELECT NULL AS table_cat, t.owner AS table_schem, t.table_name AS table_name, t.column_name AS column_name, DECODE (t.data_type, 'CHAR', 1,...原创 2011-04-19 10:02:43 · 937 阅读 · 0 评论 -
Oracle查询用户下所有表的SQL
Oracle中查询所有表的查询SQL SELECT * FROM all_all_tables WHERE owner = 'ODS_USER'ORDER BY table_name原创 2011-04-19 10:06:14 · 214 阅读 · 0 评论 -
Oralce查询索引的语句
SELECT i.owner AS index_owner, i.index_name, i.table_owner, i.table_name, i.uniqueness, c.column_position, c.column_name, c.descend, i.index_type, i.GENERATED, i.status, i.last_a...原创 2011-04-19 10:59:03 · 129 阅读 · 0 评论 -
Oracle学习笔记
1.查询表结构:DESCRIBE employees2.Like语句 %代表一个或多个字符。 _代表一个字符。3.数字函数 ROUND: 四舍五入 ROUND(45.926, 2) -> 45.93 TRUNC:截断 TRUNC(45.926, 2) -> 45.92 MOD: 求余 ...原创 2011-01-05 16:09:51 · 107 阅读 · 0 评论 -
查询表空间
SELECT a.tablespace_name "表空间名",round(total/1024/1024/1024,4) "表空间大小Gb",round(free/1024/1024/1024,4) "表空间剩余大小Gb", round((total-free)/1024/1024/1024,4) "表空间使用大小Gb", ROUND((total-free)/total,4)*...原创 2011-05-17 15:15:54 · 119 阅读 · 0 评论 -
查询sql执行进度
SELECT SE.SID, OPNAME, TRUNC(SOFAR / TOTALWORK * 100, 2) || '%' AS PCT_WORK, ELAPSED_SECONDS ELAPSED, ROUND(ELAPSED_SECONDS * (TOTALWORK - SOFAR) / SOFAR) REMAIN_TIME, SQL_TEXT FRO...原创 2011-05-17 15:17:07 · 1011 阅读 · 0 评论