Difference between SQL and Oracle?

hi techendeavour,
i think otshare is right
thank u

 

Hi,
Oracle corporation is one of the company which invented database languages. SQl, Pl/SQl, Oracle Apps, Rak etc are products of Oracle. We don't have any language like Oracle its only company name. People who don't have any knowledge about Oracle products and history they used to call these languages as Oracle.

 

Oracle and then Oracle Apps Technical

 

If someone wants to become a DBA(Database Administrator) then he/she should go for every databases one by one...It better to start with ORACLE...if anyone can learn oracle database and can get themselves certified then it will definitely boost their confidence as DBA.....!!

 

oracle database is used for only oracle software but ms sql database is used for daily and regular programs and softwares of all kind.

 

With an Oracle driver for the operating system in use, you can access Oracle Database from any operating system, using any programming language. That's true of any database, not just Oracle.

 

Do u mean SQL Server and Oracle . If so both are DB . Both have standard SQL functionalities . But for advanced DB optimization like Partitioning , Materialized Views etc Oracle is far superior . Use SQL Server for small applications .

For SQL Queries with examples , visit http://a4academics.com/tutorials/24-sql-tutorial

 

1.Oracle Support Pl-Sql(Procedural Language) in addition to Sql ,Mysql support only Sql

2.Oracle Provides lots of security features such as row lock while Mysql provide column.

3.Oracle requires username,password,profile validation at the time of logging while Mysql requires only username,password and host.

4.Oracle9i Database supports the use of temporary tables for an individual session, or global to all users.

5.Oracle is used for the large Enterprise .

6.Mysql is light,reliable and can connect to multi-Client Program.

7.facebook-The world 2nd number website drive on mysql.

8.MySQL does not support data partitions, and requires a server for each set of data files. Scalability is limited to the size of a single server. The limitations within MySQL of not supporting distributed databases is a serious roadblock in creating a high-performance, scalable database solution.

9.MySQL is an open source database, and is completely free.
10.Compare to Oracle, MySQL doesn't have Tablespace, Role management, snapshots, synonym and packages.

 

Why you want to learn a database software? Would you be a database specialist, choose one. when you learn one of them clearly, you will be a master on all of them.

What a database specialist knows?
Oracle, MS SQL or MySql? (NO) these are just softwares.

You have to learn;
SQL,
How organize collection of data,
Relational database system,
Database design and modeling,
Database building, maintaining, and tuning
etc.

 

if you compare MSSQL and MYSQL Vs Oracle..
Defiantly ORACLE is best... but cost-wise MySQL is butter

 

learn Structured Query language,basics for DBA, the one can go for Oracle or Toad(new DB product) or mysql. More over there are other DB like NO SQL, Mongo DB etc. Google them .Its new learning to all