LOL!!
-Original Message-
Pierce
Sent: Thursday, May 10, 2001 10:17
To: Multiple recipients of list ORACLE-L
HELP
On 10 May 2001, at 12:53, SuzyV scribbled with alacrity and cogency:
Am I an idiot??
...
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
Select column_name, column_id
From user_tab_columns
Where table_name = 'YOUR TABLE NAME';
Rao
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, May 10, 2001 3:01 PM
To: Multiple recipients of list ORACLE-L
Hi!
How can I find out what the order of columns in a table is?
If
select table_name, column_name from dba_tab_columns
where table_name = 'SOMETABLE' order by column_id ;
The column order is the same as you'd see with describe or select *
You can eliminate VALUES from insert when inserting a value (or null) for each
column and in the proper order.
Helmut
Try
1 select table_name, column_name, column_id
2* from user_tab_columns where table_name = 'PRODUCT_PROFILE'
SQL /
TABLE_NAME COLUMN_NAMECOLUMN_ID
-- -- -
PRODUCT_PROFILE
Am I an idiot?? Meant to say, you can eliminate the COLUMN list not VALUES,
doh!
SuzyV wrote:
select table_name, column_name from dba_tab_columns
where table_name = 'SOMETABLE' order by column_id ;
The column order is the same as you'd see with describe or select *
You can eliminate
HELP
On 10 May 2001, at 12:53, SuzyV scribbled with alacrity and cogency:
Am I an idiot??
...
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Eric D. Pierce
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San
ROFL!
Eric, you're killing me today.
I want whatever it is you sprinkle
on yer Wheaties.
|| -Original Message-
|| From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
|| Sent: Thursday, May 10, 2001 5:17 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: Re: Order of columns
sounds like you already did.
regards,
ep
On 10 May 2001, at 11:01, Helmut Daiminger wrote:
How can I find out what the order of columns in a table is?
If I do a select * from tablename, the columns appear in a specific order.
The same order than they appear when I do a describe