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

cash account sales account

11.04 How to display all the column values with column name as

title

Before, we  see  some more  conditional retrieval and usage of functions; let us see what are the records available  in the raak-ledger-master, If we want to retrieve all the columns available in the table may be referred as "*" instead of giving all the column-name with a separator comma,

SYNTAX: select *   from raak-ledger-master;

RESULT: All the columns will be get displayed along column-name with a heading

11.05  How do we make conditional display of column values?

We like to retrieve the entire record for the value of

"cash account" available in the table.

SYNTAX:  Select * from raak-ledger-master where

ledger_name 'cash account';