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 are the most important characteristics of pl/sql?
What are the different ddl commands in sql?
Are stored procedures compiled?
what is an alias command? : Sql dba
What is the difference between the conventional and direct path loader? : aql loader
What is the syntax and use of the coalesce function?
What is primary key in db?
what is datawarehouse? : Sql dba
Does view contain data?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
what is the stuff function and how does it differ from the replace function? : Sql dba
What is the current version of postgresql?
What is set serveroutput on in pl sql?
what is the difference between clustered and non clustered index in sql? : Sql dba
write an sql query to find names of employee start with 'a'? : Sql dba