For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Hello ,
Can we avoid in-live view in Oracle 12C ? I remember reading somewhere but not able to recall where.
select * from (select * from mytable)where row_num=1;
select * from (
select * from mytable
)
where row_num=1;