This week's book giveaway is in the Java 8 forum.
We're giving away four copies of Java 8 in Action and have Raoul-Gabriel Urma, Mario Fusco, and Alan Mycroft on-line!
See this thread 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 Java 8 in Action this week in the Java 8 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: 370
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: 29287
    
140

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: 370
thank you
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: simple question about script format
 
Similar Threads
return value???
how to use ajax
select with an "in" clause...
Arrays.sort() and some arrays.
read a text file display values in drop down menu