Answer Posted / glibwaresoftsolutions
Using PL/SQL packages offers several benefits, including:
• Encapsulation: You can encapsulate related code and data within a package, promoting modular and organized code.
• Reusability: Packages allow you to reuse code across multiple programs and reduce redundancy.
• Information Hiding: You can hide implementation details by exposing only the necessary interfaces in the package specification.
• Improved Performance: Packages are precompiled and stored in the database, which can enhance performance.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how to include numeric values in sql statements? : Sql dba
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What are the types of join in sql?
What do you mean by dbms? What are its different types?
What is pl sql block in dbms?
what is try_catch block in procedure
Is sql a programming?
Why stored procedures are faster than query?
What is the difference between numeric and autonumber?
Explain the working of primary key?
Which is better cte or subquery?
How to run sql functions in pl/sql?
What are joins in sql?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
Difference between table function and pipelined function?
