File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Oracle/OAS and the fly likes Stroed Procedure&PL/SQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Stroed Procedure&PL/SQL" Watch "Stroed Procedure&PL/SQL" New topic

Stroed Procedure&PL/SQL

Mark Henryson
Ranch Hand

Joined: Jul 11, 2005
Posts: 200

I am using Oracle. I want to use Stored Procedures in Oracle. Whether PL/SQL and Stored Procedures are one and same. If I want to use either PL/SQL or Stored procedure, how to use it. Where to type the coding and save. Please any body know the sample screen shots of what to do & how to do the PL/SQL and Stored Procedure in Oracle. I have also searched the Oracle site, but I couldn't get the thing I wanted.

If the tutorial for how to use PL/SQL is available, it will be useful for the beginners like me.

Many thanks in advance.
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33108

PL/SQL is a language used for writing stored procedures. There are a lot of tutorials out there. I like this one.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1141

Of-course, when all else fails, you could always try reading the documentation:

Good Luck,
I agree. Here's the link:
subject: Stroed Procedure&PL/SQL
It's not a secret anymore!