What are the advantages of PL/SQL functions?

Q 31. What are the advantages of PL/SQL functions?

Ans : The advantages of PL / SQL functions are as follows:

1. We can make a single call to the database to run a block of statements. Thus, it improves the performance against running SQL multiple times. This will reduce the number of calls between the database and the application.
2.  We can divide the overall work into small modules which becomes quite manageable, also enhancing the readability of the code.
3. It promotes reusability.
4. It is secure since the code stays inside the database, thus hiding internal database details from the application(user). The user only makes a call to the PL/SQL functions. Hence, security and data hiding is ensured.

Donate to  grow Studyandupdates

स्टडीएंडअपडेट्स को विकसित करने के लिए  मदत करें

To Provide  more Services among Student

छात्र के बीच अधिक से अधिक  सेवाएं प्रदान करने के लिए