SQL adaptation guide For Oracle Database 9.2, 10.x, 11.x, 12x / Data manipulation |
With Informix®, you must use the system table with a condition on the table id:
SELECT user FROM systables WHERE tabid=1
Oracle provides the DUAL table to generate one row only.
SELECT user FROM DUAL
Check the BDL sources for "FROM systables WHERE tabid=1" and use dynamic SQL to resolve this problem.