Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

what are procedures in sql ?

 
Vinod Vinu
Ranch Hand
Posts: 217
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 118
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic