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
Adding Table Constraints ALTER TABLE ENROLMENT ADD CONSTRAINT NameNotNull CHECK (Name IS NOT NULL) ; ALTER TABLE ENROLMENT ADD CONSTRAINT PK_StudentId_CourseId PRIM

Explicit Cursors The set of rows returned by the query can include zero, one, or multiple rows, depending on how many rows meet your search criteria. Whenever a query returns

Using LOCK TABLE You use the LOCK TABLE statement to lock the whole database tables in the specified lock mode so that you can share or deny the access to them. For illustrati

EXIT-WHEN The EXIT-WHEN statement permits a loop to complete conditionally. Whenever the EXIT statement is encountered, the condition in the WHEN clause is computed. When the co

%NOTFOUND The %NOTFOUND is logical, opposite of the %FOUND. The %NOTFOUND yields FALSE if the last fetch returned a row, or TRUE when the final fetch failed to return a row. I

Nested Tables versus Index-by Tables The Index-by tables and nested tables are just similar. For e.g.  They have similar structure and their individual elements are accessed in

Recursive Subprograms The recursive subprogram is the one that calls itself. Think of a recursive call as a call to a few other subprograms that does the similar task as your

Authorize and fetch data from Instagram Project Description: Incorporate Instagram feed on mobile site platform: c#, ms sql, jquerymobile, jquery Web admin Author

Effect of Anonymous Columns Now, recall that a VALUES expression denotes a table with undefined column names. If an initial value is to be specified when a base table is creat

Cursor Variables As Parameters You can declare the cursor variables as the formal parameters of the functions and procedures. In the illustration below, you define the REF CUR