SQL query, oracle pl/sql

Question

I need to create a table in oracle DB that the index is increasing by 1 on insertion.
I have the code that does it, first create table, then create sequence and finally create the trigger.
when I type them, one by one, into the Oracle SQL Developer, paste the create table lines and commit, then the rest, one by one, it works, but if i father them all, and click run script, it does not create the sequence + trigger. only the table.

i separate the commands with /
any other thoughts ? or reference to working script ?

thanks !

You need to provide the script you're attempting to run if you want to get any meaningful assistance. — Allan
– Allan, Commented Nov 6, 2012 at 20:54

9000 · Accepted Answer · 2012-11-06 18:02:42Z

1

I suppose you don't need the / in a script. Just use ; to separate statements.

create table ... ;

create sequence ... ;

create trigger ... ;

I think this should be enough to run in SQL Developer and sqlplus.

answered Nov 6, 2012 at 18:02

9000

41k9 gold badges69 silver badges108 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ilansch Over a year ago

Thanks, on SQL Developer it worked fine without begin/end on every statement. just wrote the lines and separated with ;

Collectives™ on Stack Overflow

SQL query, oracle pl/sql

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related