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