Hi, You have list the folder names in a text file using "X" and "dir" command on windows or "ls" ,command in unix environment. Then read the file in a data step and store the folder names into a macro
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