Display a count of tables that have columns greater then 50 and columns less then 50 for a particular schema?
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