Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Convert the following for-cursor into: open, fetch, close one: DECLARE Cursor c1 is select table_name from user_tables; BEGIN FOR tables IN c1 LOOP DBMS_OUT.PUT_LINE(tables.table_name); END
- Convert the following for-cursor into: open, fetch, close one:
DECLARE
Cursor c1 is select table_name from user_tables;
BEGIN
FOR tables IN c1 LOOP
DBMS_OUT.PUT_LINE(tables.table_name);
END LOOP;
END;
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started