What is sql? what is the difference between sql and pl/sql? - SQL: is a structured query language which subdivided in to 5 categories like DDL, DML, DQL, DCL, TCL PLSQL: is a programming language structured query language which consists of procedure, function, triggers, collection.

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

DATABASE

SQL

DETAILS

Question: What is sql? what is the difference between sql and pl/sql?

Answer: SQL: is a structured query language which subdivided in to 5 categories like DDL, DML, DQL, DCL, TCL PLSQL: is a programming language structured query language which consists of procedure, function, triggers, collection.

Category	SQL Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.2) By 9193 users
Added on	5/19/2013
Views	70668
Rate it!

Question: What is sql? what is the difference between sql and pl/sql?

Answer:

SQL: is a structured query language which subdivided in to 5 categories like DDL, DML, DQL, DCL, TCL PLSQL: is a programming language structured query language which consists of procedure, function, triggers, collection. Source: CoolInterview.com

Answered by: kiran | Date: 5/21/2008 |

Contact kiran

SQL stand for Structure Query Language. It is used to store the data on the base of specific structure. PL/SQL stand for Programming Language/Structure Query Language. It is used for Programming to solve the logic. It contain conditional statement, Loop Statement,procedure and function. Source: CoolInterview.com

Answered by: Virender | Date: 6/5/2008 |

Contact Virender

SQL is a Structured Query Language this is based on queries.SQL Classified as DML-DataManipulationLanguage DDL-DataDefinitionLanguage TCL-TransactionControlLanguage DCL-DataControlLanguage PL/SQL is the expansion of Procedural Language and Structured Query Language it provides you procedure and logic based such as conditional statement,looping statement,storedprocedure,fuctions,cursors,packages,triggers these are used in PL/SQL Source: CoolInterview.com

Answered by: hari | Date: 2/23/2009 |

Contact hari

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	Why do we use cache and no cache in sequences? What is the benefit we have in using them?	View Answer
	Write short notes in XSU & java ?	View Answer
	How to generate OIDS ?	View Answer
	What is output of following query Select 2 from employee;	View Answer
	What is normalization and different kinds of normalization?	View Answer
	How to testdata loading in database testing?	View Answer
	What columns would you use as a clustered index on a retail store address table?	View Answer
	what is the query for to select multiple columns to generate single row in the sql and how come we can bring grid views in sql for getting those datas are demolished	View Answer
	What is a clustered index?	View Answer
	What is the difference between @@identity and SCOPE_IDENTITY()?	View Answer
	1. How to create a new table? 2. How to insert another column into the table?	View Answer
	What is the use of indexes?Explain about it?	View Answer
	lets i have a table "bapi" having 6 field like this f1 f2 f3 f4 f5 f6 ... ... .. ... ... ... p r o m o d i want to retrive all the data by using select statement and my output will be look like this: xyz ... p r o m o d	f1 f2 f3 f4 f5 f6 ... ... .. ... - SQL Interview Questions & Answers"> View Answer
	what is the difference between replace and translate functions?	View Answer
	How to delete same id in rows? For example empid=5 repeated for times in rows. How to delete which sql query is used?	View Answer
	Difference between decode and case. in which case we are using case and in which case we are using decode? with an example.	View Answer
	How to retrieving the data from 11th column to n th column in a table.	View Answer
	what is the difference between oracle,sql and sql server	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All SQL Interview Questions & Answers - Exam Mode / Learning Mode