What spfile/init.ora file parameter exists to force the CBO
to make the execution path of a given statement use an
index, even if the index scan may appear to be calculated as
more costly?
Can a Tablespace hold objects from different Schemes ?
Hi can anyone tell me where are the dumps found of OCA certification.. Also the materials to be studied for the preparation.
What happens to indexes if you drop a table?
which sql command we can use to get a print out from oracle?
What is a Shared SQL pool ?
how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance
What do you mean by merge in oracle and how can we merge two tables?
What is the meaning of recursive hints in oracle?
what is the syntax of update command?
a query to select maxmun 3 salaries of employee table
What is the difference between Delete, Truncate and Drop in Oracle?
What is a table in oracle?