Question

create or replace procedure "test" as a_string varchar(1000 char) := NULL; b_string varchar(2000 char) := NULL; fullname VARCHAR(200 char); edate VARCHAR(200 char); SG VARCHAR(1000 char); cursor c_username is select userid, username from knta_users where username like 'D%'; Begin open c_username; for i in c_username loop a_string := ''; a_string := a_string || ' ' ||i.userid; select full_name into fullname from knta_users where username = i.username ; a_string := a_string || ' ' ||fullname; DBMS_OUTPUT.PUT_LINE( ' ' ||a_string ); END LOOP; close c_username; end "test"; Examine the procedure and choose what will happen when this procedure is executed:

technology databases

This procedure will not compile successfully.
This procedure will print the Userid and fullname of users whose username starts with ‘D’;
This procedure will print just the fullname of the users.
This procedure will print just the userid of the users.

Answer 1

Correct Option: B

Find more quizzes: