Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: What is logged on insert on identity columns?

Re: What is logged on insert on identity columns?

From: Bernard Dhooghe <dhoogheb_at_yahoo.com>
Date: 27 Jun 2006 05:15:47 -0700
Message-ID: <1151410547.209643.47320@u72g2000cwu.googlegroups.com>


Selected the wrong newsgroup, as already seen by this newsgroup readers!

Bernard Dhooghe
Mark C. Stock wrote:
> "Bernard Dhooghe" <dhoogheb_at_yahoo.com> wrote in message
> news:1151406511.199029.282520_at_i40g2000cwc.googlegroups.com...
> : Suppose a table defined as:
> :
> : CREATE TABLE "MYSCHEMA"."T1" (
> : "ID1" DECIMAL(8,0) NOT NULL GENERATED ALWAYS AS
> : IDENTITY (
> : START WITH +1
> : INCREMENT BY +1
> : MINVALUE +1
> : MAXVALUE +99999999
> : NO CYCLE
> : CACHE 20
> : NO ORDER ) )
> : DATA CAPTURE CHANGES
> : IN "USERSPACE1" ;
> :
> : db2 insert into myschema.t1 values (default).
> :
> : Is the real value inserted in the table logged and is it possible to
> : retrieve it with the log analyis API?
> :
> : Bernard Dhooghe
> :
>
> you might want to post this to the SQL Server newsgroup -- this doesn't look
> like an Oracle question
>
> ++ mcs
Received on Tue Jun 27 2006 - 07:15:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US