State the different extensions for stored procedures? - Most of the database systems have proprietary and vendor based extensions. Microsoft allows procedures to be written using Transact-SQL. Oracle calls its extension as PL/SQL. DB2 has its extension as PL/SQL. PL/pgSQL is the extension used by Postgre SQL and this allows users to have their own functional language such as pl/PHP and pl/Perl. - Stored Procedures Interview Questions and Answers

Our Services

Get 9,000 Interview Questions & Answers in an eBook.

Get it now !!

Search Interview Questions

Question: State the different extensions for stored procedures?

Answer: Most of the database systems have proprietary and vendor based extensions. Microsoft allows procedures to be written using Transact-SQL. Oracle calls its extension as PL/SQL. DB2 has its extension as PL/SQL. PL/pgSQL is the extension used by Postgre SQL and this allows users to have their own functional language such as pl/PHP and pl/Perl.

Category	Stored Procedures Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.3) By 4251 users
Added on	9/16/2014
Views	42345
Rate it!

Question: State the different extensions for stored procedures?

Answer:

Most of the database systems have proprietary and vendor based extensions. Microsoft allows procedures to be written using Transact-SQL. Oracle calls its extension as PL/SQL. DB2 has its extension as PL/SQL. PL/pgSQL is the extension used by Postgre SQL and this allows users to have their own functional language such as pl/PHP and pl/Perl. Source: CoolInterview.com

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
	Explain about the implementation of stored procedures?	View Answer
	What is the difference between a user defined function and a Stored procedure?	View Answer
	What are the uses of stored procedure?	View Answer
	what is the Difference between View and Stored Procedure?	View Answer
	Where the procedures are stored in database?	View Answer
	Can we use commit inside the trigger? If not then how can we save the transxaction made by the trigger?	View Answer
	How can we call stored procedures inside store procedures?	View Answer
	what is the difference between stored procedures and stored functions in ORACLE	View Answer
	What are external procedures ? Why and when they are used?	View Answer
	What is stored procedure?	View Answer
	What is the difference between stored procedures and stored functions in ORACLE	View Answer
	What is the difference between "IS" and "AS" while creating procedure. Ex:- create procedure IS or AS	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 Stored Procedures Interview Questions & Answers - Exam Mode / Learning Mode