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
what is analyze command ? what kind of statistics does it generate?
what is view?
Explain the difference between sap and oracle?
24. Display the order number for all orders whose average item cost is greater than the overall average item cost across all orders.
What a SELECT FOR UPDATE cursor represent.?
Can you create a synonym without having a table?
How to create a new view in oracle?
What is SAVE POINT ?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
How do we display rows from the table without duplicates?
Explain a private synonyms?
What are the uses of Rollback Segment ?