Querying Oracle Database, script has aliases in it
A lot of the one-off programs that I am doing depend on me grabbing info from an oracle database and some how manipulating it in Excel. That part is done...but now I have this one script that is huge. My program streams to text into a string object from a file where the sql is stored, so there is mistyping going on. Also the SQL works when I run it from another SQL client. The only thing is the query has aliases in it, and I kind of remember excel having issues with aliases. Can somebody confirm or deny that this is the case?