tables are allocated in terms of segments and segments are collection of extents which in terms collection of blocks...all segments are part of tablespace which is physically a collection of one ...
buffer busy wait is the condition in which oracle server has to wait to access the segment header block for the table on which concurrent insert or delete operation r to be done.the segment header blo...
Lookup tables are like constraints which hold a value. The content in the lookup tables dosen't change often, hence refered as lookup (reference). Example : Countries table Countries are not add...
ed Di
Apr 18th, 2006
They're all lookup tables. After you load a table what's left to do but "Look up" the information at a later time. It's what database is all about; storing information for later retrieval.You pr...
exceptions can be handled in various ways in the stored procedures. Method (1) could be using EXCEPTION block in the procedure within which use WHEN <exceptionname> THEN. Method (2) could be dec...
Ans