Answers

Question and Answer:

  Home  SQL

⟩ How would the developer define this variable using referential datatypes?

A developer would like to use referential datatype declaration on a variable. The variable name is EMPLOYEE_LASTNAME, and the corresponding table and column is EMPLOYEE, and LNAME, respectively. How would the developer define this variable using referential datatypes?

1. Use employee.lname%type.

2. Use employee.lname%rowtype.

3. Look up datatype for EMPLOYEE column on LASTNAME table and use that.

4. Declare it to be type LONG.

 130 views

More Questions for you: