Oracle SQL PLSQL 12C Tutorial 10 - ORDER BY Clause, Sorting Data

Details

Description

This Video Tutorial Will Describe how to SORT data which is already inserted into the table in oracle 12C version. This command will also work on other versions of database like Oracle 11g Database, Oracle 10g Database, Oracle 9i Database, Oracle 8i Database, Oracle 8 Database and so on.

Whenever you create a new table in oracle, you insert the data as and when it comes. But you always need to get data in particular order. For that, we use ORDER BY clause with the SELECT statement to sort the data in ascending or descending order and retrieve it.

Full Syntax will be given in this video tutorial about how to insert records in oracle database table.

Along with the live example to get or print the sorted data in a SELECT statement with ORDER BY clause.

All the keywords, format, mandatory clauses etc are described in this video.