Upgrade. 9.2.0.5 to 10.1.0.4

Hi,

 Looking for the best method of how to upgrade from 9.2.0.5 to 10.1.0.4.

I know the export import method but wondering if there is a simple step to upgrade (.sql ?) from 9 to 10.1.0.3 and then run the catpatch.sql for the 10.1.0.4.

Brian

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sandeep Dubey Sent: Friday, January 13, 2006 2:59 PM
To: Gleisson Henrique; oracle-l_at_freelists.org Subject: Re: SQL question

> I am sorry I can't be more helpful. I don't really see this as
> problem, to me it's more of an exemple of bad data.

I am not sure if it is a bad data model. It's battle of normalization - denormalization.

I have a table Items. It's child is item_parts. Item can be made up of 1 or may parts. So it is right to store in a table like item_parts. okay?

Now if business asks give me the item that EXACTLY matches these parts - no more no less, its a valid question too.

Regards

Sandeep

On 1/13/06, Gleisson Henrique wrote:
> If you query like this:
>
> select *
> from foo
> where part = 'A'
>
> ITEM PA
> ---------- --
> 1 A
> 2 A
> 3 A
>
> The result set is correct because it matches exactly your condition.
> However you can do the following:
>
> select *
> from foo
> where part = 'A'
> and rownum < 2
>
>
> ITEM PA
> ---------- --
> 1 A
>
> But that's assuming the column item is in order, you won't be able to
> get item 2 if wanted to.
>
> I am sorry I can't be more helpful. I don't really see this as
> problem, to me it's more of an exemple of bad data.
>
> hope it helps tough
>
> gleisson henrique
>
>
> On 1/13/06, Sandeep Dubey wrote:
> >
> > Hi,
> >
> > I am having tough time writing a select query. I won't blame it on
> > Friday afternoon, it is really difficult to me.
> >
> > Here is an example:
> >
> > create table foo ( item number, part varchar2(2));
> >
> > insert into foo values(1,'A');
> > insert into foo values(2,'A');
> > insert into foo values(2,'B');
> > insert into foo values(3,'A');
> > insert into foo values(3,'B');
> > insert into foo values(3,'C');
> >
> > I want to query for item that matches exact parts given in the
query.
> > i.e.if I query for part A, I should get 1 ( no 2 and 3)
> >
> > If I pass A and B , I should get only 2 (no 3) If I query for A, B
> > and C, I should get only 3.
> >
> > Query can have n number of parts, It should return only that item
> > that has exact match to parts, no less no more.
> >
> > Thanks
> >
> >
> > Sandeep
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>
>

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l