0
The main difference between db2 and oracle is the fact that db2 is owned by IBM corporation and oracle is owned by Oracle Corporation.
Both db2 and oracle are extremely powerful RDBMS systems which offer a wide variety of featues to its users.
1.DB2 is an RDBMS from IBM while Oracle is an RDBMS from the company of the same name
2.IBM offers DB2 packaged along with its iSeries hardware and operating system while Oracle is sold as an independent software
3.Most people usually regard to Oracle as superior due to many shortcomings of DB2
4.Oracle directly supports a Java application server where you can deploy Java servlets while with DB2 you would need to employ a Java translator like Tomcat
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
Is possible select 3 tables from oracle db at a time?
yes
Why is Oracle 10g named so?
In Oracle 10g, 'g' stands for grid computing. For more details about Oracle 10g and overall Oracle DB please refer the following link:http://en.wikipedia.org/wiki/Oracle_Database
When you start an Oracle DB which file is accessed first?
init.ora file is read first
What company developed Berkeley DB software?
The company that developed Berkeley DB software is Sleepycat Software, later Oracle Corporation. Berkeley DB software provides an embedded database for key(value) data.
What is the difference between oracle 88i9i11i10g?
They are just different versions of Oracle.
What is the dominating DBMS?
According to DB Engines regular ranking study, Oracle is the most popular DBMS. MySQL comes in second, then MS SQL, then a large gap before the rest of the database management systems. db-engines.com/en/ranking
What is oracle in ms dos?
Have you ever seen the movie, The Matrix? Well the oracle in ms dos is no different.
How do you convert from db HL to db SPL?
dB SPL is a comparison of a sound level to what was thought to be the threshold of hearing, although today it is known that the value was too high. dB HL is a measure of hearing loss - a comparison of a subjects hearing compared to a 'normal' standard. As they are measure different things a direct comparison is not possible. The differences between dB HL and dB SPL, arise from isophonic curves. There is no direct (linear) formula to convert this but a set of formulas. For different frequencies, different values should be added. For eg., at 1kHz you can state that 0dB HL is around 2dB SPL while at 250Hz, 0dB HL is 12 dB SPL. db HL = db Hearing Level db SPL = db Sound Pressure Level
Where can one get a Yes No Oracle?
Actually there are several different Yes / No Oracle sites available online. Some examples include "The-Oracle-Answers", "Facade" (select "Yes or No" from the menu) or "Yes No Oracle" from VIP Tarot.
Different sources of noise and their corresponding measurement of loudness in dB?
Leaves rustling produces about 10 dB of noise. A chainsaw, when one yard away is around 110 dB of noise. Normal human conversation is around 60 dB.
What are the Current trends in dbms?
ORACLE firp bird IBM DB2 Informix Interbase PostgreSQL MySQL Zope ADABAS Sybase SQLite SQL Server SAP DB
What are the different jdbc drivers available?
If you need to access a database with Java, you need a driver. This is a list of the drivers available, what database they can access, who makes it, and how to contact them. IBM DB2 jdbc:db2://<HOST>:<PORT>/<DB> COM.ibm.db2.jdbc.app.DB2Driver JDBC-ODBC Bridge jdbc:odbc:<DB> sun.jdbc.odbc.JdbcOdbcDriver Microsoft SQL Server jdbc:weblogic:mssqlserver4:<DB>@<HOST>:<PORT> weblogic.jdbc.mssqlserver4.Driver Oracle Thin jdbc:oracle:thin:@<HOST>:<PORT>:<SID> oracle.jdbc.driver.OracleDriver PointBase Embedded Server jdbc:pointbase://embedded[:<PORT>]/<DB> com.pointbase.jdbc.jdbcUniversalDriver Cloudscape jdbc:cloudscape:<DB> COM.cloudscape.core.JDBCDriver Cloudscape RMI jdbc:rmi://<HOST>:<PORT>/jdbc:cloudscape:<DB> RmiJdbc.RJDriver Firebird (JCA/JDBC Driver) jdbc:firebirdsql:[//<HOST>[:<PORT>]/]<DB> org.firebirdsql.jdbc.FBDriver IDS Server jdbc:ids://<HOST>:<PORT>/conn?dsn='<ODBC_DSN_NAME>' ids.sql.IDSDriver Informix Dynamic Server jdbc:informix-sqli://<HOST>:<PORT>/<DB>:INFORMIXSERVER=<SERVER_NAME> com.informix.jdbc.IfxDriver InstantDB (v3.13 and earlier) jdbc:idb:<DB> jdbc.idbDriver InstantDB (v3.14 and later) jdbc:idb:<DB> org.enhydra.instantdb.jdbc.idbDriver Interbase (InterClient Driver) jdbc:interbase://<HOST>/<DB> interbase.interclient.Driver Hypersonic SQL (v1.2 and earlier) jdbc:HypersonicSQL:<DB> hSql.hDriver Hypersonic SQL (v1.3 and later) jdbc:HypersonicSQL:<DB> org.hsql.jdbcDriver Microsoft SQL Server (JTurbo Driver) jdbc:JTurbo://<HOST>:<PORT>/<DB> com.ashna.jturbo.driver.Driver Microsoft SQL Server (Sprinta Driver) jdbc:inetdae:<HOST>:<PORT>?database=<DB> com.inet.tds.TdsDriver Microsoft SQL Server 2000 (Microsoft Driver) jdbc:microsoft:sqlserver://<HOST>:<PORT>[;DatabaseName=<DB>] com.microsoft.sqlserver.jdbc.SQLServerDriver MySQL (MM.MySQL Driver) jdbc:mysql://<HOST>:<PORT>/<DB> org.gjt.mm.mysql.Driver Oracle OCI 8i jdbc:oracle:oci8:@<SID> oracle.jdbc.driver.OracleDriver Oracle OCI 9i jdbc:oracle:oci:@<SID> oracle.jdbc.driver.OracleDriver PostgreSQL (v6.5 and earlier) jdbc:postgresql://<HOST>:<PORT>/<DB> postgresql.Driver PostgreSQL (v7.0 and later) jdbc:postgresql://<HOST>:<PORT>/<DB> org.postgresql.Driver Sybase (jConnect 4.2 and earlier) jdbc:sybase:Tds:<HOST>:<PORT> com.sybase.jdbc.SybDriver Sybase (jConnect 5.2) jdbc:sybase:Tds:<HOST>:<PORT> com.sybase.jdbc2.jdbc.SybDriver To test your driver once it's installed, try the following code: { Class.forName("Driver name"); Connection con = DriverManager.getConnenction("jdbcurl","username","password"); //other manipulation using jdbc commands } catch(Exception e) { }
