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
Creating and Destroying Base Tables: Example shows an SQL command to create the base table counterpart of the ENROLMENT variable Example  Creating a base table. CREATE T

Assignment Source Not a Literal - Variable Syntax: SET SN = SID (SUBSTRING (SN.C FROM 1 FOR 1)||'5');

Semijoin and Composition - SQL For semijoin, the dyadic relational operator MATCHING, defined thus: r1 MATCHING r2, where r1 and r2 are relations such that r1 JOIN r2 is de

What Is a Collection The collection is an ordered group of elements, all of similar type (for e.g. the grades for a class of students). Each element has a unique subscript whic

Literals A literal is an explicit numeric, string, character, or Boolean value not represented by an identifier. Numeric literal 147 and the Boolean literal FALSE are some of

Assignment of Variable - Updating a Variable Syntax: SET SN = SID ('S2'); This can obviously be read as "set the variable SN to be equal in value to SID ( 'S2' )".

Procedures The procedure is a subprogram which can take parameters and be invoked. Normally, you can use a procedure to perform an action. The procedure has 2 sections: the spe

ROWID The ROWID returns the rowid (binary address) of a row in the database table. You can use the variables of the type UROWID to store rowids in a readable format. In the il

Need Azure CRM Web Application with two-factor authentication We presently have a CRM-like database stored on MS Azure that we presently access over an MS Access application. It

Selecting Objects: Suppose that you have run the SQL*Plus script below that creates object type Person and object table persons, and that you have settled the table: CREATE