Example of table literal - sql, PL-SQL Programming

Example of Table Literal - SQL

Example: A Table Literal (correct version)

VALUES

('S1', 'C1', 'Anne'),

('S1', 'C2', 'Anne'),

('S2', 'C1', 'Boris'),

('S3', 'C3', 'Cindy'),

('S4', 'C1', 'Devinder')

Now, the question arises, what is the (table) type of the table shown in Example? For that matter, what is the (row) type of ('S1', 'C1', and 'Anne')? In particular, what are the field names of those three fields, which would become column names for the containing table? The short answer is that they are determined by the context in which the expression appears. Because the components are distinguished anyway by ordinal position, the field names sometimes serve little or no purpose. In fact several fields are permitted to acquire the same name. Also, sometimes the context does not provide any names at all, in which case, according to the standard, each field is assigned a unique but unpredictable name.

Examples arising as we go along will make this issue a little clearer. I shall use the term anonymous column to refer to a column whose name is unpredictable and therefore effectively undefined. Note carefully that if the word ROW is omitted and the row consists of a single field, then the parentheses can also be omitted. Thus, VALUES 'S1' denotes a table consisting of a single column and a single row, the SQL counterpart of RELATION { TUPLE { StudentId 'S1' } } (though the SQL counterpart has nothing corresponding to the attribute name).

Posted Date: 1/18/2013 2:14:25 AM | Location : United States







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

Write discussion on Example of table literal - sql
Your posts are moderated
Related Questions
Calling Constructors: The Calls to a constructor are allowed wherever the function calls are allowed. Similarly to the functions, a constructor is called as a section of an ex

Authorisations - Privileges As relational theory is silent on the issue of authorisation, it offers nothing with which SQL's vast edifice in support of what it calls privilege

#quesWrite a cursor to open an employee database and fetch the employee record whose age is greater than 45.tion..

CLOSE Statement The CLOSE statement allows the resources held by a cursor variable or open cursor to be reused. No more rows can be fetched from the cursor variable or closed

I want to implement heap sort algorithm in pl sql please share the source code for guidance

Advantages of Wrapping   The PL/SQL Wrapper convert the PL/SQL source code into a transitional form of the object code. By hiding the application internals, the Wrapper secure

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

Need to change mysql query to PDO Project Description: I want someone to convert me 1 .php file that includes some sql/mysql stuff to PDO is a very small file. Skills requ

Special cases of projection This section describes the identity projection, r {ALL BUT}, and the projection on no attributes, r { }, which yields TABLE_DUM when r is empty, ot

Identifiers You use identifiers to name the PL/SQL program items and units that include constants, variables, cursors, exceptions, cursor variables, subprograms, and packages.