Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: JasonYeung
- Order by date
-
Stored Procedures and Triggers
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...- JasonYeung
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
Using rownum in Oracle 7
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?- JasonYeung
- Post #4
- Forum: Oracle: All versions
-
Using rownum in Oracle 7
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...- JasonYeung
- Thread
- Replies: 3
- Forum: Oracle: All versions
