Operators on tables and rows, PL-SQL Programming

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. For example, when appearing in a suitable context, the expression

(SELECT * FROM COURSE WHERE CourseId = CID ('C1'))

Yields the row denoted by

CAST (ROW ('C1', 'Database') AS

ROW (CourseId CID, Title VARCHAR (100)))

A row subquery whose table operand is empty yields a row in which every field is NULL.

Field Extraction: For extracting a field from a row, using dot qualification.

Posted Date: 1/18/2013 7:04:32 AM | Location : United States







Related Discussions:- Operators on tables and rows, Assignment Help, Ask Question on Operators on tables and rows, Get Answer, Expert's Help, Operators on tables and rows Discussions

Write discussion on Operators on tables and rows
Your posts are moderated
Related Questions
Overview of control structures According to the structure theorem, any computer program can be written by using the basic control structures as shown in figure below. They can b

Example of DELETE - SQL As with UPDATE, a FOR PORTION OF clause can be specified if the target table has a defined period name, as illustrated in Example. Example: Deleting

The Package Specification The package specifications contain the public declarations. The scopes of these declarations are local to your database representation and global to t

RETURN Statement The RETURN statement instantly completes the execution of a subprogram and returns control to the caller. The Execution then resumes with the statement below t

Oracle 11 G new features associated with this release:- Enhanced ILM  - Information Lifecycle Management (ILM) has been around for the almost 10 years, but Oracle has made

Effects of NULL for union - SQL The treatment of NULL in invocations of EXCEPT is as for UNION. This is different from its treatment in those of NOT IN and quantified compari

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

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

Updating by insertion Syntax : INSERT INTO ENROLMENT VALUES (SID ('S4'), 'Devinder', CID ('C1'));

DBMS: The answer to this question is of course given in of the theory book. This book is concerned with SQL DBMSs and SQL databases in particular. Soon we will be looking a