Difference between a query and strored procedure?
Answer Posted / r.s.chauhan
Sp gets stored at the server side where as Not necessary
for query(It can be from application or Clint(sql oem) etc)
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
who introduced sql?
Can you select everything, but 1 or 2 fields, without writer's cramp?
Which is better join or subquery?
What is linq to sql?
Name some usages of database trigger?
How does a self join work?
What is full form of rtm?
How can I speed up sql query?
What is sql and db2?
What is form and report?
Why do we need sharding?
What operating systems are supported by oracle sql developer?
How many sql databases can you have on one server?
What is union and union all keyword in sql?
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