Do foreign keys improve performance?

1022

what are the join types in tsql? : Transact sql

1064

What are the operators used in select statements?

1058

What is difference between group by and partition by?

1059

When you have to use a default "rollback to" savepoint of plvlog?

1191

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1748

Can a foreign key be null?

1090

What does closing a cursor do?

1319

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

4014

how can we destroy the session, how can we unset the variable of a session? : Sql dba

997

What is user in sql?

1018

Does sql full backup truncate logs?

1014

What is sql injection vulnerability?

944

What is partition in sql query?

998

What are commit, rollback, and savepoint?

992