Mario Weilguni wrote:
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.
<snip>
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

Reply via email to