Get columns number sql

Get number of columns sql

SELECT TABLE_NAME , count(COLUMN_NAME)
FROM information_schema.columns
GROUP BY TABLE_NAME;

-- Oracle (depending on schema grants):
SELECT count(*) FROM USER_TAB_COLS WHERE TABLE_NAME = 'my_table';
SELECT count(*) FROM ALL_TAB_COLS WHERE TABLE_NAME = 'my_table';
SELECT count(*) FROM DBA_TAB_COLS WHERE TABLE_NAME = 'my_table';

Get columns number sql

//With JAVA

String quer="SELECT * FROM sample2 where 1=2";

Statement st=con.createStatement();
ResultSet rs=st.executeQuery(quer);
ResultSetMetaData rsmd = rs.getMetaData();
int NumOfCol=0;
NumOfCol=rsmd.getColumnCount();
System.out.println("Query Executed!! No of Colm="+NumOfCol);

Source: stackoverflow.com

Similar codes

18 votes199 views1 answer
Taking string input in java
Java
0 vote183 views1 answer
Java swing get frame size
Java
0 vote169 views1 answer
How to know what a valid name for a variable is in java
Java
1 vote214 views2 answers
Variables en java
Java
0 vote205 views1 answer
Cypher query having multiple values
Java
0 vote179 views1 answer
N/mm2
Java
0 vote176 views1 answer
At android.os.StrictMode$AndroidBlockGuardPolicy.onNetwork(StrictMode.java:1565)
Java
0 vote186 views3 answers
Data provider using junit
Java
9 votes181 views3 answers
Synchronized block java
Java
0 vote179 views1 answer
How to set landscape in android studio
Java