What are the two parts of a procedure ?
Answer Posted / siddhartha
Declaration and executable
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
What is difference between sql function and stored procedure?
What is union and union all keyword in sql and what are their differences?
What is character functions?
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
how to install mysql? : Sql dba
When is a declare statement required?
How do I debug a stored procedure?
Can a foreign key be null?
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
how do you control the max size of a heap table? : Sql dba
what is a cursor? : Sql dba
what are date and time data types? : Sql dba
Is pl sql different from sql?
What is crud sql?
Can a varchar be a primary key?