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



1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "d..

Answer / rohit

c.until session get expired.

Is This Answer Correct ?    14 Yes 1 No

1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "d..

Answer / rasmi

3.until the table deleted.

Is This Answer Correct ?    4 Yes 12 No

Post New Answer

More Oracle General Interview Questions

How many memory layers are in the oracle shared pool?

0 Answers  


how to retrieve daily sal from emp table in oracle 10g

2 Answers   Infosys,


What are the predefined tablespaces in a database?

0 Answers  


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?

0 Answers  


How to create a table index in oracle?

0 Answers  






Can multiple columns be used in group by in oracle?

0 Answers  


How are extents allocated to a segment?

0 Answers  


How to use subqueries in the from clause in oracle?

0 Answers  


How to change program global area (pga) in oracle?

0 Answers  


What are oracle functions?

0 Answers  


What happens to the data files if a tablespace is dropped?

0 Answers  


What is the data pump import utility?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)