Use a13 to set the column length during displaying : Column « SQL Plus « Oracle PL / SQL

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

Use a13 to set the column length during displaying

    
SQL> CREATE TABLE departments
  2  (department_id           number(10)            not null,
  3   department_name      varchar2(50)      not null,
  4   CONSTRAINT departments_pk PRIMARY KEY (department_id)
  5  );

Table created.

SQL>
SQL>
SQL>
SQL> insert into departments ( department_id, department_name )
  2                    values( 1,             'Data Group' );

1 row created.

SQL>
SQL> insert into departments ( department_id, department_name )
  2                    values( 2,             'Purchasing' );

1 row created.

SQL>
SQL> insert into departments ( department_id, department_name )
  2                    values( 3,             'Call Center' );

1 row created.

SQL>
SQL> insert into departments ( department_id, department_name )
  2                    values( 4,             'Communication' );

1 row created.

SQL>
SQL>
SQL>
SQL>  column department_name format a13
SQL>  column employees format a63 word_wrapped
SQL>
SQL>  select department_name, department_name
  2      from departments
  3    /

Department Na Department Na
------------- -------------
Data Group    Data Group
Purchasing    Purchasing
Call Center   Call Center
Communication Communication

SQL>
SQL> drop table departments;

Table dropped.

   
    
    
  

Related examples in the same category