| Rush |
Posted: Mar 13, 2007 12:52:36 AM |
Total Post: 127
Joined: Jan, 2007
|
hello everybody,
plz help.
i want to know about that sql command wich tells number of columns in a table.other than desc.bkz desc is not so effective sometime.i want count(*)like command for columns.if you have then plz help.
thanxs and regards
RUPESH |
|
|
 gps |
| Posted: Mar 13, 2007 01:03:09 AM |  |
|
Total Post: 38
Joined: May, 2006
|
You can use this query:
select count(column_name) from user_tab_columns
where table_name='YOURTABLENAME'
Gurwinder
|
|
|
|
|
| Rush |
| Posted: Mar 13, 2007 01:12:07 AM | |
|
Total Post: 127
Joined: Jan, 2007
|
thanks GURWINDER!!!! :-)
THANKS A LOT FOR YOUR VALUEABLE QUERY!!
C U AGAIN
RUPESH
|
|
|
|
|
| Oracle Virus |
| Posted: Mar 13, 2007 04:30:11 AM | |
|
Total Post: 50
Joined: Jan, 2007
|
Hi Rush,
This will also do the same...
SELECT COUNT(CNAME) FROM COL WHERE TNAME = 'TABLE_NAME';
NOTE THAT TABNAME IS CASE SENSITIVE.
REGARDS,
ANEEL KANURI
|
|
|
|
|
| Rush |
| Posted: Mar 13, 2007 11:41:06 PM | |
|
Total Post: 127
Joined: Jan, 2007
|
hi virus :)
you have shown me more easier way for my problem!!!!
thanks a lot!!!
RUPESH
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
