Hi Carol, I am sorry for the delay in replying. From your question it is not clear what is exactly you are trying to achieve...can you please elaborate. What are these "2016-09-01" , "2016-10-01"
Hi Santhosh, In Oracle (since inception), a schema is a collection of objects managed under a user account. In a default Oracle installation, you can choose to install the sample user SCOTT which
Hi Kevin, When you run the select statement, SELECT TO_NUMBER(BB.mileage) Mileage1 FROM BB; do you still get an error? In your CREATE TABLE statement, are you trying to reproduce table BB
Hi Santhosreddy, In SQL (in this case ORACLE SQL) the UNION operator is used to combine the result sets of 2 or more Oracle SELECT statements. It removes duplicate rows between the various SELECT statements
Dear Carol, I am sorry, could not reply earlier than today. I think you are looking for something like this %let today = %sysfunc( TODAY()); %let Mymonth = %sysfunc(month(&today)); %put mymonth