Re: Dynamic SQL

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 Received on Sun Aug 01 1999 - 18:12:12 CDT