-
Subqueries vs Joins in SQL
What is the difference between Subqueries and Joins? Which is better and Why? Give an example of each.
-
-
How to disable a trigger for a particular table ?
Suppose if i have 8 triggers declared for a table..how to disable a single trigger from a table...i don't want to disable all triggers for a table. I know we can disable all triggers by using "alter table disable all triggers;". just i want to know how to disable single trigger from a table.
-
what is the use of nocopy parameter in oracle procedure
Hi, What is nocopy parameter in oracle procedure. what is the use of it. In which situation,we can use the nocopy parameter.Thanks,Saravanan.P
-
-
What is OCI. What are its uses?
Oracle Call Interface is a method of accesing database from a 3GL program. Uses--No precompiler is required,PL/SQL blocks are executed like other DML statements. The OCI library provides-functions to parse SQL statemets-bind input variables-bind output variables-execute statements-fetch the results
-
How you will avoid your query from using indexes?
SELECT * FROM empWhere emp_no+' '=12345;i.e you have to concatenate the column name with space within codes in the where condition.SELECT /*+ FULL(a) */ ename, emp_no from empwhere emp_no=1234;i.e using HINTS