skip to main | skip to sidebar

Novice in Oracle

Wednesday, October 29, 2008

Oracle PL/SQL | Sorting with NULL

The query to sort nulls in a particular column

select <Column Names> from <Table>
order by <Column List> {asc/desc} {nulls (first/last)};
Posted by Ranjeeth Shetty at 11:16 AM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Author

Ranjeeth Shetty
Senkang, Singapore, Singapore
View my complete profile

Blog Archive

  • ▼  2008 (17)
    • ►  November (1)
    • ▼  October (9)
      • Oracle PL/SQL | Sorting with NULL
      • Oracle PL/SQL | To returns single line query outpu...
      • Oracle PL/SQL | Finding Errors in compiled Objects
      • Oracle PL/SQL | A Debugger Procedure
      • Oracle PL/SQL | Query to Find loacked Objects
      • Oracle PL/SQL | Calling Java function in Oracle Pr...
      • Oracle PL/SQL | Script to generate SQL for Primary...
      • PL/SQL | Query to find Primary Key columns of a Table
      • Oracle PL/SQL | Using wmsys.wm_concat()
    • ►  September (7)