Re: SQL help, Please???

Download an eval copy of 'toad' from the web and reverse engineer it. The time it takes will be well worth it. The product is available at http://www.quest.com.

Daniel A. Morgan

"Lynn C. Ormond" wrote:

> "decent" may be the operative word...
>
> I work for a third-party real estate software company.
> The Multi-Listing Service which has the data allows
> ONLY access to the views. I interface MLS data
> from all over the country in a variety of formats into
> our dBaseIV files. Everything from text based downloads
> to exported db file to ODBC like this on.
>
> If I wasn't already pretty far over the line, this would drive
> me nuts!
>
> --
>
> Lynn C. Ormond
> Lucero Research
> Reply to: Lynn_at_Lucero.com
>
> Daniel A. Morgan <dmorgan_at_exesolutions.com> wrote in message
> news:3AE7AFA4.BCCB215D_at_exesolutions.com...
> > Being asked to do something and not being given the resources is a recipe
 for
> > disaster.
> >
> > But are you sure you don't have access to the SQL from which the views
 were
> > constructed? I've no doubt a product like TOAD or OEM or SQL Navigator or
 DB
> > Artisan or reverse engineering into ERwin or Designer would give it to you
 in a
> > couple of seconds work.
> >
> > And have you asked for it? Any decent DBA could give it to you in a few
 seconds
> > too.
> >
> > Daniel A. Morgan
> >
> >
> >
> > "Lynn C. Ormond" wrote:
> >
> > > Thanks for your reply, Daniel.
> > >
> > > Unfortunately, I don't have access to the SQL or rights to create
 anything.
> > > I only have access to the views.
> > > The first file is real estate listings, the second is room records ( 0 -
 8 )
> > > of them for each record in the first file.
> > > I've also discovered a third file with a remarks field for the listings
 in
> > > the first file.
> > >
> > > Thanks for your help. You were defineately right about the speed
 problem.
> > > The connection timed out before
> > > I got a single record. Ain't life grand?
> > >
> > > --
> > >
> > > Lynn C. Ormond
> > > Lucero Research
> > > Reply to: Lynn_at_Lucero.com
> > > (520) 537-1300 x120
> > > Please include company name in message
> > >
> > > Daniel A. Morgan <dmorgan_at_exesolutions.com> wrote in message
> > > news:3AE668FF.426F93AD_at_exesolutions.com...
> > > > "Lynn C. Ormond" wrote:
> > > >
> > > > > I have 2 Oracle 7 views I need to combine with a select statement.
> > > > >
> > > > > The first has 100,000 + records with a unique key. The second has
 multiple
> > > > > records ( or none ) on the same key.
> > > > >
> > > > > I need left join(?) syntax which will allow me to get all of the
 multiple
> > > > > records in the second file attached to each of the unique records in
 the
> > > > > first file, always having the same total number of fields in each
 row of
 the
> > > > > result set.
> > > > >
> > > > > Any ideas?
> > > >
> > > > Yes.
> > > >
> > > > Forget doing what you say you want to do. Writing a view against two
 other
 views
> > > > is going to be so slow you will regret having ever had the idea.
> > > >
> > > > Instead sit down with the SQL used to create the other views and
 create a
 new
> > > > view that does what you want. And remember NVL() is your friend.
> > > >
> > > > Daniel A. Morgan
> > > >
> >
Received on Fri Apr 27 2001 - 01:14:29 CDT