How to i display the following info from dba_tab_columns
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to i display the following info from dba_tab_columns

  1. #1
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586

    How to i display the following info from dba_tab_columns

    Question:
    Display a count of tables that have columns greater then 50 and columns less then 50 for a particular schema?

    thanks

    Ps: I tried the following but I get an error:
    SQL> select table_name from dba_tab_columns where owner = 'PRISM' and column_name > 50;

    ERROR at line 1:
    ORA-01722: invalid number
    "High Salaries = Happiness = Project Success."

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Code:
    select table_name from dba_tab_columns 
    where owner = 'PRISM'
    having count(*) > 50 group by table_name
    Last edited by davey23uk; 06-14-2004 at 07:19 PM.

  3. #3
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586

    Cool

    Thanks Davey23Uk. You are awesome!!!You Rock!!!
    "High Salaries = Happiness = Project Success."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width