CSS Forums Thursday, May 23, 2013
08:59 PM (GMT +5)
 
 
Home   Beginner's Guide   Rules   Syllabus   Past Papers   CSP Members  

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


Reply Share this thread on: Submit Thread to Facebook Facebook     Submit Thread to del.icio.us del.icio.us     Submit Thread to Google Google     Submit Thread to Digg Digg     Submit Thread to StumbleUpon StumbleUpon    
 
LinkBack Thread Tools
  #1  
Old Saturday, April 24, 2010
engr.jibran's Avatar
Junior Member
 
Join Date: Apr 2010
Location: Home Land
Posts: 24
Thanks: 22
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…
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiTweet this Post!
Reply With Quote
  #2  
Old Tuesday, July 06, 2010
Junior Member
 
Join Date: Jun 2010
Location: hyderabad
Posts: 5
Thanks: 1
Thanked 3 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...
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiTweet this Post!
Reply With Quote
  #3  
Old Wednesday, July 07, 2010
6561's Avatar
Member
 
Join Date: Apr 2009
Posts: 71
Thanks: 13
Thanked 33 Times in 25 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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiTweet this Post!
Reply With Quote
  #4  
Old Thursday, December 30, 2010
Bourne's Avatar
Junior Member
 
Join Date: Sep 2009
Location: Internet
Posts: 20
Thanks: 16
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiTweet this Post!
Reply With Quote
  #5  
Old Saturday, January 22, 2011
khuhro's Avatar
Senior Member
 
Join Date: Jun 2008
Location: سنڌ
Posts: 519
Thanks: 146
Thanked 419 Times in 263 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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiTweet this Post!
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: 27
Thanks: 3
Thanked 11 Times in 6 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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiTweet this Post!
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 3 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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiTweet this Post!
Reply With Quote
  #8  
Old Sunday, May 20, 2012
Junior Member
 
Join Date: Nov 2010
Location: Faisalabad, Pakistan
Posts: 4
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiTweet this Post!
Reply With Quote
  #9  
Old Sunday, May 20, 2012
Bilal Hassan's Avatar
Senior Member
 
Join Date: Oct 2011
Location: Lahore
Posts: 878
Thanks: 91
Thanked 664 Times in 441 Posts
Bilal Hassan is just really niceBilal Hassan is just really niceBilal Hassan is just really niceBilal Hassan is just really nice
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiTweet this Post!
Reply With Quote
  #10  
Old Monday, May 21, 2012
Junior Member
 
Join Date: Jun 2011
Posts: 22
Thanks: 14
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiTweet this Post!
Reply With Quote
Reply


Thread Tools

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 12:25 PM


CSS Forum on Facebook Follow CSS Forum on Twitter

Disclaimer: This is not the official website of Federal Public Service Commission Pakistan. This is a non-commercial website helping individuals who intend to join civil service of Pakistan. The material on this website is provided for informational purposes only. We do not claim that the site is an exhaustive compilation of information about Civil Service of Pakistan neither represent or endorse the accuracy or reliability of any information, content contained on, or linked, downloaded or accessed from any page of this website. These materials are intended, but not promised or guaranteed to be current, complete or up to date. However, honest efforts have been made to provide comprehensive information for the benefit of users. The documents and material displayed or mentioned on this site are not official copies. Please contact FPSC for updated rules and regulations governing CSS examination.

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