Answer Posted / Amit Trivedi
PL/SQL is used in Oracle Database to write procedural code, which allows for more complex database operations than what can be achieved with SQL alone. It provides features like loops, conditional statements, cursors, and user-defined functions, making it possible to create more efficient and reusable code.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is collation? : Sql dba
Do we need to rebuild index after truncate?
What is the best sql course?
what are aggregate and scalar functions? : Sql dba
what are the advantages of sql ? : Sql dba
how to start mysql server? : Sql dba
Can we rollback truncate?
What is the current version of sql?
what is bcp? When does it used? : Sql dba
If a cursor is open, how can we find in a pl/sql block?
What is your daily office routine?
Is primary key always clustered index?
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
what is schema? : Sql dba
what is dbms? : Sql dba
