OraFAQ Forum: Client Tools » Columns position in TOAD

Home » Other » Client Tools » Columns position in TOAD

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Columns position in TOAD [message #285151]

Mon, 03 December 2007 14:05

majstoru
Messages: 68
Registered: October 2006
Location: Serbia

Member

Hi,

I found some PDF about TOAD for Oracle and there is some about comparing two databases (shemas, ...).

Does somebody know, if TOAD compare two shemas and foud that some columns doesn't have same position can solve this and replace column position in order of master shema?

Thanks in advance... Embarassed

Report message to a moderator

Re: Columns position in TOAD [message #285158 is a reply to message #285151]

Mon, 03 December 2007 15:13

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

As far as I can tell, TOAD (8.6.1) will not bother with such a difference, and you shouldn't either. Column position is irrelevant *unless* you did something stupid (pardon my French) and, for example, used

INSERT INTO some_table SELECT * FROM another_table;

in your application and expected it will always work.

Report message to a moderator

Re: Columns position in TOAD [message #285229 is a reply to message #285151]

Tue, 04 December 2007 00:54

majstoru
Messages: 68
Registered: October 2006
Location: Serbia

Member

Thanks Littlefoot!

Report message to a moderator

Previous Topic:	problem with toad, ORA-04043, ORA-12638
Next Topic:	sql developer

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 24 16:40:43 CDT 2025