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
Can we enter data in a table in design view?
What is a dynamic query?
What are stuff and replace function?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
What are field types?
What is exception? What are the types of exceptions?
Can delete statement be rollbacked?
What are keys in sql?
Why stored procedures are faster than query?
How does one use sql*loader to load images, sound clips and documents? : aql loader
Mention what does plv msg allows you to do?
how to use regular expression in pattern match conditions? : Sql dba
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
What is normalization sql?
List the different type of joins?