Is stored procedure faster than query?

920

What is latest version of sql?

989

What is offset in sql query?

1081

what is the difference between undefined value and null value? : Sql dba

1046

Why stored procedure is better than query?

890

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

3944

what is the functionality of the function htmlentities? : Sql dba

901

What are some predefined exceptions in pl/sql?

1088

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

996

What is Collation Sensitivity ? What are the various type ?

916

What is the difference between stored procedure and view?

975

what are the differences between char and varchar? : Sql dba

1015

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1005

What is rowtype?

960

What is keys and its types?

1029