Home » SQL & PL/SQL » Client Tools » Columns position in TOAD
Columns position in TOAD [message #285151] Mon, 03 December 2007 14:05 Go to next message
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
Re: Columns position in TOAD [message #285158 is a reply to message #285151] Mon, 03 December 2007 15:13 Go to previous messageGo to next message
Littlefoot
Messages: 20891
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.
Re: Columns position in TOAD [message #285229 is a reply to message #285151] Tue, 04 December 2007 00:54 Go to previous message
majstoru
Messages: 68
Registered: October 2006
Location: Serbia
Member
Thanks Littlefoot!
Previous Topic: problem with toad, ORA-04043, ORA-12638
Next Topic: sql developer
Goto Forum:
  


Current Time: Sun Dec 04 16:40:16 CST 2016

Total time taken to generate the page: 0.09960 seconds