Differentiation between Oracle & SQL

[Shekhar12]

Hi,

I am Bsc(IT) student. It was not too difficult for me to understand the oracle . But get confused when started learning the sql. I am not able to differentiate the in between oracle and the sql.

If anyone know the difference between the oracle and the sql then please let me know.

[Praetor]

Hi friends,

Following are some differences between oracle and sql:

*. Oracle: It the one of RDBMS(Relational Data base Management System) which enables us to the object value id the various tables of the database.

*. SQL: SQL( Structured Query Language) works as interface between the user of the database and the DBMS(Database Management System).

*. Oracle: Oracle mainly uses the concept of the "multiprocessor".

*. SQL: Oracle mainly uses the concept of the "multithreading".

[Katty]

Hello,

1.ORACLE is the advanced database handling tool than the SQL.
2.Oracle uses it's own programming language which is known as Pl-Sql.
3.Oracle has the advanced features than the SQL.
4.In Oracle we are able to use the query in more different methods rather than in the SQL.

I don't more other than above difference.

[Zecho]

Hi,

Normally SQL command comprises of DML and DDL type, Please go through the below example of the DML and DDL:

Example of DDL:

cteate table demo
(
columndemo1 number PRIMARY KEY,
columndemo2 varchar(20),
);

Example of DML:

Select columndemo1, columndemo2, columndemo3
FROM demo;