1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Difference between SQL and Oracle?

Discussion in 'Databases' started by techendeavour, May 30, 2011.

0
Page 5 of 5
  1. nannysingh

    nannysingh Peon

    Messages:
    23
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #81
    hi techendeavour,
    i think otshare is right
    thank u
     
    nannysingh, Oct 3, 2012 IP
  2. rebbicajackson

    rebbicajackson Peon

    Messages:
    7
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #82
    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.
     
    rebbicajackson, Oct 11, 2012 IP
  3. Xfactormaster

    Xfactormaster Greenhorn

    Messages:
    10
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    11
    #83
    Oracle and then Oracle Apps Technical
     
    Xfactormaster, Dec 28, 2012 IP
  4. amrush

    amrush Active Member

    Messages:
    30
    Likes Received:
    2
    Best Answers:
    2
    Trophy Points:
    58
    #84
    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.....!!
     
    amrush, Dec 29, 2012 IP
  5. usman8

    usman8 Banned

    Messages:
    205
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    16
    #85
    oracle database is used for only oracle software but ms sql database is used for daily and regular programs and softwares of all kind.
     
    usman8, Jan 15, 2013 IP
  6. Rukbat

    Rukbat Well-Known Member

    Messages:
    2,908
    Likes Received:
    37
    Best Answers:
    51
    Trophy Points:
    125
    #86
    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.
     
    Rukbat, Jan 16, 2013 IP
  7. a4academics

    a4academics Greenhorn

    Messages:
    21
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    21
    #87
    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
     
    a4academics, Jan 18, 2013 IP
  8. friendsfocus

    friendsfocus Member

    Messages:
    36
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    26
    #88
    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.
     
    friendsfocus, Mar 25, 2013 IP
  9. ugur_ben

    ugur_ben Member

    Messages:
    4
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    36
    #89
    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.
     
    ugur_ben, Mar 26, 2013 IP
  10. as raj

    as raj Greenhorn

    Messages:
    4
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    21
    #90
    if you compare MSSQL and MYSQL Vs Oracle..
    Defiantly ORACLE is best... but cost-wise MySQL is butter
     
    Last edited by a moderator: Apr 5, 2013
    as raj, Apr 5, 2013 IP
  11. Vinil Mehta

    Vinil Mehta Member

    Messages:
    190
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    48
    #91
    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
     
    Vinil Mehta, Apr 17, 2013 IP
Page 5 of 5