Scribd
Upload
25 views2 pages

What Is Explicit and Implicit Cursor and Examples? Ans

Uploaded by

redro

This document contains 10 questions about PL/SQL including its architecture, advantages, restrictions on cursor variables, size limits of PL/SQL blocks, explicit and implicit cursors with examples, attributes of implicit cursors, mutating table errors, when declare statements are required, how to check if a cursor is open, and how to write a PL/SQL program to calculate age from a date of birth. The questions are not answered, only stated.

Copyright:

© All Rights Reserved
Download as DOC, PDF, TXT or read online from Scribd
Download as doc, pdf, or txt

What Is Explicit and Implicit Cursor and Examples? Ans

Uploaded by

redro
25 views2 pages
This document contains 10 questions about PL/SQL including its architecture, advantages, restrictions on cursor variables, size limits of PL/SQL blocks, explicit and implicit cursors with examples, attributes of implicit cursors, mutating table errors, when declare statements are required, how to check if a cursor is open, and how to write a PL/SQL program to calculate age from a date of birth. The questions are not answered, only stated.

Original Description:

PL SQL TEST2

Original Title

PL_SQL_Paper1 B

Copyright

© © All Rights Reserved

Available Formats

DOC, PDF, TXT or read online from Scribd

Did you find this document useful?

Is this content inappropriate?

This document contains 10 questions about PL/SQL including its architecture, advantages, restrictions on cursor variables, size limits of PL/SQL blocks, explicit and implicit cursors with examples, attributes of implicit cursors, mutating table errors, when declare statements are required, how to check if a cursor is open, and how to write a PL/SQL program to calculate age from a date of birth. The questions are not answered, only stated.

Copyright:

© All Rights Reserved
Download as DOC, PDF, TXT or read online from Scribd
Download as doc, pdf, or txt
25 views2 pages

What Is Explicit and Implicit Cursor and Examples? Ans

Uploaded by

redro
This document contains 10 questions about PL/SQL including its architecture, advantages, restrictions on cursor variables, size limits of PL/SQL blocks, explicit and implicit cursors with examples, attributes of implicit cursors, mutating table errors, when declare statements are required, how to check if a cursor is open, and how to write a PL/SQL program to calculate age from a date of birth. The questions are not answered, only stated.

Copyright:

© All Rights Reserved
Download as DOC, PDF, TXT or read online from Scribd
Download as doc, pdf, or txt
You are on page 1/ 2

PL/SQL Papaer 1A:

Name : Date:
------------------------------------------------------------------------------------------------------------

Q1. PL/SQL Architecture?

Ans:

Q2. Advantages of PL/SQL?

Ans:

Q3. What are the restrictions of using cursor variables?

Ans:

Q4. What can be a size of a pl/sql block? Is there any limit?

Ans:

Q5. What is explicit and implicit cursor and examples?

Ans:

Q6. Explain Attributes Of a Implicit Cursor?

Ans:

Q7. What is a mutating table error?

Ans:

Q8. When is a declare statement required?

Ans:
Q9. If a cursor is open, how can we find in a PL SQL Block?

Ans:

Q10. Write a Pl/sql program to find the age from data of birth, in the format of
YY.MM.DD (ex: 19yeares, 2 Months, 10 Days)

You might also like