Re: Database vs bestanden?

Article View: be.comp.programming

Article #2934

Back to be.comp.programming Previous Next

#2934

From: Theo
Date: Fri, 05 Mar 2004 18:18

63 lines
2981 bytes

"Sjoerd A. Schreuder" <sa_schreuder@wanadoo.nl> wrote in message
news:4047cc7d$0$2414$4a441750@news.euronet.nl...
> >
> >>[Over ProgreSQL]
> >>
> >>>alter table cities alter IDcity set default
nextval('cities_idcity_seq');
> >
> >>Hoe vaak ik al niet gewenst heb dat dit in Oracle mogelijk zou zijn...
> >
> > Dat is toch met 1 klein triggertje gepiept?
> > Kleine moeite, lijkt me.
>
> Dacht ik ook. Totdat bleek dat je vanuit een 'before insert' trigger
> geen nextval op sequences mag aanroepen. :-(

Nou, dan weet ik niet welke Oracle versie je gebruikt, maar volgens mij
heeft dat altijd gemogen. In ieder geval vanaf 7.3.
Voorbeeld (Oracle 9.2.0.1.0):

SQL> create table test(id number(10) primary key, veld1 varchar2(10))
  2  /

Tabel is aangemaakt.

SQL> create sequence test_seq
  2  /

Reeks is aangemaakt.

SQL> create or replace trigger test_bir
  2  before insert
  3  on test
  4  for each row
  5  begin
  6    select test_seq.nextval into :new.id from dual;
  7  end;
  8  /

Trigger is aangemaakt.

SQL> insert into test (veld1) values ('Test')
  2  /

1 rij is aangemaakt.

SQL> insert into test (veld1) values ('2e test')
  2  /

1 rij is aangemaakt.

SQL> select * from test
  2  /

        ID VELD1
---------- ----------
         1 Test
         2 2e test

SQL>

-- 
Theo

Technical Details

Message-ID: <c2agjo$29bl$1@nl-news.euro.net>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!fu-berlin.de!news2.telebyte.nl!newshub1.home.nl!home.nl!news.cambrium.nl!news.cambrium.nl!news2.euro.net!nl-news.euro.net!not-for-mail

References:

<_et1c.22284$SL3.1605761@phobos.telenet-ops.be> <o7pc40515um0omqo4hnb2aqc2bb62d8028@4ax.com> <40467a4c$0$565$e4fe514c@news.xs4all.nl> <sjsd401e9mfd1r1hlo06rosdpg94gh3cv4@4ax.com> <c2722m.1fg.1@news.isolution.nl> <slrnc4e0tg.1ml.usenet@bender.home.hensema.net> <slrnc4e23g.ch4.robert@home.allyourbass.org> <slrnc4e3cb.1ml.usenet@bender.home.hensema.net> <slrnc4e4eb.ch4.robert@home.allyourbass.org> <slrnc4e6f3.2a2.usenet@bender.home.hensema.net> <40474818.6EFC2982@wanadoo.nl> <c2824f$1fji$1@nl-news.euro.net> <4047cc7d$0$2414$4a441750@news.euronet.nl>

Show Full Headers

Complete Article Headers

X-Google-Language: DUTCH,ASCII-7-bit
X-Google-Thread: 107324,7a8fc8eaa24f5371
X-Google-Attributes: gid107324,public
X-Google-Thread: fcea4,7a8fc8eaa24f5371
X-Google-Attributes: gidfcea4,public
X-Google-ArrivalTime: 2004-03-05 10:23:52 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!fu-berlin.de!news2.telebyte.nl!newshub1.home.nl!home.nl!news.cambrium.nl!news.cambrium.nl!news2.euro.net!nl-news.euro.net!not-for-mail
From: "Theo" <theoa_nl@hotmail.com>
Newsgroups: be.comp.programming,nl.comp.programmeren
Subject: Re: Database vs bestanden?
Date: Fri, 5 Mar 2004 19:18:00 +0100
Organization: EuroNet Internet
Lines: 65
Message-ID: <c2agjo$29bl$1@nl-news.euro.net>
References: <_et1c.22284$SL3.1605761@phobos.telenet-ops.be> <o7pc40515um0omqo4hnb2aqc2bb62d8028@4ax.com> <40467a4c$0$565$e4fe514c@news.xs4all.nl> <sjsd401e9mfd1r1hlo06rosdpg94gh3cv4@4ax.com> <c2722m.1fg.1@news.isolution.nl> <slrnc4e0tg.1ml.usenet@bender.home.hensema.net> <slrnc4e23g.ch4.robert@home.allyourbass.org> <slrnc4e3cb.1ml.usenet@bender.home.hensema.net> <slrnc4e4eb.ch4.robert@home.allyourbass.org> <slrnc4e6f3.2a2.usenet@bender.home.hensema.net> <40474818.6EFC2982@wanadoo.nl> <c2824f$1fji$1@nl-news.euro.net> <4047cc7d$0$2414$4a441750@news.euronet.nl>
NNTP-Posting-Host: theoa.xs4all.nl
X-Trace: nl-news.euro.net 1078511032 75125 213.84.150.170 (5 Mar 2004 18:23:52 GMT)
X-Complaints-To: usenet@nl-news.euro.net
NNTP-Posting-Date: Fri, 5 Mar 2004 18:23:52 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165

Reply to Parent Message