This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes Oracle/OAS and the fly likes simple question about script format Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "simple question about script format" Watch "simple question about script format" New topic
Author

simple question about script format

ben oliver
Ranch Hand

Joined: Mar 28, 2006
Posts: 375
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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30356
    
150

Ben,
It's a matter of personal preference. Either is fine.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
ben oliver
Ranch Hand

Joined: Mar 28, 2006
Posts: 375
thank you
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: simple question about script format