Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> dynamic SQL
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.2000plus 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 Received on Thu Jul 29 1999 - 11:25:33 CDT