Re: Dynamic SQL

Will there be nulls in the values of attributes?

In article <37A4D44C.6315836E_at_t-online.de>,   Hans-Friedrich Pfeiffer <Pfeiffer.Hans-Friedrich_at_t-online.de> wrote:
> skeller wrote:
> >
> > I have following Problem:
> >
> > i have 2 to records to compare on the same Table.
> > key: number + date e.g. rec 1. 99999, 12.12.1999
> > rec 2. 99999,
12.12.2000
> > plus a number of attributes
> >
> > i would like to find out which attributes do not have the same
content.
> >
> > the result i'd like to get, is the name and content of the
attributes which
> > value is unequal.
> >
> > mainproblem: it should work on any Table (a variable Solution)
> > is it possible to get the value of a cursor.attr by its
index(column_id)??
> > (like in MS-VB)
> >
> > i have a solution already, but im looking for alternativ ones. e.g.
solved
> > only with functions and procedures (no OCI)
> >
> > many thanks
> >
> > please write also to stefan.keller_at_oiz.stzh.ch
>
> Hi,
>
> perhaps you could find a very beautiful and efficient way of saolving
> your problem by using
> OraPerl. I have the same problems and I solved it by OraPerl.
>
> Greetings,
>
> Hans Pfeiffer
>

--
Nandakumar
Systems Analyst
New York
(N.Kumar_at_rocketmail.com)

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Aug 02 1999 - 10:13:03 CDT