Watch Our YouTube Channel
It is currently Tue Jan 23, 2018 1:51 am
 

All times are UTC



Post new topic Reply to topic  [ 1 post ] 
Author Message
PostPosted: Sat Mar 12, 2016 7:35 am 
Offline

Joined: Fri Nov 13, 2015 3:56 am
Posts: 460
SQL:
[1]Sql is a language used to query relational database systems.SQL full form is structured query language.
[2]Sql is like update,delete,find, etc.
[3]sql basically using multithreading concept where oracle using multiprocessor oracle using for high database handling like banking etc.
[4]Sql language is used in oracle as a writing language.
[5]In SQL server there is no transaction control.
[6]SQL Server is for performance and not read consistency.
Learn Sql Basics from this video


ORACLE:
[1]Oracle is a specific relational database system. So if you are using Oracle, you will also be using SQL to get information out of it.
[2]Oracle is one type of DBMS software.Oracle understands only sql language.
[3]There are so many versions of oracle like 9G,10G,11G,But Sql has no version,it is a language,only new features are added to it.
[4]The only interface available between end users and an RDBMS is SQL.
[5]Oracle is an object relational database management system, which allows objects to be stored in tables, in a manner similar to numbers and words being stored in an RDBMS system.
[6]In Oracle everything is transaction and it is not permanent until you commit.
[7]Oracle where read consistency is default and un bendable.
Learn about Oracle from this video


PL/SQL:
[1]PL/SQL, Oracle's procedural extension of SQL, is an advanced fourth-generation programming language (4GL).
[2]It offers software-engineering features such as data encapsulation, overloading, collection types, exceptions, and information hiding.
[3]PL/SQL also supports rapid prototyping and development through tight integration with SQL and the Oracle database.
[4]PL/SQL is a proprietary procedural language used by Oracle
[5]PL/SQL is a combination of SQL along with the procedural features of programming languages. It was developed by Oracle Corporation

MySQL:
[1]MySQL is a also a Database tool itself that uses SQL language.it is open source.
[2]MySQL is weaker in the areas of inserting and deleting data. But it is an excellent choice, for data storage and referencing data.
[3]MySQL is a relational database management system. You can submit SQL queries to the MySQL database to store, retrieve, modify or delete data.
[4]Basically, MySQL is one of many books holding everything, SQL is how you go about reading that book.

SQLite
[1]SQLite is a library for embedding a relational database within an application and aimed primarily at single user environments.
[2]SQLite is a third party ,open-sourced and in-process database engine. SQL Server Compact is from Microsoft, and is a stripped-down version of SQL Server.
[3]SQLite is file-based, unlike other databases, like SQL Server and MySQL which are server-based.

_________________
Learn Web Development | Latest Technology News |Motivational Quotes


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 

All times are UTC


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron