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
give the syntax of grant and revoke commands? : Sql dba
What is the main difference between sql and pl/sql?
Why commit is not used in triggers?
What does pragma mean?
Why do we create views in sql?
What is asqueryable?
Can you do multiple joins in sql?
Can you have more than one trigger on a table?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
Are stored procedures faster than queries?
What is mutating table error?
What is autocommit sql?
Is it possible to create startup or shutdown trigger for on-schema?
What is a join?
Where the sql database files are stored?