SET PAGESIZE 14, TTITLE OFF : pagesize « SQL Plus « Oracle PL / SQL

1. Oracle PL / SQL
2. SQL Plus
3. pagesize

SET PAGESIZE 14, TTITLE OFF

 
SQL>
SQL>
SQL> CREATE TABLE emp (
  2    emp_id               NUMBER,
  3    ename             VARCHAR2(40),
  4    hire_date        DATE DEFAULT sysdate,
  5    end_date DATE,
  6    rate     NUMBER(5,2),
  7    CONSTRAINT emp_pk    PRIMARY KEY (emp_id)
  8  );
SQL> INSERT INTO emp(emp_id, ename, hire_date,end_date, rate)VALUES (101, 'Mary', to_date('15-Nov-1961','dd-mon-yyyy'),null,169);
SQL> INSERT INTO emp(emp_id, ename, hire_date,end_date, rate)VALUES (102, 'Tom', to_date('16-Sep-1964','dd-mon-yyyy'),to_date('5-May-2004','dd-mon-yyyy'),135);
SQL> INSERT INTO emp(emp_id, ename, hire_date,end_date, rate)VALUES (104, 'Peter', to_date('29-Dec-1987','dd-mon-yyyy'),to_date('1-Apr-2004','dd-mon-yyyy'),99);
SQL> INSERT INTO emp(emp_id, ename, hire_date,end_date, rate)VALUES (105, 'Mike', to_date('15-Jun-2004','dd-mon-yyyy'),null,121);
SQL> INSERT INTO emp(emp_id, ename, hire_date,end_date, rate)VALUES (107, 'Less', to_date('2-Jan-2004','dd-mon-yyyy'),null,45);
SQL> INSERT INTO emp(emp_id, ename, hire_date,end_date, rate)VALUES (108, 'Park', to_date('1-Mar-1994','dd-mon-yyyy'),to_date('15-Nov-2004','dd-mon-yyyy'),220);
SQL> INSERT INTO emp(emp_id, ename, hire_date,end_date, rate)VALUES (110, 'Ink', to_date('4-Apr-2004','dd-mon-yyyy'),to_date('30-Sep-2004','dd-mon-yyyy'),84);
SQL> INSERT INTO emp(emp_id, ename, hire_date,end_date, rate)VALUES (111, 'Tike', to_date('23-Aug-1976','dd-mon-yyyy'),null,100);
SQL> INSERT INTO emp(emp_id, ename, hire_date,end_date, rate)VALUES (112, 'Inn', to_date('15-Nov-1961','dd-mon-yyyy'),to_date('4-Apr-2004','dd-mon-yyyy'),70);
SQL> INSERT INTO emp(emp_id, ename, hire_date,end_date, rate)VALUES (113, 'Kate', to_date('3-Mar-2004','dd-mon-yyyy'),to_date('31-Oct-2004','dd-mon-yyyy'),300);
SQL>
SQL>
SQL>
SQL> CLEAR COLUMNS
columns cleared
SQL> SET PAGESIZE 14
SQL> TTITLE OFF
SQL> SET FEEDBACK ON
SQL> SELECT emp_id, ename, rate
  2  FROM emp;

    EMP_ID
----------
ENAME
---------------------------------------
      RATE
----------
       101
Mary
       169

       102
Tom
       135

    EMP_ID
----------
ENAME
---------------------------------------
      RATE
----------

       104
Peter
        99

       105
Mike

    EMP_ID
----------
ENAME
---------------------------------------
      RATE
----------
       121

       107
Less
        45

       108

    EMP_ID
----------
ENAME
---------------------------------------
      RATE
----------
Park
       220

       110
Ink
        84


    EMP_ID
----------
ENAME
---------------------------------------
      RATE
----------
       111
Tike
       100

       112
Inn
        70

    EMP_ID
----------
ENAME
---------------------------------------
      RATE
----------

       113
Kate
       300


10 rows selected.

SQL>
SQL>
SQL>
SQL> drop table emp;

Table dropped.

   
  

Related examples in the same category