Only 44 hours left in the trailboss' kickstarter!

New rewards and stretch goals. CLICK HERE!



Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

simple question about script format  RSS feed

 
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
Sheriff
Posts: 36393
453
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
Boost this thread!