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

?ú′ó?ò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