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]
Answer Posted / rohit
c.until session get expired.
| Is This Answer Correct ? | 14 Yes | 1 No |
Post New Answer View All Answers
What are the different pseudo commands? Explain in general?
How do I call oracle stored procedures that take no parameters?
What privilege is needed for a user to delete rows from tables in another schema?
How do I spool to a csv formatted file using sqlplus?
Explain an exception and its types?
How to apply filtering criteria at group level in oracle?
How many types of table in Oracle?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
what is the difference between functional dependecy and multilevel dependency?
How to write a query with a left outer join in oracle?
Is there an oracle sql query that aggregates multiple rows into one row?
How many file formats are supported to export data?
What are the various constraints used in oracle?
 How to use an oracle sequence generator in a mapping?
What are the different types of record groups in oracle? Explain each of them