Answer Posted / Harish Chandra Kanojia
PL/SQL is needed for various reasons, including: 1) Procedural control, allowing complex business logic to be encapsulated within stored procedures and functions. 2) Improved performance by minimizing network traffic through caching and avoiding repeated SQL statements. 3) Enhanced data integrity and security through triggers and sequences. 4) Support for complex data types, collections, and exceptions.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the current version of sql?
what is schema? : Sql dba
define sql insert statement ? : Sql dba
how many tables will create when we create table, what are they? : Sql dba
how to escape special characters in sql statements? : Sql dba
how to start mysql server? : Sql dba
what is dbms? : Sql dba
what is bcp? When does it used? : Sql dba
Can we rollback truncate?
What is the current version of postgresql?
what is collation? : Sql dba
Do we need to rebuild index after truncate?
Is inner join faster than left join?
What is the best sql course?
Does group by remove duplicates?
