Which cursor dynamically allows passing values to a cursor while opening another cursor?
Correct Answer: Implicit Cursor
Explanation:
Note: This Question is unanswered, help us to find answer for this one
Oracle PL/Sql 10g Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More Oracle PL/Sql 10g MCQ Questions
What happens during the execute phase with dynamic SQL for INSERT, UPDATE, and DELETE operations?
Examine the following package specification: CREATE OR REPLACE PACKAGE combine_all IS v_string VARCHAR2(100); PROCEDURE combine (p_num_val NUMBER); PROCEDURE combine (p_date_val DATE); PROCEDURE combine (p_char_val VARCHAR2, p_num_val NUMBER); END combine_all; / Which overloaded COMBINE procedure declaration can be added to this package specification?
Which part of a database trigger determines the number of times the trigger body executes?
Examine the following code: CREATE OR REPLACE TRIGGER secure_emp BEFORE LOGON ON employees BEGIN IF (TO_CHAR(SYSDATE, 'DY') IN ('SAT', 'SUN')) OR (TO_CHAR(SYSDATE, 'HH24:MI') NOT BETWEEN '08:00' AND '18:00') THEN RAISE_APPLICATION_ERROR (-20500, 'You may insert into the EMPLOYEES table only during business hours.'); END IF; END; / What type of trigger is it?
Which code is stored in the database when a procedure or function is created in SQL*PLUS?
Which table should be queried to determine when the procedure was last compiled?
If user defined error condition exists, Which of the following statements made a call to that exception?
Examine the following code: CREATE OR REPLACE TRIGGER update_emp AFTER UPDATE ON emp BEGIN INSERT INTO audit_table (who, dated) VALUES (USER, SYSDATE); END; / An UPDATE command is issued in the EMP table that results in changing 10 rows How many rows are inserted into the AUDIT_TABLE ?
Which precomplied word is called, which when encountered, immediately binds the numbered exception handler to a name?
Which two statements among the following, regarding oracle database 10g PL/SQL support for LOB migration, are true?