It's not a secret anymore!
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
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 ?
It's not a secret anymore!