Hi Rani,
Try this:
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection(<url>,<sid>,<password>);
Statement stat = conn.createStatement();
ResultSet rs = stat.executeQuery(<query>);
while(rs.next())
{
int ctr = ctr + 1;
}
Anjali
Originally posted by Rani Mukherjee:
Hello,
How to get the no. of rows the table having in it? I am using oracle as database & JDBC-ODBC Bridge.
Thanx in advance
Rani