You will need to install the Oracle Client first. Google “Oracle Database Client windows” to find the download from Oracle’s site. 1) Install the 64-bit package first. (VERY important as there is a bug that messes things up if you install the x86 package first) 2) Change the install path to “C:\oracle\x64” 3) Once installed … Read more
If this is for a specific row, maybe use SUBSTR? Something like SELECT SUBSTR(column, 6, 5) AS col1 , SUBSTR(column, 13, 5) AS col2 FROM table Here is something else you can do.. Although it gets pretty complicated, and this isn’t the exact answer you are looking for but it will get you started. Hope … Read more
I’m sure you can work this out yourself.. I guess it needs to look something like this.. but you don’t say how you want the data to be combined so I’ve just just a cross product (the WHERE 1=1) of the last data set to a union of the first two with PH AS( SELECT … Read more