[wufpack00]

When trying to run a simple select query using the Oracle keyword “rowid”, the value returned is always “<UNKNOWN>”.

select rowid, account_id from accounts

I am using MyEclipse 5.0 on Windows XP. I am connected to an Oracle 9.2 database using the oracle.jdbc.driver.OracleDriver class contained in ojdbc14_g.jar.

I use this same driver to connect to the database via SQLDeveloper and the correct value is always returned.

Can I view the ROWID in MyEclipse DB explorer?

[Haris Peco]

wufpack00 ,

Oracle return rowid type for rowid column and MyEclipse show only known types (character, number, date etc).
You can see your rowid column with this query :

select substr(rowid,1) rowid, account_id from accounts

Best
Peco

[Author]

Posts