Re: Views question?

Mark Townsend said: > Obnoxio The Clown wrote: >> Mark Townsend said: >> >> >>>BTW - as a trivia question - which of the big three databases STILL >>>doesn't have drop column ? >> >> >> Must be SQL Server... :o) >> > > Brrrt. No. Thanks for playing, next caller please. Well, then, it must be Oracle, because I know Informix has it. -- 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

Obnoxio The Clown wrote: > Mark Townsend said: > >>Obnoxio The Clown wrote: >> >>>Mark Townsend said: >>> >>> >>> >>>>BTW - as a trivia question - which of the big three databases STILL >>>>doesn't have drop column ? >>> >>> >>>Must be SQL Server... :o) >>> >> >>Brrrt. No. Thanks for playing, next caller please. > > > Well, then, it must be Oracle, because I know Informix has it. Not a chance. In Oracle ... ALTER TABLE <table_name> DROP COLUMN <column_name>; And it has been there for many versions. -- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan@x.washington.edu (replace 'x' with a 'u' to reply)

Obnoxio The Clown wrote: > Mark Townsend said: > >>Obnoxio The Clown wrote: >> >>>Mark Townsend said: >>> >>> >>> >>>>BTW - as a trivia question - which of the big three databases STILL >>>>doesn't have drop column ? >>> >>> >>>Must be SQL Server... :o) >>> >> >>Brrrt. No. Thanks for playing, next caller please. > > > Well, then, it must be Oracle, because I know Informix has it. > Too obvious. I think the "big three" is intended to mislead - slightly. I'd guess either MS-Access or MySQL. I'm guessing that cheap/free will get a DBMS into the "big three" category... So, Mark, how'd I do? Do I get a big, fat buzzer too? -- June Hunt

> I'd guess either MS-Access or MySQL. > So, Mark, how'd I do? Do I get a big, fat buzzer too? Hey - I'm the bug, fat buzztard. Anyhow, still no winner. I believe both of these do have Alter Table Drop Column. So who could it be ? Lets think about this for awhile. Are we all thinking ? Lets all think together. Think. Think. Think.

"Mark Townsend" <markbtownsend@comcast.net> wrote > > Hey - I'm the bug, fat buzztard. Anyhow, still no winner. I believe both > of these do have Alter Table Drop Column. So who could it be ? Lets > think about this for awhile. Are we all thinking ? Lets all think > together. Think. Think. Think. ^^^^^^^^^^^^^^^^^^^^ Naughty, naughty. Good one. However as a DBA let me tell u this. Just bcos a product does not have some feature, it hardly makes it useless/worthless. I would see how important is that missing feature. To be frank, lack of drop column is not critical to me. In the worst case, I will chose to ignore that unwanted field till an opportune time. Add columns is obviously needed since we keep adding columns during a life cycle of an application. Obviously there are many features in Oracle 10 or 9 which weren't there earlier. Like on-line indexing or snapshot too old problem. More than 50% of Oracle installation is still in 8 or earlier. Ask those DBAs whether their life is miserable bcos of lack of the features. Does not mean that every missing feature has a workaround. Not necessary. I consider SQLServer's inability to do case sensitive search highly annoying. Yeah they allow it to be case sensitive, provided it is installed like that. Attempt to force a case sensitive search using CONVERT will instruct the server to not use index scan. Data is user defined. Sometime data comes from external source. How would u go about advising everyone about case sensitivity.

Mark Townsend wrote: >> I'd guess either MS-Access or MySQL. So, Mark, how'd I do? Do I get a >> big, fat buzzer too? > > > Hey - I'm the bug, fat buzztard. Anyhow, still no winner. I believe both > of these do have Alter Table Drop Column. So who could it be ? Lets > think about this for awhile. Are we all thinking ? Lets all think > together. Think. Think. Think. > So, it isn't Informix, Oracle, SQL Server, MS-Access, MySQL... it can't be DB2, can it?? Nah.... You said "big three"..... Oh. Am I at least getting warm? -- June Hunt

