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
This is a Customer Management project. Customer data is presented in a text file. The program will load this text data into its DB columns. The data mapping is user definable. User

Components of an Object Type: An object type encapsulates the operations and data. Therefore, you can declare the methods and attributes in an object type specification, but no

Data Types in SQL SQL's concept does not differ significantly from that defined in the theory book, apart from that business concerning NULL. However, the theory book equates

BETWEEN and NOT BETWEEN Operator in SQL Example: Restricting exam marks to between 0 and 100 CREATE ASSERTION Marks_between_0_and_100 CHECK (NOT EXISTS (SELECT * FROM

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

Other monadic - SQL In 2VL there are just 4 (2 2 ) monadic operators, of which negation is really the only "useful" one. When a third truth value is introduced we have 27 (3 3

Cursor Variables:   To execute the multi-row query, the Oracle opens an unnamed work region that stores the processing information. You can use an explicit cursor that names

Using INNER JOIN INNER JOIN is used to retrieve the data from all tables listed based on a condition of equality listed after keyword ON. If the condition is not meet, rows ar

Authorize and fetch data from Instagram Project Description: Incorporate Instagram feed on mobile site platform: c#, ms sql, jquerymobile, jquery Web admin Author

What are the rates for help in writing PL/SQL procedures and functions?