Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

'Noobish' Type Question

doofusboydoofusboy Member Posts: 256
I know how to get a single table description using:

desc my_table_name

But I need to get the descriptions for 200+ tables with names ending in _SP and really don't want to have to type them out individually.

Any suggestions?

Comments

  • infidelinfidel Member Posts: 2,900
    : I know how to get a single table description using:
    :
    : desc my_table_name
    :
    : But I need to get the descriptions for 200+ tables with names ending in _SP and really don't want to have to type them out individually.
    :
    : Any suggestions?
    :

    select * from user_tab_columns
    where table_name like '%_SP'
    order by table_name, column_id


    [size=5][italic][blue][RED]i[/RED]nfidel[/blue][/italic][/size]

Sign In or Register to comment.