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

Is hadoop a nosql?

745


What is sorting in sql?

673


What is pl sql in dbms?

693


What is a clob in sql?

728


what are the security recommendations while using mysql? : Sql dba

768






Is sql injection illegal?

770


What are commit, rollback, and savepoint?

738


What is composite data type in pl sql?

766


What is the use of sqldataadapter?

704


What is the use of procedures?

716


How to convert comma separated string to array in pl/sql?

811


what is a constraint? Tell me about its various levels. : Sql dba

735


what is the difference between join and union? : Sql dba

719


what is 'mysqlcheck'? : Sql dba

746


What is recursive stored procedure?

812