Example :
select * from (
select * from oe_order_headers_all
order by creation_date desc
)
where rownum = 1;
select * from (
select * from oe_order_headers_all
order by creation_date desc
)
where rownum = 1;
Sunday 29 January 2017
Subscribe to:
Posts (Atom)
-
I faced some issues when I query the below table data is not fetching in my query: SELECT * FROM hr_operating_units SELECT * FROM MTL_CAT...
-
For this error need to Check RTF template there should be tags are not correctly and if you are developing new RTF latest version. Just se... -
select * from all_objects where object_name like 'GME%BATCH%' and object_type = 'TABLE' --------------------------------...