| 本月文章推荐 |
sqlplus 技巧 spool 指定格式的文件发表日期：2008-2-9
|
|
sqlplus的技巧实在是多，以后慢慢总结了。
SQL> column F new_val F
SQL> select to_char(sysdate,'yyyymmddhh24miss')'.txt' F from dual; F ------------------ 20050124174926.txt SQL> spool &F Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - ProdUCtion With the Partitioning option JServer Release 8.1.7.0.0 - Production SQL> column F new_val F SQL> select to_char(sysdate,'yyyymmddhh24miss')'.txt' F from dual; F ------------------ 20050124174926.txt SQL> spool &F SQL> select * from tab; TNAME TABTYPE CLUSTERID ------------------------------ ------- ---------- EMP TABLE FK1 TABLE HASHTAB TABLE HASHTAB5 TABLE HASHTABLE TABLE HASHTABT TABLE MLOG$_T TABLE MLOG$_T_MASTER TABLE OB TABLE PK1 TABLE PLAN_TABLE TABLE TNAME TABTYPE CLUSTERID ------------------------------ ------- ---------- RUPD$_T TABLE RUPD$_T_MASTER TABLE T TABLE TCAAA TABLE TESTLONG TABLE TESTLONG2 TABLE TRAN TABLE TTTT TABLE T_MASTER TABLE VVV TABLE 21 rows selected. SQL> spool off SQL> host type &F SQL> select * from tab; TNAME TABTYPE CLUSTERID ------------------------------ ------- ---------- EMP TABLE FK1 TABLE HASHTAB TABLE HASHTAB5 TABLE HASHTABLE TABLE HASHTABT TABLE MLOG$_T TABLE MLOG$_T_MASTER TABLE OB TABLE PK1 TABLE PLAN_TABLE TABLE TNAME TABTYPE CLUSTERID ------------------------------ ------- ---------- RUPD$_T TABLE RUPD$_T_MASTER TABLE T TABLE TCAAA TABLE TESTLONG TABLE TESTLONG2 TABLE TRAN TABLE TTTT TABLE T_MASTER TABLE VVV TABLE 21 rows selected. SQL> spool off SQL> |
| 上一篇：开发工具介绍Oracle Internet Developer
人气:609 下一篇：同条SQL,有时buffer get会暴增 人气:623 |
| 浏览全部Oracle教程的内容
Dreamweaver插件下载 网页广告代码 祝你圣诞节快乐 2009年新年快乐 |
