Re: PLSQL Question

ORA-DBA wrote:
> Hi All,
>
> Some developers here have tried to come up with a procedure where they
> can pass a table name to a functon, and a SELECT statement will be
> returned with all the column names, thus eliminating the need for do a
> SELECT *........
>
> CURSOR tab_cols IS
> SELECT column_name
> FROM dba_tab_columns
> WHERE table_name = 'RECRUIT';
>
> BEGIN
> FOR v_tab_cols IN tab_cols LOOP
> IF v_sql IS NULL THEN
> v_sql := v_tab_cols.column_name;
> ELSE
> v_sql := v_sql || ', ' || v_tab_cols.column_name;
> END IF;
> END LOOP;
>
> Ok great, now they have the select statement, I'm not sure how it can
> be used in PLSQL. I mean, if you use it in a CURSOR or an EXECUTE
> IMMEDIATE, do you not need an INTO clause??
>
> Just looking for some ideas here.....
>
> Thanks in advance.

Send your developers for a class on built-in Oracle packages. They are, as Sybrand is saying, reinventing the wheel.

Demos of DBMS_METADATA.GET_DATA can be found in Morgan's Library at www.psoug.org.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org