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 program declarations are correct for a stored program unit?

Examine the code given below: Declare cursor emps is select Empno,ename,sal,deptno,job from emp; begin for rec in emps loop open emps; dbms_output.put_line(rec.empno||rec.ename||rec.sal||rec.deptno||rec.job); end loop; end; / What is wrong in above declaration?

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?

Which of the following Triggers is fired each time a row in the table is affected by the triggering statement?

Which type of argument passes a value from a procedure to the calling environment?