Joined: Tue Feb 25, 2014 2:38 pm Posts: 1
|
So I have a view where I could not find any combination that uniquely identify row so there is no way i could put any thing in composite key tag or id tag in oracle I could see we could use some thing like: <property name="rowId" column="`ROWID`" insert="false" update="false"/> but I am using teradata so irrespective of that is there any way I could generate unique identifier without changing in the database, the main reason I cant use hilo algorithm because I only have read access to that view and nothing else.
Note I just need to fetch record using HQL not SQL and there would not be any chance of insert or update in my case
Any quick help would be highly appreciable :9
|
|