Why use stored procedures?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

Can primary key be changed?

0 Answers  


How to add Foreign key in a table after the creation of the table?

5 Answers   Satyam,


please explain database architecture..

1 Answers   Infosys,


Enlist some predefined exceptions?

0 Answers  


what is top in tsql? : Transact sql

0 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

1 Answers   IAS,


How to add a column ‘salary’ to a table employee_details?

0 Answers  


What is an alias command?

0 Answers  


What packages(if any) has oracle provided for use by developers?

1 Answers  


difference between cursor and procedure in a package

3 Answers   PCS,


What is a table partition?

0 Answers  


What is difference between hql and native sql?

0 Answers  


Categories