• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 375
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

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