Pay attention, TO_NUMBER needs a dot, not a comma
On the exam, you will be limited in time and may not pay attention to details. And may lose some points therefore on simple questions like that. You will have a good portion of questions which requires attention rather than knowledge or logic.
This is a typical situation that can confuse an average student on the exam. We all know that using a subquery that […]
It is normal if some or all grouping attributes will not be present in SELECT statement. The grouping will work anyway. SELECT […]
When we are using a format mask ( for example with TO_NUMBER function ) we have basically three options : 1 We […]
You can’t have LOB data types (CLOB, BLOB, BFILE) ordered. Oracle will trigger an error when you try to order on LOB fields […]
