---
title: "State the different extensions for stored procedures?"  
description: "State the different extensions for stored procedures?"  
author: "Anonymous User"  
published: 2015-01-21  
updated: 2020-09-24  
canonical: https://www.mindstick.com/interview/2296/state-the-different-extensions-for-stored-procedures  
category: "mssql server"  
tags: ["sql server"]  
reading_time: 1 minute  

---

# 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.

## Answers

### Answer by Anonymous User

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.


---

Original Source: https://www.mindstick.com/interview/2296/state-the-different-extensions-for-stored-procedures

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.