Oracle PL/SQL/SQL Plus/pagesize

Материал из SQL эксперт
Перейти к: навигация, поиск

set pagesize 10

   <source lang="sql">
 

SQL> SQL> set pagesize 10 SQL> select rownum, object_name

 2        from all_objects
 3        where rownum < 20
 4  /
   ROWNUM OBJECT_NAME

------------------------------
        1 ICOL$
        2 I_USER1
        3 CON$
        4 UNDO$
        5 C_COBJ#
        6 I_OBJ#
        7 PROXY_ROLE_DATA$
   ROWNUM OBJECT_NAME

------------------------------
        8 I_IND1
        9 I_CDEF2
       10 I_PROXY_ROLE_DATA$_1
       11 FILE$
       12 UET$
       13 I_FILE#_BLOCK#
       14 I_FILE1
   ROWNUM OBJECT_NAME

------------------------------
       15 I_CON1
       16 I_OBJ3
       17 I_TS#
       18 I_CDEF4
       19 IND$

19 rows selected. SQL>

 </source>
   
  


set pagesize 100 linesize 120 newpage 0 feedback off

   <source lang="sql">

SQL> set pagesize 100 linesize 120 newpage 0 feedback off

 </source>
   
  


SET PAGESIZE 14, TTITLE OFF

   <source lang="sql">

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.

 </source>
   
  


set pagesize 30

   <source lang="sql">

SQL> SQL> set pagesize 30 SQL> SQL> -- create demo table SQL> create table emp(

 2    ID                 VARCHAR2(4 BYTE)         NOT NULL,
 3    fname         VARCHAR2(10 BYTE),
 4    lname          VARCHAR2(10 BYTE),
 5    Start_Date         DATE,
 6    End_Date           DATE,
 7    Salary             Number(8,2),
 8    City               VARCHAR2(10 BYTE),
 9    Description        VARCHAR2(15 BYTE)
10  )
11  /

Table created. SQL> SQL> -- prepare data SQL> insert into emp(ID, fname, lname, Start_Date, End_Date, Salary, City, Description)

 2               values ("01","Jason",    "Martin",  to_date("19960725","YYYYMMDD"), to_date("20060725","YYYYMMDD"), 1234.56, "Toronto",  "Programmer")
 3  /

1 row created. SQL> insert into emp(ID, fname, lname, Start_Date, End_Date, Salary, City, Description)

 2                values("02","Alison",   "Mathews", to_date("19760321","YYYYMMDD"), to_date("19860221","YYYYMMDD"), 6661.78, "Vancouver","Tester")
 3  /

1 row created. SQL> insert into emp(ID, fname, lname, Start_Date, End_Date, Salary, City, Description)

 2                values("03","James",    "Smith",   to_date("19781212","YYYYMMDD"), to_date("19900315","YYYYMMDD"), 6544.78, "Vancouver","Tester")
 3  /

1 row created. SQL> insert into emp(ID, fname, lname, Start_Date, End_Date, Salary, City, Description)

 2                values("04","Celia",    "Rice",    to_date("19821024","YYYYMMDD"), to_date("19990421","YYYYMMDD"), 2344.78, "Vancouver","Manager")
 3  /

1 row created. SQL> insert into emp(ID, fname, lname, Start_Date, End_Date, Salary, City, Description)

 2                values("05","Robert",   "Black",   to_date("19840115","YYYYMMDD"), to_date("19980808","YYYYMMDD"), 2334.78, "Vancouver","Tester")
 3  /

1 row created. SQL> insert into emp(ID, fname, lname, Start_Date, End_Date, Salary, City, Description)

 2                values("06","Linda",    "Green",   to_date("19870730","YYYYMMDD"), to_date("19960104","YYYYMMDD"), 4322.78,"New York",  "Tester")
 3  /

1 row created. SQL> insert into emp(ID, fname, lname, Start_Date, End_Date, Salary, City, Description)

 2                values("07","David",    "Larry",   to_date("19901231","YYYYMMDD"), to_date("19980212","YYYYMMDD"), 7897.78,"New York",  "Manager")
 3  /

1 row created. SQL> insert into emp(ID, fname, lname, Start_Date, End_Date, Salary, City, Description)

 2                values("08","James",    "Cat",     to_date("19960917","YYYYMMDD"), to_date("20020415","YYYYMMDD"), 1232.78,"Vancouver", "Tester")
 3  /

1 row created. SQL> SQL> select * from emp;


emp emp Current Numb Name LNAME START_DAT END_DATE Salary CITY


---------- ---------- --------- --------- --------- ----------

DESCRIPTION


01 Jason Martin 25-JUL-96 25-JUL-06 $1234.56 Toronto Programmer 02 Alison Mathews 21-MAR-76 21-FEB-86 $6661.78 Vancouver Tester 03 James Smith 12-DEC-78 15-MAR-90 $6544.78 Vancouver Tester 04 Celia Rice 24-OCT-82 21-APR-99 $2344.78 Vancouver Manager 05 Robert Black 15-JAN-84 08-AUG-98 $2334.78 Vancouver Tester 06 Linda Green 30-JUL-87 04-JAN-96 $4322.78 New York Tester 07 David Larry 31-DEC-90 12-FEB-98 $7897.78 New York Manager

                                                   Page:   2

emp emp Current Numb Name LNAME START_DAT END_DATE Salary CITY


---------- ---------- --------- --------- --------- ----------

DESCRIPTION


08 James Cat 17-SEP-96 15-APR-02 $1232.78 Vancouver Tester

8 rows selected. SQL> SQL> SQL> drop table emp; Table dropped.

 </source>