 Related Questions Cursor For Loop is a loop where oracle implicitly declares a loop variable, the loop index that of the same record type as the cursor's record. Latest Answer : The cursor FOR loop is a shortcut to process explicit cursors. Implicit open, fetch, exit, and close occur. The record is implicitly declared. ... A cursor variable is associated with different statements at run time, which can hold different values at run time. Static cursors can only be associated with one run time query. A cursor variable is reference Merge Join :Oracle performs a join between two sets of row data using the mergejoin algorithm. The inputs are two separate sets of row data. Output isthe results of the join. Oracle reads rows Latest Answer : Merge Joins Sort merge joins can be used to join rows from two independent sources. Hash joins generally perform better than sort merge joins. On the other hand, sort merge joins can perform better than hash joins if both of the following conditions exist:The ... Latest Answer : Hi,Nested Tables are collector objects (only attributes, i.e. no behaviour defined), that can be re-used in the same way as a class in java or c++ (without functions / procedures). In RDBMS, its mainly used for - 1. Reusability - Containment ... Read Answers (3) | Asked by : rajesh Latest Answer : Hi,what nachs has written is correct.Show error is use to find the compilation error not run time error.For runtime error of procedure we need to take help of exception Handling and that error may be user defined or system defined. but we can handle it ... Read Answers (2) | Asked by : mahesh shoriya How to delete set of records at a time where all the records having same values , except the Rowid differs? Latest Answer : nice reply sir ... On index why u need indexing ? where that is stroed and what u mean by schema object?for what purpose we are using view Latest Answer : This is how the index works in simple terms. When you add a row to a table, the rowid of that row plus a few other info is store in a separate area which is dedicated to keep it. Lets say you define a unique index. When you insert a valid row, the ... What is Local Index and Global Index in Partition Table?What is Prefix Index and Nonprefix Index in table?
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
