Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

"select             <<column_names>>             from

<<table-name>>;

If  we   want  to  see  the  data  available  in ledger-name of Ledger-Master table, then we shall give the syntax as "select ledger_name from ledger_master;" and this will retrieve data and display as follows:

11.01 How to display one column from a table

SYNTAX:

select ledger-name from ledger-master; RESULT:

LEDGER-NAME

cash account sales account

Generally, the column title or Heading label will be derived from the column-name itself, If we need the Tittle 1 column-heading differently we shall add the "as ledger" after column_name but before "from".