How Would The Developer Define This Variable Using Referential Datatypes

How Would The Developer Define This Variable Using Referential Datatypes


  • 24 Feb, 2012

    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.

    Comments Received:
    Please give your suggestions and feedback:

2009-2016 downloadmela.com. All rights reserved.