| General Information |
Too often keywords are used that have different meanings in different products or definitions that are contrary to general usage. As I locate misunderstandings I will try to link from various Library pages to this page and provide short, succinct, definitions and examples.
If you have something you don't understand and would like added to this page, sorry but it must be Oracle database related not about your parents, children, spouse, or the sorry state of humanity ... send them to me and I'll try to put something together and post it here. |
| |
| Heap Table |
A table containing an unsorted"heap" of data. All default tables, in all major commercial relational database products, are heap table. Tables that sort data, for example Index Organized Tables, are not heap tables. |
| Scalar Subquery |
A subquery that returns exactly one value value or NULL. For example: SELECT dummy FROM dual; |
|
