X hits on this document

Word document

What’s a PL/SQL table? Its purpose and Advantages? - page 7 / 8

41 views

0 shares

0 downloads

0 comments

7 / 8

Master Program', sc_time, FALSE, 1, 1020, 'VRP', '01-JAN-00', chr(0), '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');

28. What is pipelining?

29) How can the duplicate records be from the table?

 SQL> create table table_name2 as select distinct * from table_name1;  SQL> drop table_name1;  SQL> rename table_name2 to table_name1; 30) What is the significance of _all tables?

A) _all tables are multi-org tables which are associated with the company as a whole. Multiple Organizations is enabled in Oracle

Applications by partitioning some database tables by the Operating Unit. Other tables are shared across Operating Units (and therefore across set of books). Examples of Applications with partitioned tables are Oracle Payables, Oracle Purchasing, Oracle Receivables, Oracle Projects, Oracle Sales & Marketing etc. The name of each corresponding partitioned table is the view name appended by '_ALL'

31)What are mutating tables? And what is mutating error?

A) A mutating table is a table that is currently being modified by an UPDATE, DELETE, or INSERT statement, or it is a table that might need to be updated by the effects of a declarative DELETE CASCADE referential integrity constraint.

A mutating error occurs when a trigger which fires when updation/deletion/insertion is done on a  table A  performs insertion/updation/deletion on the same table A. This error results in an infinite loop which is termed as a mutating error.

32) What is difference between oracle 7 and oracle 8?

A) Oracle 7 is a simple RDBMS, where as Oracle 8 is ORDBMS i.e., RDBMS with Object Support.  

    The main add-ons in version 8 are…

Abstract Data types

Varrays

PL/SQL Tables

Document info
Document views41
Page views60
Page last viewedTue Dec 06 19:52:59 UTC 2016
Pages8
Paragraphs197
Words2521

Comments