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."
posted 5 years ago
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.