<snip>Because their SQL queries always seem to need a target object to select from. i.e. "SELECT NEXTVAL.foo" isn't valid for Oracle 8/9.
It has been a long time since I've used Oracle, but shouldn't it be "select foo.nextval from dual"?
Yep, that's sounds better. It's been a couple of months since I was writing SQL in Oracle. Previous contract.
:)
Regards and best wishes,
Justin Clift
Regards, Mario Weilguni
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly