Answer Posted / 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 |
Post New Answer View All Answers
What are the different datatypes available in PL/SQL?
How to process query result in pl/sql?
Can sql function call stored procedure?
What is trigger in pl sql?
Explain the difference between drop and truncate commands in sql?
How to run pl sql program in mysql?
What are the ways on commenting in a pl/sql code?
What is trigger and types?
Can we change the table name in sql?
How many sql core licenses do I need?
What is sql used for?
What are stored procedures in mysql?
What is the difference between partition and index?
Why do we use procedures?
explain the difference between bool, tinyint and bit. : Sql dba