hi
how can i convert the following mySQL statement to Oracle statement? thanks
$num = mySQL_numrows($result);
avoid using mysql_numrows()
use "SELECT COUNT(column) FROM TABLE"
with column preferrable being the primary indexed column.
oracle might have custom numrow function, but i like to avoid vendor specific extensions/functions when possible
with column preferrable being the primary indexed column. >>
Why should that matter?
Because depending on the database server, columns with null values might or might not get counted. A primary key is never null.
I'm aware of the semantical differences betweeen count() and count(column). I do not agree that there should be any advantage (performancewise) of using select count(column) rather than select count() given taht column is not null.
