Solved

ORACLE 10g: VIEW - add unique identifier

Posted on 2015-01-28
3
291 Views
Last Modified: 2015-01-28
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
Comment
Question by:Maliki Hassani
3 Comments
 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 250 total points
ID: 40575801
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
 
LVL 73

Accepted Solution

by:
sdstuber earned 250 total points
ID: 40575849
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
 

Author Comment

by:Maliki Hassani
ID: 40575921
Got it, thanks!!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Via a live example, show how to take different types of Oracle backups using RMAN.

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now