How to define an explicit cursor in oracle?
In the oracle version 9.3.0.5.0, what does each number shows?
What is a sub query and what are the different types of subqueries?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
How do I recompile a procedure in oracle?
What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
What is the quickest way to fetch the data from a table?
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
What is execute immediate in oracle?
i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash
How do we switch from init.ora file to asp file?
What suggestions do you have to reduce the network traffic?
How do I use os authentication with weblogic jdriver for oracle and connection pools?