Answer Posted / Ritu Rana
PL/SQL (Procedural Language SQL) is a procedural extension of the SQL language. It allows developers to write complex business logic, control structures, and error handling within database stored procedures.nnPL/SQL is primarily used for managing and manipulating data in Oracle databases. It is essential for building Oracle applications because it enables writing more complex logic than plain SQL and can execute multiple SQL statements within a transaction.nnIn addition, PL/SQL provides powerful features like cursors, exceptions, triggers, and sequences that make it an ideal choice for developing high-performance database applications.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the current version of postgresql?
What is your daily office routine?
what is bcp? When does it used? : Sql dba
How do I remove duplicates in two columns?
what are aggregate and scalar functions? : Sql dba
how to use regular expression in pattern match conditions? : Sql dba
Can we use distinct and group by together?
What is the current version of sql?
What is the best sql course?
Can delete statement be rollbacked?
If a cursor is open, how can we find in a pl/sql block?
what is sql server agent? : Sql dba
what is dbms? : Sql dba
how to start mysql server? : Sql dba
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
