Tags: number of columns in a table01/02/10
How to get number of columns in a table? SELECT COUNT (column_name) FROM user_tab_columns WHERE table_name = '<tablename>'; more » Tag cloud«all_source table»,«alter data type of column having data»,«ascii for newline and tab»,«b-tree indexes»,«bitmap indexes»,«bulk collect»,cardinality,«column constraints»,«constraints on a table»,«control files»,cube,«ddl commands inside pl/sql proc»,«debugging a procedure»,«delete duplicates»,«describing a package body in sql plus»,«duplicate records»,«dynamic table creation in stored procedure»,«export saved database connections in toad»,«grants of an object»,«mutliline data in oracle»,«number of columns in a table»,«oracle aggregate functions»,«oracle data loader»,«oracle product version»,«oracle version»,«pragma autonomous_transaction»,rollup,«source code of a package»,«special characters in varchar2 column»,sql*loader,«toad database connections file»,user_tab_columns,user_tab_privs |
Hit Counter |
04:57:29 am, by 
XML Feeds