Re: Views question?

Andrew Hamm said: > Andrew Hamm wrote: >> >> I will definitely have to ask now. I cannot speak for them, but I know >> they've been handling Oracle engines for years 'n' years. > > OK - this response just in: > >> One of the reasons for dropping and recreating, is that not >> all databases allow you to add columns in a nominated >> location in the table. Oracle only allows new columns to be >> added to the end. > > So there's the answer. I guess this is still true 'cos they've been doing > Oracle for years. > > Of course, treating columns in a position-dependent way is totally wrong, > but then again, 4GL ain't that smart sometimes, and besides, it sure is > nice > to look at groups of cooperating columns in approximately the same place > when you are reading a schema, so I too like to insert columns in exactly > the right place. To my eternal shame, I do too. So when I was an Oracle DBA, I created the base table with an extension in the name, and used views to present the data in an "ordered" fashion. Seems a bit less invasive than dropping tables...? -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco http://www.catb.org/~esr/faqs/smart-questions.html sending to informix-list