PL/SQL INTERVIEW QUESTION & ANSWERS
| 6. |
Why use pl/sql? |
| |
- It acts as a support for sql.
- PL/SQL allows to declare variables and constants and use them in sql and procedural statements.
- Control structures are the most important PL/SQL extension of SQL.
- A PL/SQL cursor gives you a way to fetch and process database information.
- Errors are easily detected and handled.
|
| 7. |
What is a Recursive Subprogram? |
| |
A recursive subprogram is one that calls itself. Each recursive call creates a new
instance of any items declared in the subprogram, including parameters, variables, cursors, and exceptions. |
| 8. |
What is Dynamic SQL? |
| |
- Dynamic SQL statements built as character strings built at run time.
- The strings contain the text of a SQL statement or PL/SQL block.
- They can also contain
placeholders for bind arguments.
- Placeholder names are prefixed by a colon, and the names themselves do not matter.
|
| 9. |
Define binding? |
| |
The assigning of values to PL/SQL variables in SQL statements is called binding. |
| 10. |
What are the different types of PL/SQL bindings? |
| |
PL/SQL binding operations fall into three categories are :- In–bind : When a PL/SQL variable or host variable is stored in the database by an INSERT or UPDATE statement.
- Out–bind : When a database value is assigned to a PL/SQL variable or a host variable by the RETURNING clause of an INSERT, UPDATE, or DELETE statement.
- Define : When a database value is assigned to a PL/SQL variable or a host variable by a SELECT or FETCH statement.
|
