Home » RDBMS Server » Server Administration » Sequence...
Sequence... [message #375158] Wed, 01 August 2001 09:30 Go to next message
Otávio
Messages: 6
Registered: April 2001
Junior Member
Hello there,

How Can I define the default value of field of a table like sequence.nextval?
Do I need set the value by a Trigger (Before Insert)??

Thanx.

Report message to a moderator

Re: Sequence... [message #375178 is a reply to message #375158] Thu, 02 August 2001 14:15 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Yes, you will need a before row insert trigger to do this

if :new.pk_column is null then
select seq_name.nextval into :new.pk_column;
end if;

Report message to a moderator

Re: Sequence... [message #375179 is a reply to message #375178] Thu, 02 August 2001 14:17 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Sorry, that should be:

select seq_name.nextval into :new.pk_column from dual;

Report message to a moderator

Previous Topic: insert of a pk value number generated from sequence fails
Next Topic: Special characters in SQL insert & select stmt.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 05 11:23:10 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.