Wednesday, April 24, 2024
06:42 AM (GMT +5)

Go Back   CSS Forums > CSS Optional subjects > Group I > Computer Science

Reply Share Thread: Submit Thread to Facebook Facebook     Submit Thread to Twitter Twitter     Submit Thread to Google+ Google+    
 
LinkBack Thread Tools Search this Thread
  #1  
Old Saturday, April 24, 2010
engr.jibran's Avatar
Junior Member
 
Join Date: Apr 2010
Location: Home Land
Posts: 19
Thanks: 24
Thanked 4 Times in 4 Posts
engr.jibran is on a distinguished road
Default Difference between Oracle and SQL or MYSQL?

Hi,
Can any one throw light on the difference between Oracle data base management system and others like SQL, MYSQL etc...
Regards,
__________________
The harder the battle the sweeter the victory…
Reply With Quote
  #2  
Old Tuesday, July 06, 2010
Junior Member
 
Join Date: Jun 2010
Location: hyderabad
Posts: 5
Thanks: 1
Thanked 4 Times in 3 Posts
soha rao is on a distinguished road
Default My sql

The world's most popular open source database[1] MySQL is a relational database management system, or RDBMS. Basically it's a software package that is very good at the organization and management...
Reply With Quote
  #3  
Old Wednesday, July 07, 2010
6561's Avatar
Member
 
Join Date: Apr 2009
Posts: 53
Thanks: 10
Thanked 33 Times in 24 Posts
6561 is on a distinguished road
Default

between Oracle data base management system and others like SQL, MYSQL etc...

Oracle is a company:-) and data base management system is its product like 9i,10,11g.
SQL. is structured query language used in oracle. and it is used in managing data in relational data base management system RDBMS
MySQL,,,ySQL is a relational database management system. that runs as a server providing multi-user access to a number of databases
Reply With Quote
  #4  
Old Thursday, December 30, 2010
Bourne's Avatar
Junior Member
 
Join Date: Sep 2009
Location: Internet
Posts: 10
Thanks: 15
Thanked 6 Times in 5 Posts
Bourne is on a distinguished road
Default

I would rather differentiate them as :

MySql an open source brand with open editable capabilities .
SQL Server, Microsoft product with automation to use it like plug n play .
Oracle , a professional face of database where u cannot change anything unlike MySql and where u have paid a huge amount like SQL Server but less automation as compared to SQL Server. In developer's world real professionals and huge profiles prefer Oracle than SQL Server because of its stability , less capacity of getting crash like SQL Server and MySqL and reliability of working with huge data in an efficient manner.
Reply With Quote
  #5  
Old Saturday, January 22, 2011
khuhro's Avatar
Senior Member
 
Join Date: Jun 2008
Location: سنڌ
Posts: 401
Thanks: 134
Thanked 420 Times in 248 Posts
khuhro is a jewel in the roughkhuhro is a jewel in the roughkhuhro is a jewel in the rough
Default

Simply MySQL is a relational database management system (RDBMS) based on SQL

MySQL is a database system used on the web. Basically, a MySQL database allows you to create a relational database structure on a web-server somewhere in order to store data or automate procedures. If you think of it in comparison to Microsoft Access, MySQL is what holds all of your tables, PHP acts as your queries (among other things), and your forms are basically web pages with fields in them. With all of this combined, you can create truly spectacular projects on the web.

MySQL is also open source in that it’s free and falls under the GNU General Public License (GPL). Chances are, if you are getting your own web-page or already have one – your host supports MySQL and PHP. They are generally associated with (though not limited to) Unix/Linux based servers. If by chance you are considering getting your own page and want MySQL and PHP support, check out Dreamhost – I’ve been using them for years and they absolutely can’t be beat.

Interacting with a MySQL database is a little weird as you don’t have the tried and true WYSIWYG interface that something as easy as Microsoft Access affords. When creating tables, you’ll either have to create them by using SQL Statements, or by using another open-source tool available online called PHPMyAdmin. PHPMyAdmin gives you an easy-to-use interface that allows you to create tables and run queries by filling in a little bit of information and then having the tables created for you. This is good if you’re either lazy, or don’t feel like bothering with big and complicated SQL Statements.

