function can return value ,procedure also return value through
out parameter then what is the difference?
Answer Posted / veena
We can use function in select statement but we can't use
procedure in select statement.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can we insert delete data in view?
What are the commands used in sql?
Explain table and field in sql?
Can we use commit inside a trigger?
What is audit logout in sql profiler?
What is sql character function?
What is a trigger word?
What is oracle sql developer?
what is datawarehouse? : Sql dba
how to get help information from the server? : Sql dba
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
How to add a column ‘salary’ to a table employee_details?
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
Can instead of triggers be used to fire once for each statement on a view?
What is group function in sql?