Prepare Interview

Mock Exams

Make Homepage

Bookmark this page

Subscribe Email Address

Question: 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?
Answer: 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.
Is it helpful? Yes No

Most helpful rated by users:

©2025 WithoutBook