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.

 

 

may not ordered one, In case if we require the values in ascending order or in descending order we shall user ORDER BY follows with column name,

Syntax: select * from raak-ledger-master order by ledger-name desc ;

Result:

 

RECORD-ID

LEDGER-CODE

LEDGER-NAME

REPORT-TYPE

 

- - - - - - - - - -

- - - - - - - - - - - -

- - - - - - - - - - - - -

- - - - - - - - - - - -

 

2

PL-0002-00

SALES ACCOUNT

PL

 

1

BS-0001-00

CASH ACCOUNT

BS

 

3

BS-0004-00

CAPITAL ACCOUNT

BS

 

Desc (descending order need not be mentioned, if

 

required ascending order ),