Comments in-line. rkusenet wrote: > "Mark Townsend" <markbtownsend@comcast.net> wrote > >>Hey - I'm the bug, fat buzztard. Anyhow, still no winner. I believe both >>of these do have Alter Table Drop Column. So who could it be ? Lets >>think about this for awhile. Are we all thinking ? Lets all think >>together. Think. Think. Think. > > ^^^^^^^^^^^^^^^^^^^^ > > Naughty, naughty. Good one. > However as a DBA let me tell u this. Just bcos a product does > not have some feature, it hardly makes it useless/worthless. > I would see how important is that missing feature. To be frank, > lack of drop column is not critical to me. In the worst case, > I will chose to ignore that unwanted field till an opportune > time. Add columns is obviously needed since we keep adding > columns during a life cycle of an application. > > Obviously there are many features in Oracle 10 or 9 which > weren't there earlier. Like on-line indexing or snapshot > too old problem. More than 50% of Oracle installation is > still in 8 or earlier. Ask those DBAs whether their life > is miserable bcos of lack of the features. I'll answer that question for you ... yes it was. Which is why many of us were spending more time using other products back then. > Does not mean that every missing feature has a workaround. Some of which are quite painful such as how to get a consistent query from most RDBMS products without full table locks. > Not necessary. I consider SQLServer's inability to do case > sensitive search highly annoying. Yeah they allow it to > be case sensitive, provided it is installed like that. > Attempt to force a case sensitive search using CONVERT > will instruct the server to not use index scan. Data > is user defined. Sometime data comes from external source. > How would u go about advising everyone about case sensitivity. I'd think SQL Server's lack of triggers types, lack of sequences, lack of operating system choices, lack of ability to cluster past 4 nodes far bigger issues. Interestingly with Yukon Microsoft is desparately trying to duplicate Oracle's multiversioning architecture. I wonder why? ;-) -- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan@x.washington.edu (replace 'x' with a 'u' to reply)

"Daniel Morgan" <damorgan@x.washington.edu> wrote > Interestingly with Yukon Microsoft is desparately trying to duplicate > Oracle's multiversioning architecture. I wonder why? ;-) Oracle will start knowing this in another few years when they start finding their customers migrating to SQLServer. Oracle's unique MV architecture ensured that their customers can't migrate with pain. That will change with Yukon. I am surprised that u did know the reason: MS is after Oracle customers. RDBMS market has saturated and the only way database license will keep growing is migration. With the cash they have, the aggressive pricing, not to mention the ease of use, they will soon start having lunch with O customers. Yukon is a HUGE improvement on SS2000. I am just beginning to have a look at it. The error handling in stored procedure etc. Yeah ur customers will always stay with Oracle. Don't worry. rk-

"June C. Hunt" <june_c_hunt@hotmail.com> wrote in message news:40D39F22.7050406@hotmail.com... > Mark Townsend wrote: > >> I'd guess either MS-Access or MySQL. So, Mark, how'd I do? Do I get a > >> big, fat buzzer too? > > > > > > Hey - I'm the bug, fat buzztard. Anyhow, still no winner. I believe both > > of these do have Alter Table Drop Column. So who could it be ? Lets > > think about this for awhile. Are we all thinking ? Lets all think > > together. Think. Think. Think. > > > > So, it isn't Informix, Oracle, SQL Server, MS-Access, MySQL... it can't > be DB2, can it?? Nah.... You said "big three"..... Oh. Am I at least > getting warm? > DB2? Ingres? > -- > June Hunt

June C. Hunt wrote: > > So, Mark, how'd I do? Do I get a big, fat buzzer too? Maybe not, but if you ask nicely you might get a big fat hummer...

Andrew Hamm wrote: > June C. Hunt wrote: > >>So, Mark, how'd I do? Do I get a big, fat buzzer too? > > > Maybe not, but if you ask nicely you might get a big fat hummer... I thought that only worked the other way.... Hmmmmm. Maybe you really *do* learn something new every day. :-) -- June Hunt