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 does pragma mean?
Are pl sql variables case sensitive?
Can we change the table name in sql?
what tools available for managing mysql server? : Sql dba
Name the different types of indexes in sql and define them.
Why do we use procedures?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
What is rank dense_rank and partition in sql?
How much ram can sql express use?
Can a foreign key have a different name?
Can a table contain multiple primary key’s?
Is pl sql still used?
Why use triggers in sql?
What is input buffer in sql*plus?
What does closing a cursor do?