col columnName new_value BLAH : Column Names « Select Query « Oracle PL / SQL






col columnName new_value BLAH

   
SQL> create table emp
  2  ( empno      NUMBER(4)    constraint E_PK primary key
  3  , ename      VARCHAR2(8)
  4  , init       VARCHAR2(5)
  5  , job        VARCHAR2(8)
  6  , mgr        NUMBER(4)
  7  , bdate      DATE
  8  , sal        NUMBER(6,2)
  9  , comm       NUMBER(6,2)
 10  , deptno     NUMBER(2)    default 10
 11  ) ;

Table created.

SQL> insert into emp values(1,'Tom','N',   'TRAINER', 13,date '1965-12-17',  800 , NULL,  20);

1 row created.

SQL> insert into emp values(2,'Jack','JAM', 'Tester',6,date '1961-02-20',  1600, 300,   30);

1 row created.

SQL> insert into emp values(3,'Wil','TF' ,  'Tester',6,date '1962-02-22',  1250, 500,   30);

1 row created.

SQL> insert into emp values(4,'Jane','JM',  'Designer', 9,date '1967-04-02',  2975, NULL,  20);

1 row created.

SQL> insert into emp values(5,'Mary','P',  'Tester',6,date '1956-09-28',  1250, 1400,  30);

1 row created.

SQL> insert into emp values(6,'Black','R',   'Designer', 9,date '1963-11-01',  2850, NULL,  30);

1 row created.

SQL> insert into emp values(7,'Chris','AB',  'Designer', 9,date '1965-06-09',  2450, NULL,  10);

1 row created.

SQL> insert into emp values(8,'Smart','SCJ', 'TRAINER', 4,date '1959-11-26',  3000, NULL,  20);

1 row created.

SQL> insert into emp values(9,'Peter','CC',   'Designer',NULL,date '1952-11-17',  5000, NULL,  10);

1 row created.

SQL> insert into emp values(10,'Take','JJ', 'Tester',6,date '1968-09-28',  1500, 0,     30);

1 row created.

SQL> insert into emp values(11,'Ana','AA',  'TRAINER', 8,date '1966-12-30',  1100, NULL,  20);

1 row created.

SQL> insert into emp values(12,'Jane','R',   'Manager',   6,date '1969-12-03',  800 , NULL,  30);

1 row created.

SQL> insert into emp values(13,'Fake','MG',   'TRAINER', 4,date '1959-02-13',  3000, NULL,  20);

1 row created.

SQL> insert into emp values(14,'Mike','TJA','Manager',   7,date '1962-01-23',  1300, NULL,  10);

1 row created.

SQL>
SQL>
SQL> col empno new_value BLAH
SQL>
SQL> select empno, ename, bdate
  2  ,      sal         as salary
  3  ,      comm         as commission
  4  from   emp;
Enter...

                                           month
 EMPNO        lname         BDATE         salary COMMISSION
------ -------------------- ---------- --------- ----------
     1 Tom                  17-12-1965   $800.00  [N/A]
     2 Jack                 20-02-1961  $1600.00    $300.00
     3 Wil                  22-02-1962  $1250.00    $500.00
     4 Jane                 02-04-1967  $2975.00  [N/A]
     5 Mary                 28-09-1956  $1250.00   $1400.00
     6 Black                01-11-1963  $2850.00  [N/A]
     7 Chris                09-06-1965  $2450.00  [N/A]
     8 Smart                26-11-1959  $3000.00  [N/A]
     9 Peter                17-11-1952  $5000.00  [N/A]
    10 Take                 28-09-1968  $1500.00       $.00
    11 Ana                  30-12-1966  $1100.00  [N/A]
    12 Jane                 03-12-1969   $800.00  [N/A]
    13 Fake                 13-02-1959  $3000.00  [N/A]
    14 Mike                 23-01-1962  $1300.00  [N/A]

14 rows selected.

SQL> def BLAH
DEFINE BLAH            =     14 (NUMBER)
SQL>
SQL> select empno, ename, bdate
  2  ,      sal         as salary
  3  ,      comm         as commission
  4  from   emp
  5  where  deptno = 30;
Enter...

                                           month
 EMPNO        lname         BDATE         salary COMMISSION
------ -------------------- ---------- --------- ----------
     2 Jack                 20-02-1961  $1600.00    $300.00
     3 Wil                  22-02-1962  $1250.00    $500.00
     5 Mary                 28-09-1956  $1250.00   $1400.00
     6 Black                01-11-1963  $2850.00  [N/A]
    10 Take                 28-09-1968  $1500.00       $.00
    12 Jane                 03-12-1969   $800.00  [N/A]

6 rows selected.

SQL> def    BLAH
DEFINE BLAH            =     12 (NUMBER)
SQL> undef  BLAH
SQL>
SQL>
SQL> drop table emp;

Table dropped.

SQL>

   
    
    
  








Related examples in the same category

1.Insert string text between column names
2.Column Renaming
3.Column renaming for function
4.Combined columns and renaming
5.Use table name to reference column name
6.Use table name to reference the ambiguity column names
7.Reference column name from renamed table name
8.Reference column without table name during table join