SQL Refreshment Contest 8

**vjsreevs** · 24-08-06, 06:08 PM

What is the use of DESC in SQL

28-08-06, 01:25 AM

two purpose

1. To Describe the table structure.

2. To sort the column in descending order

ajithcharles · 08-10-06, 07:26 PM

Just to clarify
desc is used to view an objects structure ( not only table structure) ..

desc (package name)
desc (table )

Thanks,
Ajith

24-08-06, 06:08 PM	#1 (permalink)
vjsreevs Moderator Join Date: Apr 2006 Location: India Posts: 1,733 Thanks: 2 Thanked 143 Times in 132 Posts Thanks: 2 Thanked 143 Times in 132 Posts Rep Power: 31	SQL Refreshment Contest 8 What is the use of DESC in SQL __________________ Sree

28-08-06, 01:25 AM	#2 (permalink)
Unregistered Unregistered Posts: n/a	Re: SQL Refreshment Contest 8 two purpose 1. To Describe the table structure. 2. To sort the column in descending order

08-10-06, 07:26 PM	#3 (permalink)
ajithcharles Senior Member Join Date: Mar 2006 Age: 24 Posts: 343 Thanks: 3 Thanked 12 Times in 12 Posts Thanks: 3 Thanked 12 Times in 12 Posts Rep Power: 8	Re: SQL Refreshment Contest 8 Just to clarify desc is used to view an objects structure ( not only table structure) .. desc (package name) desc (table ) Thanks, Ajith __________________ JSP,Oracle,SQL : http://mycodesnippetjsp.blogspot.com/ Complete List :http://www.blogger.com/profile/04567238067268200918

Thread Tools
Show Printable Version Email this Page
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SQL Refreshment Contest 1	vjsreevs	ORACLE , SQL SERVER , SYBASE & Others	8	10-11-06 03:19 PM
SQL Refreshment Contest 6	vjsreevs	ORACLE , SQL SERVER , SYBASE & Others	1	01-09-06 01:57 AM
SQL Refreshment Contest 3	vjsreevs	ORACLE , SQL SERVER , SYBASE & Others	1	13-08-06 02:38 AM
SQL Refreshment Contest 5	vjsreevs	ORACLE , SQL SERVER , SYBASE & Others	0	12-08-06 04:36 PM
SQL Refreshment Contest 4	vjsreevs	ORACLE , SQL SERVER , SYBASE & Others	0	05-08-06 10:00 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)