Hi ,

I have only beginner level knowledge in Oracle and very new to sybase.
I would need to tranlate the below oracle code snippet to Sybase.

Can some one tell me what exactly this piece of code mean and what its equivalent in sybase.

CREATE TRIGGER voip_id
BEFORE INSERT
ON voip_phones
FOR EACH ROW
Declare phoneId number;
BEGIN
select voip_phones_id.nextval into phoneId from dual;
:new.phone_id:=phoneId;
END;

Also found that there is no sequence concept in sybase.How do i go with the sequencing as i suppose the above code if for that only.

Any immediate help on this is highly appreciated.

Thank u,
Jeevana.

The equivalent on Sybase would be to use an identity column:

Hi,
In addition you can use identity_gap of your choice while creating the table. This will be the gap between last number assigned and the next number assigned when server restarts.