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.

  1. #1
    Hi,

    I want to learn Database, some of my friends are suggesting SQL and Oracle, would like to know which is the best one?

    Thanks
     
    techendeavour, May 30, 2011 IP
  2. gudzik

    gudzik Member

    Messages:
    44
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    43
    #2
    Oracle is stronger. I am engaged Oracle but also MySQL I do not avoid
     
    gudzik, May 30, 2011 IP
  3. socialmediamarketing01

    socialmediamarketing01 Peon

    Messages:
    427
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Oracle database is more secure than MySql. But MSSql is also secure one.
     
    socialmediamarketing01, May 30, 2011 IP
  4. b10

    b10 Peon

    Messages:
    755
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Oracle >> MS SQL / MySQL

    Oracle is the best ...then MSSQL or MySQL
     
    b10, May 31, 2011 IP
  5. shiva0077

    shiva0077 Peon

    Messages:
    110
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    I think oracle is secure than others so you first learn oracle and then others.
     
    shiva0077, Jun 29, 2011 IP
  6. cute-sherry

    cute-sherry Peon

    Messages:
    62
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    I think so Oracle is best and secure after that Mysql and MSSQL also best.....
     
    cute-sherry, Jul 4, 2011 IP
  7. som3on3

    som3on3 Active Member

    Messages:
    138
    Likes Received:
    1
    Best Answers:
    1
    Trophy Points:
    63
    #7
    All sql's are the same, all depends on what you do with your website
    if you make a "standard" website use sqlite or mysql
    if you want to work with something very stable and much more secure, use Oracle
     
    som3on3, Jul 4, 2011 IP
  8. annie0207

    annie0207 Greenhorn

    Messages:
    43
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    16
    #8
    SQl is more suitable for a beginner to learn. When you familiar with SQL, you study about Oracle ;) Good luck
     
    annie0207, Jul 11, 2011 IP
  9. omeslawanya

    omeslawanya Peon

    Messages:
    69
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #9
    Oracle is an object relational database management system, which allows objects to be stored in tables, in a manner similar to numbers and words being stored in an RDBMS system


    The only interface available between end users and an RDBMS is Structured Query Language (SQL). All other applications and tools that users utilize to interact with the RDBMS act as translators/interpreters. These tools generate SQL commands based on a user's request and pass the generated SQL commands on to the RDBMS.
     
    omeslawanya, Jul 12, 2011 IP
  10. unknownpray

    unknownpray Active Member

    Messages:
    3,831
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    70
    #10
    As people suggest , try oracle , but i ersnally prefer sql too , i learned it already :)
     
    unknownpray, Jul 19, 2011 IP
  11. nisha134

    nisha134 Peon

    Messages:
    51
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #11
    I think oracle is more secure than my sql.
    because in oracle packages are there and in my sql no packages.in oracle tablespace are there and in sql no tablespace.
     
    nisha134, Jul 23, 2011 IP
  12. cute-sherry

    cute-sherry Peon

    Messages:
    62
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #12
    Oracle database is more secure than MySql which allows objects to be stored in tables, in a manner similar to numbers and words, but SQl is more suitable for a beginner to learn.
     
    cute-sherry, Jul 25, 2011 IP
  13. ankitasharma

    ankitasharma Greenhorn

    Messages:
    51
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    16
    #13
    Oracle is an object relational database management system, which allows objects to be stored in tables, in a manner similar to numbers and words being stored in an RDBMS system.


    The only interface available between end users and an RDBMS is Structured Query Language (SQL). All other applications and tools that users utilize to interact with the RDBMS act as translators/interpreters. These tools generate SQL commands based on a user's request and pass the generated SQL commands on to the RDBMS.
     
    ankitasharma, Jul 26, 2011 IP
  14. fromwz

    fromwz Peon

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #14
    oracle is power
    ms sql is simple
    mysql is free
     
    fromwz, Jul 28, 2011 IP
  15. Vinil Mehta

    Vinil Mehta Member

    Messages:
    190
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    48
    #15
    SQL is structured query language but oracle is database .If you learn SQL ,Oracle is easy to begin and deploy applications over it So i recommend SQL first
     
    Vinil Mehta, Aug 29, 2011 IP
  16. Rukbat

    Rukbat Well-Known Member

    Messages:
    2,908
    Likes Received:
    37
    Best Answers:
    51
    Trophy Points:
    125
    #16
    Oracle is a database (a program), SQL is a programming language used to talk to databases, Oracle SQL is an extension to SQL. In order to learn Oracle SQL you learn standard SQL first, then you learn the Oracle extensions. It's not either/or, it's "do you add the Oracle extensions to your knowledge base".
     
    Rukbat, Sep 13, 2011 IP
  17. bentonjiujitsu

    bentonjiujitsu Peon

    Messages:
    5
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #17
    oracle is the best then others database system i can say that oracle is the power and and ms sql is the simple database . thanks
     
    bentonjiujitsu, Sep 26, 2011 IP
  18. Mohammed Ammar

    Mohammed Ammar Member

    Messages:
    39
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #18
    SQL is for the beginners but oracle is better than sql so i recommend you first practise sql and then oracle
     
    Mohammed Ammar, Oct 5, 2011 IP
  19. otshare

    otshare Peon

    Messages:
    70
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #19
    SQL is not a database. It stands for Structured Query Language. SQL is used to query data from a Database. Oracle is a database where you store data.

    Your Friends may be talking of MySQL database when they said SQL database or may be of MS SQL Server database.
    MySQL and MS SQL Server - both are databases. You can use SQL to retreive data from them.

    Note: MySQL is FREE and easy to learn. MS SQL Server is NOT FREE and comparatively hard to learn. Oracle is best database but cost a fortune and learning curve depends on what you want to achieve...programming or Administration.

    If you are just looking to learn just enough to design/maintain website related databases then MySQL is more than enough.
     
    otshare, Oct 10, 2011 IP
  20. alimoula

    alimoula Peon

    Messages:
    114
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #20
    MySQL is very easy and oracle is difficult but oracle is much stronger then MySQL
     
    alimoula, Oct 11, 2011 IP