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 main def between plsql/table and array?
what is shell?
What happens if the update subquery returns multiple rows?
How can return max date row A b c d e 1 2 1-mar-09 5 10 1 2 10-mar-09 5 10 Only using oracle predefined function. Not user defined. Output:-- A b c d e 1 2 10-mar-09 5 10
After using set unused can we enable the column again to use? Please give me some answers....
What is dictionary cache ?
What is the usage of analyze command in oracle?
How to specify default values in insert statement using oracle?
What are the ways tablespaces can be managed and how do they differ?
How to create index-by table in oracle?
How do I uninstall oracle client from windows?
what is dynamic SGA and static SGA