what are procedures in sql ?

[Vinod Vinu]

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

[Agador Paloi]

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.


Agad