Examine the Block given below: declare v_no number:=2; v_msg varchar2(20):="Goodbye"; begin case When v_no=1 then dbms_output.put_line("One!"); dbms_output.put_line("Another One!"); When v_no>1 then dbms_output.put_line(">1!"); dbms_output.put_line("Still>1!"); when v_msg="Goodbye" then dbms_output.put_line("Goodbye"); dbms_output.put_line("Adios"); else dbms_output.put_line("No Match"); end case; end; / What is the output of this block?

Which cursor allows passing values dynamically to a cursor?

Examine the code given below: CREATE OR REPLACE FUNCTION gen_email (first_name VARCHAR2, last_name VARCHAR2, id NUMBER) RETURN VARCHAR2 IS email_name VARCHAR2(19); BEGIN email_name := SUBSTR(first_name, 1, 1) || SUBSTR(last_name, 1, 7) ||[email protected] .; UPDATE employees SET email = email_name WHERE employee_id = id; RETURN email_name; END; Which of the following statements removes the function?

__________ is present in Oralce9i only.

Which statements is correct with regard to stored procedures?

Which procedure is called after a row has been fetched to transfer the value from the select list of the cursor to a local variable?

Which cursor allows passing values dynamically to a cursor?

Examine the Block given below: declare v_no number:=2; v_msg varchar2(20):='Goodbye'; begin case When v_no=1 then dbms_output.put_line('One!'); dbms_output.put_line('Another One!'); When v_no>1 then dbms_output.put_line('>1!'); dbms_output.put_line('Still>1!'); when v_msg='Goodbye' then dbms_output.put_line('Goodbye'); dbms_output.put_line('Adios'); else dbms_output.put_line('No Match'); end case; end; / What is the output of this block?

The OLD and NEW qualifiers can be used in Row level system trigger.

The Technique employed by the Oracle engine to protect table data when several people are accessing is called:

Which exception is raised when the data type or data size is invalid?