On Sep 26, 3:09 pm, Michael Moore <michaeljmo...@gmail.com> wrote: > select count(*) from all_tab_cols where table_name = 'TX_VENDOR'; > > use your table name instead of tx_vendor > > Mike > > > > On Sun, Sep 25, 2011 at 9:09 PM, PUNEET <puneet.wadhwa...@gmail.com> wrote: > > Is there any querry to calculate the number of columns in a table??? > > > Thanks > > > Puneet > > > -- > > You received this message because you are subscribed to the Google > > Groups "Oracle PL/SQL" group. > > To post to this group, send email to Oracle-PLSQL@googlegroups.com > > To unsubscribe from this group, send email to > > oracle-plsql-unsubscr...@googlegroups.com > > For more options, visit this group at > >http://groups.google.com/group/Oracle-PLSQL?hl=en- Hide quoted text - > > - Show quoted text -
select table_name, count(*) num_cols from all_tab_columns where table_name = 'MGMT$DELTA_INIT' group by table_name; Supply your own table name to the query. David Fitzjarrell -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
