wood burning stoves 2.0*
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 Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "simple question about script format" Watch "simple question about script format" New topic

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) ?


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);


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

Joined: May 26, 2003
Posts: 30068

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
how to use ajax
Arrays.sort() and some arrays.
return value???
read a text file display values in drop down menu
select with an "in" clause...