Mega Code Archive

Set pause text and show environment

SQL> create table emp 2 ( empno NUMBER(4) constraint E_PK primary key 3 , ename VARCHAR2(8) 4 , init VARCHAR2(5) 5 , job VARCHAR2(8) 6 , mgr NUMBER(4) 7 , bdate DATE 8 , sal NUMBER(6,2) 9 , comm NUMBER(6,2) 10 , deptno NUMBER(2) default 10 11 ) ; Table created. SQL> insert into emp values(1,'Tom','N', 'TRAINER', 13,date '1965-12-17', 800 , NULL, 20); 1 row created. SQL> insert into emp values(2,'Jack','JAM', 'Tester',6,date '1961-02-20', 1600, 300, 30); 1 row created. SQL> insert into emp values(3,'Wil','TF' , 'Tester',6,date '1962-02-22', 1250, 500, 30); 1 row created. SQL> insert into emp values(4,'Jane','JM', 'Designer', 9,date '1967-04-02', 2975, NULL, 20); 1 row created. SQL> insert into emp values(5,'Mary','P', 'Tester',6,date '1956-09-28', 1250, 1400, 30); 1 row created. SQL> insert into emp values(6,'Black','R', 'Designer', 9,date '1963-11-01', 2850, NULL, 30); 1 row created. SQL> insert into emp values(7,'Chris','AB', 'Designer', 9,date '1965-06-09', 2450, NULL, 10); 1 row created. SQL> insert into emp values(8,'Smart','SCJ', 'TRAINER', 4,date '1959-11-26', 3000, NULL, 20); 1 row created. SQL> insert into emp values(9,'Peter','CC', 'Designer',NULL,date '1952-11-17', 5000, NULL, 10); 1 row created. SQL> insert into emp values(10,'Take','JJ', 'Tester',6,date '1968-09-28', 1500, 0, 30); 1 row created. SQL> insert into emp values(11,'Ana','AA', 'TRAINER', 8,date '1966-12-30', 1100, NULL, 20); 1 row created. SQL> insert into emp values(12,'Jane','R', 'Manager', 6,date '1969-12-03', 800 , NULL, 30); 1 row created. SQL> insert into emp values(13,'Fake','MG', 'TRAINER', 4,date '1959-02-13', 3000, NULL, 20); 1 row created. SQL> insert into emp values(14,'Mike','TJA','Manager', 7,date '1962-01-23', 1300, NULL, 10); 1 row created. SQL> SQL> show pagesize pagesize 22 SQL> show pause PAUSE is OFF SQL> set pause '[Enter]... ' SQL> set pause on SQL> set pagesize 10 SQL> SQL> select * from emp; [Enter]... EMPNO ENAME INIT JOB MGR BDATE SAL COMM ---------- -------- ----- -------- ---------- ---------- ---------- ---------- DEPTNO ---------- 1 Tom N TRAINER 13 17-12-1965 800 20 2 Jack JAM Tester 6 20-02-1961 1600 300 30 [Enter]... set pause off pagesize 42 EMPNO ENAME INIT JOB MGR BDATE SAL COMM ---------- -------- ----- -------- ---------- ---------- ---------- ---------- DEPTNO ---------- 3 Wil TF Tester 6 22-02-1962 1250 500 30 4 Jane JM Designer 9 02-04-1967 2975 [Enter]... EMPNO ENAME INIT JOB MGR BDATE SAL COMM ---------- -------- ----- -------- ---------- ---------- ---------- ---------- DEPTNO ---------- 20 5 Mary P Tester 6 28-09-1956 1250 1400 30 [Enter]... EMPNO ENAME INIT JOB MGR BDATE SAL COMM ---------- -------- ----- -------- ---------- ---------- ---------- ---------- DEPTNO ---------- 6 Black R Designer 9 01-11-1963 2850 30 7 Chris AB Designer 9 09-06-1965 2450 10 [Enter]... EMPNO ENAME INIT JOB MGR BDATE SAL COMM ---------- -------- ----- -------- ---------- ---------- ---------- ---------- DEPTNO ---------- 8 Smart SCJ TRAINER 4 26-11-1959 3000 20 9 Peter CC Designer 17-11-1952 5000 [Enter]... EMPNO ENAME INIT JOB MGR BDATE SAL COMM ---------- -------- ----- -------- ---------- ---------- ---------- ---------- DEPTNO ---------- 10 10 Take JJ Tester 6 28-09-1968 1500 0 30 [Enter]... EMPNO ENAME INIT JOB MGR BDATE SAL COMM ---------- -------- ----- -------- ---------- ---------- ---------- ---------- DEPTNO ---------- 11 Ana AA TRAINER 8 30-12-1966 1100 20 12 Jane R Manager 6 03-12-1969 800 30 [Enter]... EMPNO ENAME INIT JOB MGR BDATE SAL COMM ---------- -------- ----- -------- ---------- ---------- ---------- ---------- DEPTNO ---------- 13 Fake MG TRAINER 4 13-02-1959 3000 20 14 Mike TJA Manager 7 23-01-1962 1300 [Enter]... EMPNO ENAME INIT JOB MGR BDATE SAL COMM ---------- -------- ----- -------- ---------- ---------- ---------- ---------- DEPTNO ---------- 10 14 rows selected. SQL> show all appinfo is OFF and set to "SQL*Plus" arraysize 15 autocommit OFF autoprint OFF autorecovery OFF autotrace OFF blockterminator "." (hex 2e) btitle OFF and is the first few characters of the next SELECT statement cmdsep OFF colsep " " compatibility version NATIVE concat "." (hex 2e) copycommit 0 COPYTYPECHECK is ON define "&" (hex 26) describe DEPTH 1 LINENUM OFF INDENT ON echo OFF editfile "afiedt.buf" embedded OFF escape OFF FEEDBACK ON for 6 or more rows flagger OFF flush ON heading ON headsep "|" (hex 7c) instance "local" linesize 80 lno 10 loboffset 1 logsource "" long 999 longchunksize 80 markup HTML OFF HEAD "<style type='text/css'> body {font:10pt Arial,Helvetica,sans-serif; color:black; background:White;} p {font:10pt Arial,Helvetica,sans-serif; color:black; background:White;} table ,tr,td {font:10pt Arial,Helvetica,sans-serif; color:Black; background:#f7f7e7; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px;} th {font:bold 10pt Arial,Helvetica,sans-serif; color:#336699; backgroun d:#cccc99; padding:0px 0px 0px 0px;} h1 {font:16pt Arial,Helvetica,Geneva,sans-serif; color:#336699; background-color:White; border-bottom:1px solid #cccc99; margin-top:0pt; margin-bottom:0pt; padding :0px 0px 0px 0px;} h2 {font:bold 10pt Arial,Helvetica,Geneva,sans-serif; color:#336699; background-color:White; margin-top:4pt; margin-bottom:0pt;} a {font:9pt Arial,Helvetica,sans-serif; color:#66330 0; background:#ffffff; margin-top:0pt; margin-bottom:0pt; vertical-align:top;}</style><title>SQL*Plus Report</title>" BODY "" TABLE "border='1' width='90%' align='center' summary='Script output'" SPOO L OFF ENTMAP ON PREFORMAT OFF newpage 1 null "" numformat "" numwidth 10 pagesize 10 PAUSE is ON and set to "[Enter]... " pno 9 recsep WRAP recsepchar " " (hex 20) release 1002000100 repfooter OFF and is NULL repheader OFF and is NULL serveroutput ON SIZE UNLIMITED FORMAT WORD_WRAPPED shiftinout INVISIBLE showmode OFF spool OFF sqlblanklines OFF sqlcase MIXED sqlcode 0 sqlcontinue "> " sqlnumber ON sqlpluscompatibility 10.2.0 sqlprefix "#" (hex 23) sqlprompt "SQL> " sqlterminator ";" (hex 3b) suffix "sql" tab ON termout ON timing OFF trimout ON trimspool OFF ttitle OFF and is the first few characters of the next SELECT statement underline "-" (hex 2d) USER is "RNTSOFT" verify OFF wrap : lines will be wrapped SQL> SQL> SQL> SQL> drop table emp; Table dropped.