Use 'format a30 heading' to define column name : Column « SQL Plus « Oracle PL / SQL

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

Use 'format a30 heading' to define column name

    
SQL>
SQL>
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> select * from departments;

DEPARTMENT_ID DEPARTMENT_NAME
------------- --------------------------------------------------
            1 Data Group
            2 Purchasing
            3 Call Center
            4 Communication

SQL>
SQL>
SQL> column department_name format a30 heading "Department Names"
SQL>
SQL> select department_name
  2    from departments
  3   order by 1
  4  /

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

SQL>
SQL>
SQL> drop table departments;

Table dropped.

SQL>

   
    
    
  

Related examples in the same category