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

0 vote169 views2 answers
Spigot item break
Java
0 vote167 views1 answer
Gif to blob java
Java
0 vote167 views1 answer
Jmeter get var
Java
1 vote179 views6 answers
Kotlin to java converter
Java
2 votes236 views2 answers
Get year month day from date string java
Java
2 votes186 views1 answer
Android studio start another activity
Java
0 vote183 views1 answer
Print 1 to 10 using thread in java
Java
1 vote186 views1 answer
How to take schreen shot using java
Java
2 votes190 views1 answer
Hibernate select count
Java
0 vote173 views1 answer
Android get distance between two locations kotlin
Java