Server side coding,ASP,ActiveVFP,CSP,Server-Side ANSI C, ColdFusion, CGI, Erlang with Linux, Yaws, Mnesia, Erlang, Grails (framework) Java, Perl, PHP, Python, e.g. Django (web framework), Real Studio Web Edition, Ruby, e.g. Ruby on Rails, Smalltalk e.g. Seaside, AIDA/Web, SSJS Server-Side JavaScript, e.g. Aptana Jaxer, Mozilla Rhino, WebDNA,Websphere ,.NET and .NET MVC Frameworks.
Wednesday, April 10, 2013
Create Sequence with Trigger [For Oracle]
First create a sequence then the trigger..
create sequence id_seq start with 1 increment by 1 nomaxvalue;
create trigger seq_trigger
before insert on table_name
for each row
begin
select id_seq.nextval into :new.id from dual;
end;
Labels:
oracle
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment