Sql pseudocolumns, PL-SQL Programming

SQL Pseudocolumns

The PL/SQL recognizes the following SQL pseudocolumns, that returns the specific data items: LEVEL, NEXTVAL, CURRVAL, ROWID, & ROWNUM. The Pseudocolumns are not actual columns in a table but they behave as columns. For illustration, you can select values from a pseudocolumn. Though, you cannot insert into, update, or delete from a pseudocolumn. The pseudocolumns are also allowed in the SQL statements, but not in the procedural statements.

Posted Date: 10/4/2012 3:40:50 AM | Location : United States

Related Discussions:- Sql pseudocolumns, Assignment Help, Ask Question on Sql pseudocolumns, Get Answer, Expert's Help, Sql pseudocolumns Discussions

Write discussion on Sql pseudocolumns
Your posts are moderated
Related Questions
How Transactions Guard Your Database The transaction is a sequence of SQL data manipulation statements which does a logical unit of work. The Oracle treats the sequence of SQL

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

Parameter and Keyword Description: package_name: This construct identifies the package. AUTHID Clause: This determine whether all the packaged subprograms impleme

PITS Depressions in secondary cell wall is called pit. A pit present on the free cell wall surface without its partner is called Blind pit. It consists of 2 parts -

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

Using NOT NULL Besides assigning an initial value, the declarations can impose the NOT NULL constraint, as the example below shows: acct_id INTEGER(4) NOT NULL := 9999; You ca

Why Use Cursor Variables ? Primarily, you use the cursor variables to pass the query result sets between the PL/SQL stored subprograms and different clients. Neither PL/SQL nor

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

Order of Evaluation When you do not use the parentheses to specify the order of evaluation, the operator precedence determine the order. Now compare the expressions below: NOT

Quantification in SQL To quantify something, as the theory book has it, is to state its quantity, to say how many of it there are. For example, in Tutorial D the expression CO