Thisismarkantony.com

SELECT rcta.customer_trx_id, rcta.trx_number, rcta.trx_date, ac.customer_name, rctla.line_number inv_line_number, rctla.unit_selling_price inv_unit_selling_price, ooha.header_id, ooha.order_number, oola.line_number so_line_number, oola.line_id, oola.ordered_item, oola.ordered_quantity * oola.unit_selling_price so_amount FROM apps.ra_customer_trx_all rcta, apps.ra_customer_trx_lines_all rctla, apps.ar_customers ac, apps.oe_order_headers_all ooha, apps.oe_order_lines_all oola WHERE 1 = 1 AND rcta.customer_trx_id = rctla.customer_trx_id AND rcta.bill_to_customer_id = ac.customer_id AND ooha.header_id = oola.header_id AND rctla.interface_line_attribute6 = TO_CHAR(oola.line_id) AND rctla.interface_line_attribute1 = TO_CHAR(ooha.order_number) AND rcta.trx_number = nvl(:p_trx_number,rcta.trx_number) AND ooha.order_number = nvl(:p_order_number,ooha.order_number);

What are the new features added in ORACLE 11g? Following are the features added in ORACLE 11g for SQL and PL/SQL.   PL/SQL "CONTINUE" keyword   -   This will allow a "C-Like" continue in a loop, skipping an iteration to bypass any "else" Boolean conditions.  A nasty PL/SQL GOTO statement is no longer required to exit a Boolean within a loop. New "PIVOT" SQL clause -   The new "pivot" SQL clause will allow quick ROLLUP, similar to an MS-Excel pivot table, where you can  display multiple rows on one column   with SQL.  The PIVOT operator takes data in separate rows, aggregates it and converts it into columns. The UNPIVOT operator converts column-based data into separate rows. Using Compound Triggers:    In Oracle 11g, the concept of compound trigger was introduced. A compound trigger is a single trigger on a table that enables you to specify actions for each of four timing points: 1.      ...

What is Collection and What are different types of Collections in ORACLE? A collection is an ordered group of elements having the same data type. Each element is identified by a unique subscript that represents its position in the collection. PL/SQL provides three collection types: Variable-size array or Varray Index-by tables or Associative array Nested table Associative Array: Type t is Table of something index by pls_integer; Nested Table: Type t is table of something; VARRAY: Type t is varray(123) of something; PL/SQL - Varrays (Variable-Size Arrays) PL/SQL programming language provides a data structure called the VARRAY, which can store a fixed-size sequential collection of elements of the same type. A varray is used to store an ordered collection of data, but it is often more useful to think of an array as a collection of variables of the same type. A   Varray (variable-size array)  is an array whose number of elements can va...