While oracle is an orgnization that is working on different database programes. however it also launched their database models (languages) called oracle 9i and others that based (programmed) on inside structured qurey language SQL

hope you got the answer
__________________
It's Not Over 'til I Win
Reply With Quote
The Following 2 Users Say Thank You to khuhro For This Useful Post:
multithinker (Saturday, October 20, 2012), sweetPakistan (Monday, January 24, 2011)
  #6  
Old Monday, March 07, 2011
ali akbar's Avatar
Junior Member
 
Join Date: Oct 2006
Location: Khairpur Sindh
Posts: 24
Thanks: 3
Thanked 14 Times in 7 Posts
ali akbar is on a distinguished road
Default Oracle and sql

Oracle is an RDBMS Relational Database Management System and SQL (Structured Query Language) is a programming language.


Oracle is a software company. SQL (Structured Query Language) is a language for manipulating or retrieving information from a Relational Database system
__________________
If faith is lost, there is no security and there is no life for him who does not adhere to religion.
Muhammad Iqbal
Reply With Quote
  #7  
Old Monday, December 05, 2011
killerbee's Avatar
Junior Member
 
Join Date: Oct 2011
Location: karachi
Posts: 7
Thanks: 6
Thanked 4 Times in 1 Post
killerbee is on a distinguished road
Default Few More Differences.........

MySQL supports multiple table than Oracle such as innoDB, HEAP, MyISAM etc.
MySQL has Auto-Increment attribute assigned to column which is not present in Oracle.
Oracle has row locking while MySQL has only table locking.
Reply With Quote
  #8  
Old Sunday, May 20, 2012
Junior Member
 
Join Date: Nov 2010
Location: Faisalabad, Pakistan
Posts: 2
Thanks: 2
Thanked 0 Times in 0 Posts
NoName is on a distinguished road
Default

Those all are database management systems.. Most Popular is MySQL
Reply With Quote
  #9  
Old Sunday, May 20, 2012
Bilal Hassan's Avatar
43rd CTP (PAS)
Medal of Appreciation: Awarded to appreciate member's contribution on forum. (Academic and professional achievements do not make you eligible for this medal) - Issue reason: CSP Medal: Awarded to those Members of the forum who are serving CSP Officers - Issue reason: CE 2014 - Merit 13
 
Join Date: Oct 2011
Location: Deputy Commissioner Hunza Nagar
Posts: 1,090
Thanks: 195
Thanked 1,551 Times in 674 Posts
Bilal Hassan is a splendid one to beholdBilal Hassan is a splendid one to beholdBilal Hassan is a splendid one to beholdBilal Hassan is a splendid one to beholdBilal Hassan is a splendid one to beholdBilal Hassan is a splendid one to behold
Default

ORACLE is a software firm that specializes in Datbase softwares..
SQL is the language that is to access data ina DAtbase..that stands for Structured Query Language, that is written in the form of syntax/ code..
MYSQL is RDBMS that is used to link the database with a dynamic website that is built in popular web design language like PHP or .NET etc.
Reply With Quote
  #10  
Old Monday, May 21, 2012
Junior Member
 
Join Date: Jun 2011
Posts: 20
Thanks: 13
Thanked 1 Time in 1 Post
Mohammad Alics49 is on a distinguished road
Default

Moreover, mysql is open source database management system.
it is more suitable with open source technologies like php.
sql is structred query language,it is used to fetch data from database.
like: select * from student
it 'll fetch all records in student table.
Reply With Quote
Reply


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 On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL (Structured Query Language) Janeeta Computer Science 0 Saturday, January 19, 2008 01:25 PM


CSS Forum on Facebook Follow CSS Forum on Twitter

Disclaimer: All messages made available as part of this discussion group (including any bulletin boards and chat rooms) and any opinions, advice, statements or other information contained in any messages posted or transmitted by any third party are the responsibility of the author of that message and not of CSSForum.com.pk (unless CSSForum.com.pk is specifically identified as the author of the message). The fact that a particular message is posted on or transmitted using this web site does not mean that CSSForum has endorsed that message in any way or verified the accuracy, completeness or usefulness of any message. We encourage visitors to the forum to report any objectionable message in site feedback. This forum is not monitored 24/7.

Sponsors: ArgusVision   vBulletin, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.