Pages

How to use SQL ROWID?

ROWID is a hexadecimal string that is unique for each row in a table.

Example: Get ROWID and name of students.

SELECT ROWID, name FROM students


Output: 

ROWID         NAME
AAADa6AAEAAAAFFAAA John
AAADa6AAEAAAAFHAAA Kamil
AAADa6AAEAAAAFHAAB David
AAADa6AAEAAAAFHAAC Fad
AAADa6AAEAAAAFHAAD Sam
AAADa6AAEAAAAFHAAE Dawn
AAADa6AAEAAAAFHAAF Emre
AAADa6AAEAAAAFHAAG Arif
AAADa6AAEAAAAFHAAH Sad
AAADa6AAEAAAAFIAAA Zeynal

No comments:

Post a Comment