Describe the block structure of Pl/SQL.
Ans: Declaration, begin, exception, end.
What is an anonymous block?
Ans: unnamed Pl/SQL block.
What is Pl/SQL collection?
Pl/SQL table, varray, Pl/SQL array, etc.
How can you tell if an UPDATE updated no rows?
Ans: SQL%NOTFOUND.
How can you tell if a SELECT returned no rows.
Ans: NO_DATA_FOUND exception.
How do you run Native Dynamic SQL?
Ans: Execute immediate.
Ans: Declaration, begin, exception, end.
What is an anonymous block?
Ans: unnamed Pl/SQL block.
What is Pl/SQL collection?
Pl/SQL table, varray, Pl/SQL array, etc.
How can you tell if an UPDATE updated no rows?
Ans: SQL%NOTFOUND.
How can you tell if a SELECT returned no rows.
Ans: NO_DATA_FOUND exception.
How do you run Native Dynamic SQL?
Ans: Execute immediate.
No comments:
Post a Comment
Do you want to comment