Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: plsql programmatic alternative to desc <table_name>
take a look at user_tab_columns and user_tables.
Do you mean assigning column names their positional value through the forms? If so, what benefit is there to doing that? Saves typing? Or do you want to be able to (re)create indexes on the fly (?? again, if so, why?).
Mark wrote:
>
> I want forms constructed dynamically from table defenitions. Is there a
> programmatic alternative to SQL*Plus desc command.
> For starters I want field lengths to constrain form input.
>
> If possible I would also like to find out column names so I can dynamically
> create the entire form given a table name. Being able to index the columns
> by number is very useful in this area (is it possible?).
>
> Many thanks,
> Mark
Received on Mon May 20 2002 - 12:52:09 CDT