what is difference between procedure and function
Answer Posted / a.jyothsna
1) function can be executed using the sql command
(Ex: select functin_name(args)from dual;)
Procedure can be executed using sql+ command
(Ex: exec procedure_name(args))
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain raise_application_error.
What is dense_rank in sql?
Is primary key is clustered index?
What if we write return in procedure?
How to use distinct and count in sql query? Explain
What is 19 null in sql?
Can we call a function containing dml statements in a select query?
What is mutating error?
Inline the values in PL/SQL, what does it mean.?
Which sql statement is used to delete data from a database?
What is a nested table in word?
Can we use view in stored procedure?
What is constant in pl sql?
Is clustered index a primary key?
How do I delete a trigger?