Example of unwrap operator - sql, PL-SQL Programming

Example of UNWRAP Operator - SQL

Example here shows how unwrapping can be done in longhand in SQL.

Example: Unwrapping in SQL

Letting CONTACT_INFO_WRAPPED denote the result of Example:

SELECT Name,

Address.House as House,

Address.Street as Street,

Address.City as City,

Address.Zip as Zip

FROM CONTACT_INFO_WRAPPED

Address.House in this example is equivalent to Tutorial D's House FROM Address. The use of a dot here is consistent with its use with range variables-recall that a range variable also denotes a row, "ranging" over the rows of a table.

Posted Date: 1/18/2013 7:00:52 AM | Location : United States







Related Discussions:- Example of unwrap operator - sql, Assignment Help, Ask Question on Example of unwrap operator - sql, Get Answer, Expert's Help, Example of unwrap operator - sql Discussions

Write discussion on Example of unwrap operator - sql
Your posts are moderated
Related Questions
Operator Precedence The operations within an expression are completed in a particular order depending on their precedence (priority). The table shows the default order of the op

PITS Depressions in secondary cell wall is called pit. A pit present on the free cell wall surface without its partner is called Blind pit. It consists of 2 parts -

Enrolment was split - SQL Example shows how relvars IS_CALLED and IS_ENROLLED_ON can be derived from the original ENROLMENT relvar, using projection in the initial assignment

Fetching from a Cursor Variable The FETCH statement retrieve rows one at a time from the product set of a multi-row query. The syntax for the same is as shown: FETCH {curso

Manipulating Collections Within PL/SQL, the collections add procedural power and flexibility. The biggest benefit is that your program can compute subscripts to process the spec

Some Varray Examples In SQL Plus, assume that you define an object type Project, as described below: SQL> CREATE TYPE Project AS OBJECT ( 2 project_no NUMBER(2), 3 title VARCHA

Mutual Recursion The Subprograms are mutually recursive if they directly or indirectly call each other. In the illustration below, the Boolean functions odd & even, that dete

Error Handling The PL/SQL makes it easy to detect and process the predefined and user-defined error conditions known as exceptions. Whenever an error occurs, an exception is ra

Using the FORALL Statement The keyword FORALL instruct the PL/SQL engine to bulk-bind input collections before sending them all to the SQL engine. Though the FORALL statement

Use the MASCOT tables CREDITRS, PORDS and PAYMENTS to write SQL queries to solve the following business problems. These tables / data are available to you via the USQ Oracle server