what is difference between procedure and function,
procedure and trigger?
Answer Posted / ganesh ganjre
Diff. b/w proc. & trigger..
procedure can be called from trigger but trigger can't be
called from procedure.
Trigger(Implicitly)
Procedure(Explicitly)
| Is This Answer Correct ? | 14 Yes | 1 No |
Post New Answer View All Answers
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 do sql triggers work?
What is sqlservr exe?
How is data stored in sql?
What is the difference between a primary key and a unique key?
define sql insert statement ? : Sql dba
How many clustered indexes can you have?
Is sql between inclusive?
What is rename command in sql?
What is example of database?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
how many tables will create when we create table, what are they? : Sql dba
What is assignment operator in pl sql?
what is the difference between char_length and length? : Sql dba
What is a primary key sql?