possible it isn't the best...
make a subquery in your SELECT:
SELECT ...
, ( SELECT 'DUPLICATE'
FROM DUAL
UNION
SELECT 'ORIGINAL'
FROM DUAL ) xy
...
it duplicates your rows
put it last in your ORDER BY, with DESC
make a field with xy source
Hi!
We have a software:
Oracle DB, Java GUI, Oracle Reports. We must to migrate the database to DB2.
Some manuals said, it is possible to connect to DB2 from Oracle SQL*Plus (I have version 8.0.6.0.0) and from Oracle Report Builder.(6.0.8.11.3) (User must install OCA (Oracle Open Client...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.