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 dml and ddl?
describe mysql connection using mysql binary. : Sql dba
How to add new employee details in an employee_details table with the following details
What is the usage of distinct keyword?
Can you selectively load only those records that you need? : aql loader
How do you modify a table in sql?
Which data type is a composite type?
What are the possible values that can be stored in a boolean data field?
Can instead of triggers be used to fire once for each statement on a view?
What are the different tcl commands in sql?
How do you optimize a stored procedure in sql?
what are all the common sql function? : Sql dba
What is the difference between rollback and rollback to statements?
What is latest version of sql?
How to download oracle sql developer?