Patrick Connors wrote:
> Choice #5 happened to me recently: "Back-end tools can't deal with output
> from pl/sql", which happened to me this spring. I wrote a pl/sql solution
> in half a day, then spent two weeks redoing it in SQL*Plus. Grrr!
>
> - Patrick Connors
>
> "Alan" <alanshein_at_erols.com> wrote in message news:<ah6qs3$qpn80$1_at_ID-114862.news.dfncis.de>...
> > Dan,
> >
> > You left out choice #4: "I don't know how to use PL/SQL because I didn't do
> > my homework, and now I have this really important assignment due."
> >
> > "Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
> > news:3D36DBF8.3003E08E_at_exesolutions.com...
> > > Alex Kizub wrote:
> > >
> > > > I want to improve perfomance of my application but database structure
> > > > is not good.
> > > >
> > > > Here is problemm:
> > > >
> > > > One SQL is:
> > > > select A,B from T1;
> > > >
> > > > for each row I have to create another query
> > > > select C from X1,X2 where X1.A=A and X2.B=B and X1.D=X2.D;
> > > >
> > > > X1.A can be absent, X2.B can be absent and relation X1.D=X2.D can be
> > > > absent.
> > > >
> > > > So I can have something or nothing.
> > > >
> > > > So right now I have rowset like this
> > > >
> > > > A B Query
> > C
> > >
> > > --------------------------------------------------------------------------
> > -----------------------
> > > > A1 B1 select C from X1,X2 where X1.A='A1' and
> > X2.B='B1' and
> > > > X1.D=X2.D C1
> > > > A2 B2 select C from X1,X2 where X1.A='A2' and
> > X2.B='B2' and
> > > > X1.D=X2.D nothing
> > > > A3 B3 select C from X1,X2 where X1.A='A3' and
> > X2.B='B3' and
> > > > X1.D=X2.D C3
> > > >
> > > > Can I create query which returns for me
> > > >
> > > > A B C
> > > > ------------------------------
> > > > A1 B1 C1
> > > > A2 B2 null
> > > > A3 B3 C3
> > > >
> > > > in one select statement?
> > > > And I can't use PL/SQL in our database :(
> > > >
> > > > Thanks is advance.
> > > >
> > > > Alex Kizub.
> > >
> > > Go to http://tahiti.oracle.com and search on the following criteria:
> > >
> > > 1. In-line views
> > > 2. Sub-queries
> > >
> > > I apologize in advance if my assumption is incorrect. But when you say
> > "can't use PL/SQL in our database" I read it
> > > as being one of the following:
> > >
> > > 1. The teacher of your class wants you to do this with SQL
> > > 2. The teacher of your class wants you to do this with SQL
> > > 3. The teacher of your class wants you to do this with SQL
> > >
> > > ... and I don't think it is proper for us to do your homework for you.
> > >
> > > Daniel Morgan
> > >
Received on Fri Jul 19 2002 - 10:47:31 CDT
