Rowid - sql pseudocolumns, PL-SQL Programming

ROWID

The ROWID returns the rowid (binary address) of a row in the database table. You can use the variables of the type UROWID to store rowids in a readable format. In the illustration below, you declare a variable named row_id for that reason:

DECLARE

row_id UROWID;

Whenever you select or fetch a rowid into a UROWID variable, you can use the function ROWIDTOCHAR that converts the binary value to an 18-byte character string. Then, you may compare the UROWID variable to the ROWID pseudocolumn in the WHERE clause of an UPDATE or DELETE statement to recognize the latest row fetched from a cursor. 

Posted Date: 10/4/2012 3:42:56 AM | Location : United States







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

Write discussion on Rowid - sql pseudocolumns
Your posts are moderated
Related Questions
OUT Mode An OUT parameter returns values to the caller of a subprogram. Within the subprogram, an OUT parameter act like a variable. That means that you can use an OUT formal

Natural Join - SQL In the absence of NATURAL JOIN Example has to be replaced by something rather more longwinded, as shown in Example. Example: Joining IS_CALLED and IS_EN

Declaring Records Whenever you define a RECORD type, you may declare records of that type, as the illustration shows: DECLARE TYPE StockItem IS RECORD ( item_no INTEG

Parameter Modes   To define the behavior of formal parameters you use the parameter modes. The 3 parameter modes, IN, OUT, & IN OUT, can be used with any subprogram. Though, a

Accessing Attributes: You can refer to an attribute only by its name not by its position in the object type. To access or modify the value of an attribute, you can use the dot

Relational Operators and Logical Operators It prepares the ground for subsequent sections in which each specific relational operator is paired with its logical counterpart, su

query to Find the account numbers of all customers whose balance is more than 10,000 $

Scope and Visibility The References to an identifier are resolved according to its visibility and scope. The scope of an identifier is that area of a program unit (subprogram, b

a. Create a table odetails_new. It has all the attributes of odetails and an additional column called cost, whose values are the product of the quantity and price of the part bein

Collections:   The collection is an ordered group of elements, all of similar type (for illustration, the grades for a class of students). Each element has an exclusive subsc