![]() Related Questions Self join-Its a join foreign key of a table references the same table. Outer Join--Its a join condition used where One can query all the rows of one of the tables in the join condition even though they Latest Answer : Please let me know various joins available and description for every joinRegards,sireesha ... TABLESVIEWSINDEXESSYNONYMSSEQUENCESTABLESPACES etc Latest Answer : In Oracle DB Objects are Table View Indexes Sequences Used to generate primary key values Synonym ... A view is stored procedure based on one or more tables, it’s a virtual table. Latest Answer : View
View is logical table based on one are more table join and named as viewname
View is not stored in database View is used to perform complex query, View Object,
View support, LOB, varray, Nested Tables Should have CREATE ... Outer Join--Its a join condition used where you can query all the rows of one of the tables in the join condition even though they don’t satisfy the join condition. Latest Answer : outer join is that type of jon which retrives the matach & alson unmatached recores also from the tables ... Oracle does not allow a user to specifically locate tables, since that is a part of the function of the RDBMS. However, for the purpose of increasing performance, oracle allows a developer to create a Latest Answer : Clustering is a method of storing tables that are intimately related and often joined together into the same area on disk. For example, instead of the BOOKSHELF table being in one section of the disk and the BOOKSHELF_AUTHOR table being somewhere else, ... Oracle uses work area to execute SQL statements and store processing information PL/SQL construct called a cursor lets you name a work area and access its stored information A cursor is a mechanism used Latest Answer : Oracle ueses the private area for excute SQL statements and store processing information. The private area is called as CONTEXT AREACURSOR: cursor is a handle or pointer to the context area. ... PL/SQL declares a cursor implicitly for all SQL data manipulation statements, including quries that return only one row. However,queries that return more than one row you must declare an explicit cursor Latest Answer : explicit ... %ROWCOUNT%NOTFOUND%FOUND%ISOPEN Latest Answer : %ROWTYPE - returns number of the rows which are fetched/updated/deleted%ISOPEN - returns true if the cursor is open%FOUND - returns true if the cursor fetched any row%NOTFOUND-returns true if the cursor does ... 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. ... NO DATA FOUND is an exception raised only for the SELECT....INTO statements when the where clause of the querydoes not match any rows. When the where clause of the explicit cursor does not match any rows Latest Answer : NO DATA FOUND: Is an exception which is raised when no rows are retrieved from the database in a SELECT statement, then PL/SQL raises the exception NO_DATA_FOUND.%NOTFOUND: is a Boolean attribute that evaluates to TRUE if the most recent SQL statement ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||