• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 355
  • Last Modified:

ORACLE 10g: VIEW - add unique identifier

Hello Experts,

I was wonder is it possible to create a unique_id to my Oracle view?  I know you can do this for a table, but my join duplicates each record making duplicate unique_id's of the table.

Thanks
0
Maliki Hassani
Asked:
Maliki Hassani
2 Solutions
 
slightwv (䄆 Netminder) Commented:
You would need to add some identified to the underlying view query that uniquely identifies each row.

If the join is resulting in duplicates, maybe the join is wrong?
0
 
sdstuberCommented:
you can rownum to the view's query

if that doesn't do it, can you post your queries as well as what you'd like the results to look like? (sample data, not a written description)
0
 
Maliki HassaniAuthor Commented:
Got it, thanks!!
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now