Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

ORACLE 10g: VIEW - add unique identifier

Posted on 2015-01-28
3
Medium Priority
?
353 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 78

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 1000 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 74

Accepted Solution

by:
sdstuber earned 1000 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

885 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