Currently I have a table containing a trigger that rollsback an attempted insert if there is already a row containing the same item. (ie. if there is already a row with the same captain, the transaction gets reversed.) The following is my trigger:
CREATE TRIGGER trigger_teamstable ON...
If it is the case that I have to set the dialect to LEVEL1, is there a work around to this problem? IE. Is there another SQL statement that selects the first 5 rows of a table without using the rownum variable?
I am developing a website using Oracle Rdb SQL V7.0-4 as the database. I am trying to use a SQL statement that queries the first 5 rows using the rownum variable. The SQL statement I used is:
SELECT
ASM_HC_READ,
ASM_CO_READ,
ASM_NOX_READ,
IDLE_HC_READ,
IDLE_CO_READ,
ASM_HC_RES...
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.