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
Use the RETURNING Clause Frequently, the application requires information about the row affected by a SQL operation, for illustration, to produce a report or take a subsequent

Operators on Tables and Rows Row Extraction TUPLE FROM r, SQL has row subqueries. These are just like scalar subqueries except that they may specify more than one column.

Character Types The Character types allow you to store alphanumeric data, represent words and text, and manipulate the character strings. CHAR You use the CHAR dataty

TTITLE and BTITLE are commands in Pl-SQL to control report headings and footers. This Ttitle & Btitle are mainly used on creating SQL*PLUS report. Ttitle is used for toptitle headi

Stored Subprograms Normally, tools (like Oracle Forms) which incorporate the PL/SQL engine can store subprograms locally for later, strictly local execution. Though, to become

Using DELETE This process has three forms. The DELETE removes all elements from the collection. DELETE(n) removes the nth element from the nested table. When n is null, then D

What are the rates for help in writing PL/SQL procedures and functions?

Controlling Autonomous Transactions The first SQL statement in an autonomous routine starts a transaction. Whenever one transaction ends, the next SQL statement starts the oth

Cursor Variables Similar to a cursor, cursor variable points to the current row in the result set of a multi-row query. But, dissimilar a cursor, a cursor variable can be opene

Keyword & Parameter Description: boolean_expression: This is an expression which yields the Boolean value that is TRUE, FALSE, & NULL. character_expression: This