Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
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

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: 30138

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:
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