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

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 ),