Re: Newbie Dynamic SQL Question

There is an article on dynamic selects
on my web-site. This demonstrates the
full technique; although as TK has already pointed out, your current requirement doesn't appear to need anything so extreme.

--

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

bravo6500_at_my-deja.com wrote in message <82k7tg$4bj$1_at_nnrp1.deja.com>...
>Thanks for the reply. I have come across the DESCRIBE_COLUMNS procedure
>in pl/sql 8 and am trying to use that to build the query. I can get
>information such as the name, type, etc of the columns in the specified
>table from this procedure. I am now trying to take that information and
>build my dynamic query with that information. When I use the procedure
>DEFINE_COLUMN, it appears that I have to create different versions of
>the output definition dependent on what the datatype of the column is.
>In reading the documentation, I am unaware as to what the procedure is
>looking for in its 'column' parameter. In the examples it seems that
>the 'column' parameter (e.g. DEFINE_COLUMN(c IN INTEGER, position IN
>INTEGER, column)) is just taking in the type of the column. However,
>the datatype of the column paramater varies. Do I just have to pass an
>example of the datatype in the 'column' parameter? I'm sorry if the
>question is muddled, I'm quite confused. Any help is greatly greatly
>appreciated.
>
>
>
Received on Wed Dec 08 1999 - 03:32:36 CST