what is the difference between oracle 8i and oracle 9i?
488198
Here is a link to a White Paper on the new features introduced in 9i.  It is on Oracle tech Net.  You may have to register to see it, but it is free and an oracle site, so it is safe.
339810
Use the link below to visit the download server of Oracle...\nhttp://www.oracle.com/technology/software/index.html\n\nAll downloads are FREE under the Developer License which allows you to use full versions of the products only while developing and prototyping your applications....\n\nRead the License Agreement for more information about licensing...
539222
http://asktom.oracle.com\n\nThis is one of the best site for all types of your Oracle9i Queries. This has the information with some of the examples.\n\nhttps://cwisdb.cc.kuleuven.ac.be/ora10doc/appdev.101/b10807/loe.htm\n\nhttp://www.ss64.com/ora/
932728
Definitely 10g.  9i is outdated.  Dont teach yourself something that no one is using any more.
153544
Microsoft offers a full family of database tools for the desktop, the server, and for open connectivity. For the desktop Microsoft offers Microsoft Access 97/2000.\nThe Microsoft Access 97/2000 is a full-featured multiuser relational database management system that designed for the Microsoft Windows operating systems (such as Windows 9x, Windows NT, Windows 2000). Access 97/2000 is extremely visually oriented and easy to use. It makes extensive use of drag-and-drop and visual design for queries, forms, and reports.\n\nAccess 97/2000 comes with an integrated development environment (IDE), including incremental compilation, a fully interactive visual debugger, breakpoints, and single step-through. These capabilities combine to make Microsoft Access an extremely powerful platform for developing client-server database solutions.\n\nThere are general Access 97/2000 characteristics:\n\nObject Maximum sizes/numbers \nDatabase size 1 Gb \nNumber of characters in an object name 64 \nNumber of characters in a password 14 \nNumber of characters in a user name or group name 20 \nNumber of concurrent users 255 \nNumber of characters in a table name 64 \nNumber of characters in a field name 64 \nNumber of fields in a table 255 \nNumber of characters in a Text field 255 \nNumber of characters in a Memo field 65,535 / 1 Gb \n\nThough the maximum database size is 1 Gb, but your database can include linked tables in other files, and its total size is limited only by available storage capacity.\n\nNumber of characters in a Memo field can be up to 65,535 characters when entering data through the user interface or can be up to 1 Gb when entering data programmatically.\n\nAccess 2000 can lock on the row level in comparison with Access 97 page level's lock.\n\nWHILE IN SQL SERVER 2000\n\nThere are no many differences in the internal architecture between SQL Server 7.0 and SQL Server 2000. SQL Server 2000 has the same features as SQL Server 7.0: autogrow features, new storage engine, complete row level locking and so on. So, the general characteristics of these versions are the same.\n\nThere are general SQL Server 97/2000 characteristics:\n\nObject Maximum sizes/numbers \nBatch size 65,536 * Network Packet Size \nBytes per short string column 8,000 \nBytes per text, ntext,or image column 2 GB-2 \nBytes per index 900 \nBytes per foreign key 900 \nBytes per primary key 900 \nBytes per row 8,060 \nBytes in source text of a stored procedure Lesser of batch size or 250 MB \nClustered indexes per table 1 \nColumns per index 16 \nColumns per foreign key 16 \nColumns per primary key 16 \nColumns per base table 1,024 \nColumns per SELECT statement 4,096 \nColumns per INSERT statement 1,024 \nConnections per client Maximum value of configured connections \nDatabase size 1,048,516 TB \nDatabases per instance of SQL Server 32,767 \nFilegroups per database 256 \nFiles per database 32,767 \nFile size (data) 32 TB \nIdentifier length (in characters) 128 \nLocks per connection Max. locks per server \nNested stored procedure levels 32 \nNested subqueries 32 \nNested trigger levels 32 \nNonclustered indexes per table 249 \nObjects in a database 2,147,483,6474 \nParameters per stored procedure 1,024 \nREFERENCES per table 253 \nRows per table Limited by available storage \nTables per database Limited by number of objects in a database \nTables per SELECT statement 256 \nTriggers per table Limited by number of objects in a database \nUNIQUE indexes or constraints per table 249 nonclustered and 1 clustered \n\nSQL Server 2000 Enterprise Edition on the Windows 2000 DataCenter can support up to 32 CPU and up to 64GB physical memory (RAM) on a computer!
296338
Both Oracle 9i Database and IBM DB2 Universal Database v8.1 support the ANSI SQL-92 entry level and do not support the ANSI SQL-92 intermediate level.\n\nThe dialect of SQL supported by Oracle 9i Database is called PL/SQL. The dialect of SQL supported by IBM DB2 v8.1 is called DB2 SQL dialect. \n\nFollowing is a brief comparison of PL/SQL and DB2 SQL dialect:\n\nIndexes  \n\nPL/SQL:\n\nB-Tree indexes,\nBitmap indexes,\nPartitioned indexes,\nFunction-based indexes,\nDomain indexes  \n\nDB2 SQL dialect:\n\nB-Tree indexes,\nBitmap indexes,\nPartitioned indexes,\nblock indexes,\ndimension block indexes  \n\nTables  \n\nPL/SQL:\n\nRelational tables,\nObject tables,\nTemporary tables  \n\nDB2 SQL dialect:\n\nRelational tables,\nObject tables,\nTemporary tables  \n\n\nTriggers  \n\nPL/SQL:\n\nBEFORE triggers,\nAFTER triggers,\nINSTEAD OF triggers  \n\nDB2 SQL dialect:\n\nBEFORE triggers,\nAFTER triggers,\nINSTEAD OF triggers  \n\nProcedures  \n\nPL/SQL:\n\nPL/SQL statements,\nJava methods,\nthird-generation language\n(3GL) routines  \n\nDB2 SQL dialect:\n\nDB2 SQL dialect statements,\nJava methods,\nthird-generation language\n(3GL) routines  \n\nMultiple Triggers  \n\nPL/SQL:\n\nSupported  \n\nDB2 SQL dialect:\n\nSupported  \n\nArrays  \n\nPL/SQL:\n\nSupported  \n\nDB2 SQL dialect:\n\nSupported  \n\nIt is not true that Oracle Database is better than DB2 Universal Database or vice versa. \n\nBoth products can be used to build stable and efficient system and the stability and effectiveness of your applications and databases depend rather from the experience of the database developers and database administrator than from the database's provider.\n\nSince both of them support ANSI SQL-92 which means all your SQL commands can work on Oracle which you used on DB2.\n\nWorking knowledge of both the products will be more or less the same however the architecture will be different.\n\nBut I recommend you apply for the programming job that requires your knowing Oracle. Refer to some Oracle books before going for interviews. Visit http://www.sharanamshah.com for book details.
81
Define "best". Oracle is like a BMW. Expensive but has all the fixings. But not everyone needs a BMW. MySQL is like a VW Beetle (the old model). Its cheap, and gets you where you need to go. But you have to tweak it to suit your needs.
526070
Didn't realize there was a 32 bit version of 5.8 Thought they were all 64 bit by then.  Had to actually look this one up :) \n\nRun the command\n\nisainfo -v\n\n\nIf the system is running in 32 bit mode, you will see the following output:\n\n32-bit sparc applications\n\n\nOn a 64 bit Solaris system, you'll see:\n\n64-bit sparcv9 applications\n32-bit sparc applications
680411
Absolutely no problem.\nI'm using an Oracle 8i both Client and Server Application in the place I'm working. No problem at all ...
702636
I assume you are talking about classic ASP. If so go here: http://www.asp101.com/articles/colin/oracle/default.asp\n\nIf ASP.Net, go to: http://www.codeguru.com/article.php/c8477
56050
Materialized views are like normal tables...\nIn fact, Oracle creates a table of same name as that of the Mview in order to implement the MView.\nSo u can always create indexes on Mviews like ordinary tables.
333292
You have to buy it from Oracle or a reseller. And any Oracle application is going to require a lot more than 256MB RAM... if you are going to be doing serious Oracle development or running Oracle back-end applications you'll want to upgrade to at least 1GB RAM.
42515
This must help you.\n\nhttp://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:1886476148373
448734
I've had a lot of problems with this migration. Upgrading it in place gave me all kinds of security problems. What I finally did is:\n\n- Make a copy of the SQL 2000 db\n- Upgrade the copy\n- Detach the databases \n- Copy in the 2000 mdf and ldf files\n- Reattach the databases\n- Upgrade from 8.0 to 9.0 format.
688149
Of course you'll se the difference! Not mainly in speed but mostly regarding the entire ysstem stability.. The only problem is that at this time many applications are still written in 32-bit and eventualy don't support 64-bit applications. It's the only disadvantage, and I could say minor because very soon 64 bit will be the new standard for cpu processing!
667928
i think it should be Oracle 8.0
103644
there is no 'the' difference.\n\nthey are so dis-similar, one could spend a number of years cateloggin their differences.....\n\nI want a million dollars !      it's good to want.\n\nwe both have a similar chance of getting what we want, via this forum.\n\nluck !\n\n\ndude...those links will just be defining them, not listing their differences....\n\nOMG...Greeney that's wrong.\n\nDOS was around LONG before there was windows.  IT DOES NOT need windows to operate. It CAN run under windows, BUT windows 1,2, and 3 needed DOS under THEM to run.\nLOL