Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
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 Android Security Essentials Live Lessons this week in the Android 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: 374
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: 30138
    
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: 374
thank you
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: simple question about script format
 
Similar Threads
return value???
select with an "in" clause...
how to use ajax
Arrays.sort() and some arrays.
read a text file display values in drop down menu