Upgrade. 9.2.0.5 to 10.1.0.4
- From: "Spears, Brian" <BSpears@xxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 13 Jan 2006 15:40:22 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Sandeep Dubey
Sent: Friday, January 13, 2006 2:59 PM
To: Gleisson Henrique; oracle-l@xxxxxxxxxxxxx
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 <gleissonbr@xxxxxxxxx> 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 <dubey.sandeep@xxxxxxxxx> 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
> > --
> > //www.freelists.org/webpage/oracle-l
> >
> >
> >
>
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
