Oracleêy?Y?aSQLPLUS?D????3£ó?setó???

来源:未知 责任编辑:责任编辑 发表时间:2015-09-16 20:05 点击:

?ú′ó?òD′??±?μ?ê±oò£??ò??3£3£ó?setó????úéè??ò?D?Dèòaμ???ê?1?·??£????£?áD?ùá?????3£??setó???μ?ó|ó??£


SQL> set echo on?a?a?a?a?a?a?a?a?a?a?a?a?a?a?a?a?aéè????DD?üá?ê?ê?·???ê?ó???


SQL> set feedback on?a?a?a?a?a?a?a?a?a?a?a?a?a?a?a-éè????ê??°ò?????XXDD?±


SQL> set colsep | ?a?a?a?a?a?a?a?a?a?a?a?a?a?a?a?a?aéè??áDó?áD????μ?·???·?o?


SQL> set pagesize 10?a?a?a?a?a?a?a?a?a?a?a?a?a?a?a¨Céè????ò?ò3μ?DDêy


SQL> SET SERVEROUTPUT ON?a?a?a?a?a?a?a?a?a?a-éè???êDí??ê?ê?3?àà??dbms_output.putline


SQL> set heading on?a?a?a?a?a?a?a?a?a?a?a?a?a?a?a?aéè????ê?áD??


SQL> set timing on?a?a?a?a?a?a?a?a?a?a?a?a?a?a?a?a¨Céè????ê??°ò?ó?ê±??£oXXXX?±


SQL> set time on?a?a?a?a?a?a?a?a?a?a?a?a?a?a?a?a?a¨Céè????ê?μ±?°ê±??


SQL> set autotrace on?a?a?a?a?a?a?a?a?a?a?a?a?a?a?a¨Céè???êDí???′DDμ?sql??DD·???


00:38:28 SQL> set echo on


00:38:37 SQL> @E:echo.sql


00:38:41 SQL> select status from v$datafile where rownum<6;


STATUS


-------


SYSTEM


ONLINE


ONLINE


ONLINE


ONLINE


ò?????5DD?£


ò?ó?ê±??: 00: 00: 01.08


00:38:43 SQL> set echo off


00:38:58 SQL> @E:echo.sql


STATUS


?a?a-


SYSTEM


ONLINE


ONLINE


ONLINE


ONLINE


ò?????5DD?£


ò?ó?ê±??: 00: 00: 01.09


00:39:08 SQL>


SQL> set feedback on

SQL> set colsep |SQL> set pagesize 10

SQL> set serveroutput onSQL> set heading on

SQL> set timing on

SQL> set time on00:54:11

SQL> SELECT FILE#, STATUS, ENABLED FROM V$DATAFILE;


FILE#|STATUS |ENABLED?a?a?a-|?a?a-|?a?a?a-

1|SYSTEM |READ WRITE

2|ONLINE |READ WRITE

3|ONLINE |READ WRITE

4|ONLINE |READ WRITE

5|ONLINE |READ WRITE

6|ONLINE |READ WRITE

7|ONLINE |READ WRITE


FILE#|STATUS |ENABLED?a?a?a-|?a?a-|?a?a?a-

9|ONLINE |READ WRITE

10|ONLINE |READ WRITE

11|ONLINE |READ WRITE

12|ONLINE |READ WRITE11 rows selected.


Elapsed: 00:00:01.0700:54:34


SQL> DECLARE


00:55:00 2 BEGIN


00:55:00 3 DBMS_OUTPUT.PUT_LINE(?ˉ===This is dbms_output.put_line!===?ˉ);


00:55:00 4 END;


00:55:02 5 /

===This is dbms_output.put_line!===


PL/SQL procedure successfully completed.


Elapsed: 00:00:00.0200:55:05 SQL>


SQL> set autotrace on

SQL> SELECT E.LAST_NAME, D.DEPARTMENT_NAME, D.LOCATION_ID

2 FROM HR.EMPLOYEES E

3 JOIN HR.DEPARTMENTS D

4 USING (DEPARTMENT_ID);


LAST_NAME DEPARTMENT_NAME LOCATION_ID

?a?a?a?a?a?a?a?a- ?a?a?a?a?a?a?a?a?a?a ?a?a?a¨C

发表评论
请自觉遵守互联网相关的政策法规,严禁发布色情、暴力、反动的言论。
用户名: 验证码:点击我更换图片
最新评论 更多>>

推荐热点

  • 在oracle数据库下使用iSQL*Plus DBA访问数据库
  • oracle 让sys用户可以使用isqlplus
  • Oracle数据库Constraint约束的常用操作及异常处理
  • ORACLE10gr2数据导入MySQL方案
  • OCP043第十五讲 Database Security
  • export/import的使用
  • Oracle行列转换小结
  • Table函数使用简介
  • Bulk Collect性能分析(zz)
网站首页 - 友情链接 - 网站地图 - TAG标签 - RSS订阅 - 内容搜索
Copyright © 2008-2015 计算机技术学习交流网. 版权所有

豫ICP备11007008号-1