Mega Code Archive

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>