DESCRIBE - shortly DESCandDESC - What we are using in ORDER BY CLAUSE are not same.DESCRIBE (DESC) is SQL*PLUS Command used to display the structure of the tables and views.DESC - What we are using in ORDER BY CLAUSE is a ORDER BY CLAUSE Option Value. Its Associated with SQL COMMAND.It is used to sort the rows in DECENDING order.
DESC[RIBE] is a SQL*Plus command It is used to describe an Oracle Table, View, Synonym, package or Function.Note that because this is a SQL*Plus command you don't need to terminate it with a semicolon.Syntax: DESC table DESC view DESC synonym DESC function DESC package
Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.