Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> dynamic SQL

dynamic SQL

From: skeller <stefan.keller_at_oiz.stzh.ch>
Date: Thu, 29 Jul 1999 18:25:33 +0200
Message-ID: <7npvc9$t1m$1@pollux.ip-plus.net>


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 Received on Thu Jul 29 1999 - 11:25:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US