• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

simple question about script format

 
ben oliver
Ranch Hand
Posts: 375
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I need to create some oracle script and run it in oracle database I noticed some people use "/" at the end of the command. So which of the following two formats should I use ? Format a) or b) ?

a)

delete from XYZ;
delete from ABC;
insert into OPQ(c1,c2,c3) values(v1,v2,v3);
insert into OPQ(c1,c2,c3) values(v4,v5,v6);
...

b)

delete from XYZ
/

delete from ABC
/

insert into OPQ(c1,c2,c3) values(v1,v2,v3)
/

insert into OPQ(c1,c2,c3) values(v4,v5,v6)
/
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34870
369
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ben,
It's a matter of personal preference. Either is fine.
 
ben oliver
Ranch Hand
Posts: 375
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thank you
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic