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
What Are Cursor Variables  ? The Cursor variables are like C or Pascal pointers that hold the memory location (address) of some item rather of the item itself. Therefore, decl

LOOP Statements The LOOP statements execute a series of statements at multiple times. The loops enclose the series of statements that is to be repeated. The PL/SQL provides typ

Semidifference via NOT IN and a subquery SELECT StudentId FROM IS_CALLED WHERE Name = 'Devinder' AND StudentId NOT IN (SELECT StudentId FROM IS_ENROLLED_ON WHER

Majority of Differences among 9i, 10G, 11G :- These are some combine feature which has differences among others. Automatic Workload Repository (AWR) Drop database' s

Using DEFAULT You can use the keyword DEFAULT rather than that of the assignment operator to initialize the variables. For e.g. the declaration blood_type CHAR := ’O’; it can b

Many of the reports generated from the system calculate the total dollars in purchases for a shopper. Complete the following steps to create a function named TOT_PURCH_SF that acce

Implicit Rollbacks Before execute the INSERT, UPDATE, or DELETE statement, the Oracle marks an implicit savepoint . When the statement fails, the Oracle rolls back to the save

In Packages The Forward declarations also group logically related subprograms in the package. The subprogram specifications go in the package specification, & the subprogram b

Manipulating Individual Elements Faraway you have manipulated an entire collection. Within the SQL, to manipulate the individual elements of the collection, and then use the ope

Fetching Across Commits The FOR UPDATE clauses acquire exclusive all row locks. All rows are locked when you open the cursor, and when you commit your transaction they are unl