ORACLE
AnotherImhere
这个作者很懒,什么都没留下…
展开
-
CAT TABS SYN DICT in Oracle
1.使用下面这个sql语句,可以获得我们非常常用的一些短小精悍的视图,这些视图通常是最常用的用户级别数据库对象SELECT * FROM dict WHERE table_name NOT LIKE '%$%' AND table_name NOT LIKE '%/_%' ESCAPE '/' AND LENGTH (table_name) SELECT * 2 FROM dict 3 WHERE table_name N转载 2011-01-09 02:26:00 · 418 阅读 · 0 评论 -
DBA_TABLES ALL_TABLES USER_TABLES in Oracle10g
ALL_TABLES describes all relational tables accessible to the current userall_tables是当前用户有访问权限的表USER_TABLES describes all relational tables owned by the current useruser_tables是当前用户所拥有的表原创 2011-01-09 01:29:00 · 1110 阅读 · 0 评论 -
Oracle Metalink Index
ID 419536.1[NLS] - How To Check A Patchset Level For One CRM Product And What NLS Are Installed ** more **原创 2011-09-26 15:21:57 · 254 阅读 · 0 评论