logs archiveIRC Archive / Freenode / #oracle / 2010 / July / 5 / 1
Hi someone can help in this procedure? http://pastebin.com/9TfVaX8n
So simple, but dont work, why?
PLS-00428 :S
now its ok!
i am planning for oca certifications ...can anyone recommend good starting point/tutorials/books to study from?
I have two columns t1.col1 and t2.col1. I want to join on their values, but there can be several matches in both tables. Meaning i get e.g. two matches in each table in one scenario. I can see that I get n*m rows returned to tell me this, where n = number of matches in t1.col1 and m = number of matches in t2.col1. Ie. there is a lot of redundant information.
Is there any way i can query such that I get either n or m rows based on which is biggest which has the information stored
select distinct to remove dupes if all the fields are the same?
or if you want the count in each table for that value you could use a bit of analyics i guess
something like count(*) over (partition by t1.col1) as m, count(*) over (partition by t2.col1) as n
and in an outer query you can do something like where m<n
I dont want to remove duplicates
I basically need all rows which match from t1 as well as rows that match from t2, I just dont need the cartesian product number of rows
to tell me the relation
I can see that is useful if you dont just load in everything yourself
but I do, for each join match
So if there are 2 matches in t1 and t2 i get four rows, basically n*m
As it is now
I want to ge ttwo rows in this example
as all information can be stored in two rows -> one row for the two first matches, and one for the two other matches
hi folks
I'm doing a recovery right now. I am getting a 0600 on a corrupt block of an index. Is there a way to drop this index and continue the recovery?
it's an Index in SYSAUX talespace
next »