On a final note, real Oracle users don't use SQLPlus, they use TOAD, Tool for Oracle Application Developers. :)
On Monday 26 November 2001 01:32 pm, Christian Sage wrote: > Neil, > > I'm not going to argue against your view, because for a discussion on > Oracle this is clearly the wrong place. However, I would like to correct > your facts in one respect: while SQL plus has a standard line size of 80 > characters and a standard page size of 24, you can very easily set your > linesize to any value you want (within reason, but I know I have used 512 > successfully, and that is certainly wider than any terminal size I would > set), and pagesize could traditionally go up to 32767 or be set to 0, > which means no page breaks, no headers, etc. You can also have it pause > for you after each page and set the prompt it will give you whenever it so > pauses. There are numerous other things you can set on the fly or via a > configuration scripts. > > It takes some effort to get familiar with SQL plus, but once you have done > that, it is a very powerful and versatile tool indeed. Which has no > bearing at all on MySQL, but I think a measure of fairness towards > competitors is always indicated. > > Cheers, > Christian > > > -----Ursprungliche Nachricht----- > > Von: Neil Zanella [mailto:[EMAIL PROTECTED]] > > Gesendet: Montag, 26. November 2001 21:00 > > An: Ken Kinder > > Cc: Mamun Murtaza Sheriff; MySQL Mailing List > > Betreff: Re: opinion - voating > > > > On Mon, 26 Nov 2001, Ken Kinder wrote: > > > Oracle is certainly more full-featured, but if you know very > > > > little about > > > > > databases, Oracle is not the right choice. > > > > I agree. First of all the system requirements are high. For instance the > > Oracle Universal Installer took something like three hours on a fairly > > high end PIII with 133MHz FSB! I have heared it takes for ages (up to a > > whole day) on other machines. This is not the worse part either. Have > > you ever used the sqlplus command line utility (which is the equivalent > > of the mysql command line tool or PostgreSQL's psql command line > > client). > > > Well, sqlplus assumes your terminal is 24x80 even after you resize it. > > At least this is so with Oracle8i. I can tell you this: you won't learn > > much with a crappy tool like that cause as soon as you have more than > > two columns you won't be able to see the output in human readable form. > > Now my other point: Oracle8i is highly non-SQL compliant (although > > Oracle9i seems to be a little bit better). My last point about Oracle > > is that it is based on Java (see that JServer stuff when you start > > sqlplus?) and that is perhaps one of the reason it needs so much RAM. > > With a bit of bias we could conclude that if it were not for its > > disk and address space requirements then Oracle would be a fairly > > sluggish beast. > > > > > Only use Oracle if you have a > > > full-time fix-figure-salary Oracle expert AND you actually need > > Oracle's > > > > features. > > > > > > If you don't specifically know you need Oracle, you don't. > > > > Exactly. If I had the choice I would stay away from Oracle. Plus Oracle > > does not have good enough documentation either compared to most Open > > source products. > > > > Now there is one thing that we must be aware of. There are things that > > mysql does not support (yet). These include foreign keys, views, > > subselects, triggers, and procedural SQL, and I can't remember > > if mySQL supports transaction processing either, perhaps someone > > can confirm. However, mysql is much faster than other database > > system so you may still want to use it depending on the > > complexity of your database. If your database is not > > complex or if you do not need subselects then go > > with mysql. Most of the time you can get around > > all of this by recoding some things here and there. > > But if you are just learning go with postgresql, which > > will be slower, but will support all this stuff you > > need to know about databases. Once you have tested > > your application under postgresql and are certain > > that your code does not violate the database's > > foreign key constraint, simply run it under mysql > > after the testing phase. Then your code will run > > faster and at the same time free of errors. > > This is just my own personal recommendation > > for relatively small applications. > > > > Bye, > > > > Neil > > > > > On Wednesday 21 November 2001 09:45 pm, Mamun Murtaza Sheriff wrote: > > > > Dear All > > > > > > > > You all are working on Database for Long time. In your > > > > opinion Which one is > > > > > > best 1. MySql or 2. Oracle > > > > > > > > > > > > Mamun > > > > --------------------------------------------------------------------- > > > > > > Before posting, please check: > > > > http://www.mysql.com/manual.php (the manual) > > > > http://lists.mysql.com/ (the list archive) > > > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > > To unsubscribe, e-mail > > > > <[EMAIL PROTECTED]> Trouble > > > > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > --------------------------------------------------------------------- > > > Before posting, please check: > > > http://www.mysql.com/manual.php (the manual) > > > http://lists.mysql.com/ (the list archive) > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > To unsubscribe, e-mail > > > > <[EMAIL PROTECTED]> > > > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
