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

PLEASE NOTE: This is an HTML preview only and some elements such as links or page numbers may be incorrect.
Download the book in PDF, ePub, Kindle for a complete version.

 

 

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';