What is a stored procedure ?

Answer Posted / rajesh

stored procedure is a named pl/sql block which accept some
parameter and performs some action....and its a one time
compilation....

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is coalesce sql?

518


Is oracel sql developer written in java?

648


Can a trigger call a stored procedure?

536


Mention what plvcmt and plvrb does in pl/sql?

643


How to fetch alternate records from a table?

684






How do I find sql profiler?

520


Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

619


What is procedure explain with program?

552


Mention what are different methods to trace the pl/sql code?

560


Can we use rowid as primary key?

546


What is cte?

574


What is sql entity?

532


explain normalization concept? : Sql dba

592


explain about mysql and its features. : Sql dba

554


Can we write ddl statements in functions?

569