This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes what are procedures in sql ? 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 "what are procedures in sql ?" Watch "what are procedures in sql ?" New topic

what are procedures in sql ?

Vinod Vinu
Ranch Hand

Joined: Aug 30, 2009
Posts: 217
hi, i'm newbie to java and sql. i want to know what are procedures ? If i say PL/SQL then does it mean these are procedures ?
Is procedures same as stored procedures or both are different ?
Is procedures varies from database to database we are using like a one in sql server is different for oracle ?

thanks in advance

Vinod Kumar Nair
"Any fool can write code that a computer can understan. Good programmers write code that humans can understand."
Agador Paloi
Ranch Hand

Joined: Jan 24, 2006
Posts: 118
Hi -
useally when programmers talk about procedures in applications they are talking about stored procedures kept in the database. They typically contain logic to manipulate and edit table data .

PL/SQL is a language developed by Oracle that you can write stored procedures, triggers, and functions in.

I know little about sql server , but I am pretty certain you cannot use PL/SQL to write stored procedures or triggers
on a sql server database.

This is a very brief explanation , hope it gives some perspective.

I agree. Here's the link:
subject: what are procedures in sql ?
Similar Threads
where to put SQL queries ?
discarding database roundtrips
MySQL - Returning Tables in Functions/SPs/Views
how to change the database?
is it a good solution ?