Explain the use of table functions.



Explain the use of table functions...

Answer / Rohit Kumar Rai

Table functions are Oracle PL/SQL functions that return a result set. They can be used to encapsulate complex logic, reusable queries, or derived tables. Table functions can be used in FROM clauses, like regular tables, and can accept parameters. They can be declared as deterministic (always returning the same output for the same input) or non-deterministic (returning different outputs for the same input).

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle AllOther Interview Questions

Difference between negative and positive adjustments : oracle accounts receivable

1 Answers  


Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

1 Answers   HCL,


How would you determine who has added a row to a table?

1 Answers  


please send me oracle pl/sql exp resume. and also faqs...

0 Answers  


I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

1 Answers   jusco,


What command would you use to create a backup control file?

1 Answers  


How do you create a credit note against an invoice? : oracle accounts receivable

1 Answers  


Explain the use of table functions.

1 Answers  


When the procedures or packagess become invalidate

3 Answers   TCS,


what is the difference between oracle 81,91,11i

2 Answers   i2, Oracle,


what is domain in database and its benefits?

0 Answers  


Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?

4 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1803)
  • 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)