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 is a data dictionary and how can it be created?
How to use fetch statement in a loop?
How to upsert (update or insert into a table)?
How can we find out the duplicate values in an oracle table?
Explain the different normalization forms?
How to define a specific record type?
What is an oracle database table?
please explain.. DB architecture ...
Is primary key indexed by default in oracle?
Explain how you would restore a database using RMAN to Point in Time?
What are data pump export and import modes?
List out the types of joins.
What are the attributes of the cursor?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
How does Oracle guarantee data integrity of data changes?