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 |
Difference between negative and positive adjustments : oracle accounts receivable
Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.
How would you determine who has added a row to a table?
please send me oracle pl/sql exp resume. and also faqs...
I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5
What command would you use to create a backup control file?
How do you create a credit note against an invoice? : oracle accounts receivable
Explain the use of table functions.
When the procedures or packagess become invalidate
what is the difference between oracle 81,91,11i
what is domain in database and its benefits?
Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?