If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > sql server vs oracle

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-29-09, 00:22
hkp819 hkp819 is offline
Registered User
 
Join Date: Dec 2008
Posts: 59
sql server vs oracle

hello friend,
i am new in sql. I do not know about sql and oracle. I have just start learning sql. and I am confused that what is the difference between the sql and oracle. can anybody tell me that what is the difference between the sql server and the oracle.
__________________
New York Web design
Website design

Reply With Quote
  #2 (permalink)  
Old 01-29-09, 00:49
healdem healdem is online now
Jaded Developer
 
Join Date: Nov 2004
Location: out on a limb
Posts: 9,262
well SQL is the de facto language used in virtually every database. I would say all, but there may be one or more DB's out there somewhere which dont' use SQL.

Like most databases Oracle uses SQL, meaning people writing appliciation software use SQL to manipulate the db and extract data.

Although SQL was originally developed by IBM its now an internationally accepted and recognised standard (by ANSI & ISO) but virtually every manufacturer has their own variants, meaning that around 95..98% of SQL is common accross the board, each manufaturer has some variation from the standards, part of that is history (thats the way they did it prior to the standards being developed, part f that is because its a feature the manufacturer believes is a killer requirement to differentiate their product from others.

there are lots of databases that use SQL ranging from desktop DB's such as Access/JET and Filemaker through to fully blown server dbs like DB2, Oracle, SQL Server & MySQL amongst others

virtually every db can be used in virtually any application software, although it is easier using a microsoft db (such as Access or SQL Server) in a Microsoft development environment (such as Visual Studio).

Traditionally Oracle requires more DBA's and other support staff, its historyis as an alternative to DB2 and other db's running on mainframes. SQL server is and evolution / rewrite of Sybase's DB and developed primarily foruse on PC based servers.

if you want a detailed compariso between the various server products I'd suggest you do a Google
__________________
I'd rather be riding my Versys or my Tiger 800 let alone the Norton
Reply With Quote
  #3 (permalink)  
Old 01-29-09, 01:02
guelphdad guelphdad is offline
Registered User
 
Join Date: Mar 2004
Posts: 440
note that mysql is a database application different than the two dbs you asked about. if you have future questions about those dbs post in the correct forum.
Reply With Quote
  #4 (permalink)  
Old 01-30-09, 00:03
hkp819 hkp819 is offline
Registered User
 
Join Date: Dec 2008
Posts: 59
thanks healdem you tell me very useful information.
you explain every thing in easy way.
once again thanks for this guideline.
__________________
New York Web design
Website design

Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On