1.What is inline function in oracle and its purpose?
2.What is the equivalent operator for "different from
pattern" in oracle?
3. If you define a variable in oracle, how it will be
available? [a. Until database shut down b. Until table deleted
c. until session get expired]
Answers were Sorted based on User's Feedback
How many memory layers are in the oracle shared pool?
how to retrieve daily sal from emp table in oracle 10g
What are the predefined tablespaces in a database?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How to create a table index in oracle?
Can multiple columns be used in group by in oracle?
How are extents allocated to a segment?
How to use subqueries in the from clause in oracle?
How to change program global area (pga) in oracle?
What are oracle functions?
What happens to the data files if a tablespace is dropped?
What is the data pump import utility?