Simple query with explicit Select list

******************* Query ****************************

Query:<SELECT empno, ename FROM emp>

********************* Parsed Query **********************

SELECT ( -1.empno), ( -1.ename),

FROM emp (-1),

 

********************* Validated Query **********************

SELECT ( 0.empno), ( 0.ename),

FROM SCHEMA.OAUSER.emp (0)( 0.empno, 0.ename, ::),

 

******************* End Validated Query ********************

 

********************* Query Result Specification **********************

Result Column:0 – Name:empno, XoType=4, Nullable=0, Precision = 10, Scale=0

Result Column:1 – Name:ename, XoType=12, Nullable=1, Precision = 32, Scale=0

 

********** Execution Plan for SIMPLE STMT *************

SELECT ( 0.empno), ( 0.ename),

FROM SCHEMA.OAUSER.emp (0)( 0.empno, 0.ename, ::),

 

-- Sub Query has no WHERE expression --

 

********** IP is being called to execute SubQuery on Table:<emp> with Search Column:<NULL>. hstmt:<0x6be880>

 

********************* Query Result Specification **********************

Result Column:0 – Name:empno, XoType=4, Nullable=0, Precision = 10, Scale=0

Result Column:1 – Name:ename, XoType=12, Nullable=1, Precision = 32, Scale=0