Re: Dynamic SQL

You might look at my website for the article (under PL/SQL) on dynamic select statements. It wasn't intended as a serious idea for implementation, but it might work for what you want to do.

The critical section, I think, is the use of the dbms_sql.describe function, which will allow you to find the names and types of a query of the form 'select * from table'.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

skeller wrote in message <7npv63$sql$1_at_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)
Received on Sat Jul 31 1999 - 16:47:10 CDT