what is the difference between SQL and ORACLE?

Question

Can anyone describe me the difference between SQL and ORACLE? Besides, plz tell me how to get started with SQL? i have installed SQL 7.0 version,but dont know how to proceed further.Plz help!!!!!!!!

Answer 1

SQL stands for Structured Query Language.



Oracle is one of the companies which makesdatabase products which use SQL for database queries etc.



Microsoft also makes these Database products sold as SQL Server range.



You can use the links below for more info and learning SQL.



Hope this helps.

Answer 2

I guess these type of questions should be posted on tech webistes like http://www.devx.com/.

Anyway, SQL means structured query language. It is designed to get data from a Relational database.

It is simple and looks like plain english and easy to use.



Oracle, Sql Server, DB2, Ingress are some of the relational databases.



So you can use SQL to get data you have stored in Oracle using SQL.



Now, you said you have installed SQL 7.0. I think you have installed sql server 7.0. So you can use sql to get data stored in that database.

The best thing is to search for some tutorials on the web and learn how to use the database and sql.

Answer 3

SQL Server is a Microsoft product where as Oracle is a product of Oracle Corp. Both are RDBMS solutions with some differences in the syntax.

Answer 4

I'm afraid, I contradict OracleDBA's view on locking in DB2. DB2 allows concurrent users to update the same table - but does not allow to update the same row by two diffent users at the same time. Imagine the examples OracleDBA has given ... say, in a cinema booking system , if there is only one seat vacant, and if two users are allowed to simaltaneously update the record without one knowing about the other's update - how will that work ?????? To my understanding, by default, Oracle's locking is optimistic and DB2's is pessimistic. In both the databases you can use the other one. In my personal opinion, DB2's defualt locking , though is restrictive (and annoying at times) it forces you to do a good application design .. In DB2, with poor design you end up with locking problems, but in Oracle you end up with data problems. HTH Sathyaram