You are viewing a single comment's thread. Return to all comments →
My initial query failed for oracle database and I was thrown aback, only for it to succeed when I changed the "&&" to "AND".
I am quite surprised because my PLSQL will accept "&&" and not "AND".
The failed statement:
SELECT * FROM CITY WHERE COUNTRYCODE = 'USA' && POPULATION > 100000;
Seems like cookies are disabled on this browser, please enable them to open this website
Revising the Select Query I
You are viewing a single comment's thread. Return to all comments →
My initial query failed for oracle database and I was thrown aback, only for it to succeed when I changed the "&&" to "AND".
I am quite surprised because my PLSQL will accept "&&" and not "AND".
The failed statement:
SELECT * FROM CITY WHERE COUNTRYCODE = 'USA' && POPULATION > 100000;