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
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

Declaring a Cursor The Forward references are not allowed in the PL/SQL. Therefore, you must declare a cursor before referencing it in other statements. Whenever you declare a

heap sort program in pl/sql

Name Resolution   During the compilation, the PL/SQL compiler relates identifiers like the name of a variable with an address or memory location, actual value, or datatype. Th

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

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

Overriding Default Locking By default, the Oracle locks the data structures for you automatically. Though, you can request exact data locks on rows or tables when it is to you

Aggregate Operators SQL Supports all of the aggregate operators mentioned in the theory book and many more besides. The syntax, however, involves an unusual trick that SQL cal

Closing a Cursor Variable The CLOSE statement disables the cursor variable. After that, the related result set is undefined. The syntax for the same is as shown below: CLOS

Example of Using Aggregation on Nested Tables Example: How many students sat each exam WITH C_ER AS (SELECT CourseId, CAST (TABLE (SELECT DISTINCT StudentId, Mark FROM EXAM