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

Home -> Community -> Usenet -> c.d.o.misc -> Re: plsql programmatic alternative to desc <table_name>

Re: plsql programmatic alternative to desc <table_name>

From: Bricklen Anderson <bricklen_at_shaw.ca>
Date: Mon, 20 May 2002 17:52:09 GMT
Message-ID: <3CE936DB.87ADD9DD@shaw.ca>


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

Original text of this message

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