What is a Procedure ?
Answers were Sorted based on User's Feedback
Answer / guest
Procedure is a stored database object and can be called
when is required. Procedure can have three parameters
IN,INOUT,OUT .IN is default parameter in a Procedure.
Ideally Procedure doesn't return a value but if required
same can be achieve throug OUT Parameter.
Syntex is :
CREATE OR REPLACE PROCEDURE <<Procedure Name>>
(<<PARAMETERLIST DATATYPE>>
IS
BEGIN
<<Code Here>>;
END <<Procedure Name>>;
In procedure arguments datatype size is not required.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / raju.r
It's set of pre-compiled set of SQL statements. no need for
compile the procedure again and again..
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / shivashanker
Procedure is named pl/sql block or sub-program used to manipulated the data within the databse.OR It is used to perform some action within the databse
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a trigger word?
What is primary key and foreign key?
What do you mean by query optimization?
Name the tables where characteristics of Package, procedure and functions are stored ?
Does sql support programming?
How bulk collect improves performance?
what does the t-sql command ident_incr does? : Transact sql
What is a cursor ? Why Cursor is required ?
What is scalar function?
what is sql profiler? : Sql dba
What is magic table?
Is sql port 1433 encrypted?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)