Returning a Single Column.sql : Query Select Columns « Select Query « Oracle PL / SQL






Returning a Single Column.sql

   
SQL>
SQL> CREATE TABLE emp (
  2     empID INT NOT NULL PRIMARY KEY,
  3     Name        VARCHAR(50) NOT NULL);

Table created.

SQL> INSERT INTO emp (empID,Name) VALUES (1,'Victor');

1 row created.

SQL> INSERT INTO emp (empID,Name) VALUES (2,'Bill');

1 row created.

SQL> INSERT INTO emp (empID,Name) VALUES (3,'Mary');

1 row created.

SQL> INSERT INTO emp (empID,Name) VALUES (4,'Jack');

1 row created.

SQL> INSERT INTO emp (empID,Name) VALUES (5,'Peter');

1 row created.

SQL> INSERT INTO emp (empID,Name) VALUES (6,'Tom');

1 row created.

SQL>
SQL>
SQL> SELECT Name FROM emp;

NAME
--------------------------------------------------
Victor
Bill
Mary
Jack
Peter
Tom

6 rows selected.

SQL>
SQL> drop table emp;

Table dropped.

   
    
    
  








Related examples in the same category

1.Query returning all rows and all columns from the table
2.Indicate the column names in query command
3.Reference one column more than once
4.Reference renamed column in order by
5.Renaming a column with a longer name
6.Return course name for an employee id