Answer Posted / gourvendra singh
A procedure a subprogram used to perform a specific action
whereas a function is a subprogram which is used to compute
a value,in procedure we can use parameters(IN,OUT,IN OUT)
but in function we cant
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
What is %rowtype in pl sql?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
What is difference between rank () row_number () and dense_rank () in sql?
Why stored procedure is faster than query?
What are the two characteristics of a primary key?
How to write html code in pl sql?
what are the different type of normalization? : Sql dba
what is the difference between $message and $$message? : Sql dba
Describe types of sql statements?
Differentiate between % rowtype and type record.
What are the types of optimization?
Can a foreign key be null?
What can you do with pl sql?
Can you load data into multiple tables at once? : aql loader
how to calculate the difference between two dates? : Sql dba