What are user defined stored procedures ?

Answer Posted / anbu

Stored procedures is like a simple PLSQL/instructions
programme which can perform desired operation to get the
exact output from the oracle server(if the DB is oracle).
The user defined stored proceture can be created by users
and they can use funtions,procedure and packages to get the
output from the database engine.
The next thing is they can call it at any part in the
main programme.

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is attribute indicator in pl sql?

519


What is mdf ldf and ndf?

556


What is a sql profiler?

586


hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

1521


how to fetch alternate records from a table? : Sql dba

588






what is 'mysqlshow'? : Sql dba

581


how many values can the set function of mysql take? : Sql dba

530


How do I install microsoft sql?

524


What is meaning of <> in sql?

581


what is auto increment? : Sql dba

565


how do you know the version of your mysql server? : Sql dba

503


How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

589


define sql delete statement ? : Sql dba

552


Explain the advantages and disadvantages of stored procedure?

641


What is a loop in sql?

562