Re: Nextval Question
From: Craig Andrew Tollifson <despair_at_csd4.csd.uwm.edu>
Date: 5 Aug 1993 14:31:28 GMT
Message-ID: <23r5k0INNjg4_at_uwm.edu>
> Yes, you need a one-row table. No, you do not have to create it yourself:
> the table DUAL already exists. In version 6 & 7 it can be referenced as
> SELECT name.NEXTVAL FROM SYS.DUAL.
> --
Date: 5 Aug 1993 14:31:28 GMT
Message-ID: <23r5k0INNjg4_at_uwm.edu>
From article <930804113915_at_dlpc030.dlogics.com>, by dlm_at_dlogics.dlogics.com (Dave Mausner):
>> Do I have to create a special "one row" table and use that as the >> basis for the select? Are there other ways to access the pseudo- >> columns?
> Yes, you need a one-row table. No, you do not have to create it yourself:
> the table DUAL already exists. In version 6 & 7 it can be referenced as
> SELECT name.NEXTVAL FROM SYS.DUAL.
> --
Maybe I'm just wierd, but what's wrong with just doing:
SELECT obj_seq.NEXTVAL
FROM object
WHERE id = 1;
Eg. Knowning the existance of one record, restrict the qurry to that record. Is this bad? Why is it that people use a non-portalabl DUAL system table?
Just curious. Received on Thu Aug 05 1993 - 16:31:28 CEST