|
Share Thread: Facebook Twitter Google+ |
|
LinkBack | Thread Tools | Search this Thread |
#1
|
||||
|
||||
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, |
#2
|
|||
|
|||
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...
|
#3
|
||||
|
||||
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 |
#4
|
||||
|
||||
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. |
#5
|
||||
|
||||
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 |
The Following 2 Users Say Thank You to khuhro For This Useful Post: | ||
multithinker (Saturday, October 20, 2012), sweetPakistan (Monday, January 24, 2011) |
#6
|
||||
|
||||
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 |
#7
|
||||
|
||||
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. |
#8
|
|||
|
|||
Those all are database management systems.. Most Popular is MySQL
|
#9
|
||||
|
||||
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. |
#10
|
|||
|
|||
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. |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
SQL (Structured Query Language) | Janeeta | Computer Science | 0 | Saturday, January 19, 2008 01:25 PM |