Using TDA Professional 18.104.22.1684 in an Oracle environment
Connecting to an Excel 2007 worksheet
How can I use full Oracle SQL language to query the Excel spreadsheet, e.g., minus set operator doesn’ work…no to_date or to_char…and more…
When I look at the functions available while trying to do a where clause in Build a Query, the functions look like Microsoft functions and not Oracle
Trying to restrict rows returned in query based on a date column, not getting correct results
The Excel date column comes in as VARCHAR(255) don’t know if this should be changed to a Date field, I am unable to change it.
My experience is limited to writing Oracle SQL queries…any help on how/if I need to connect to the Excel sheet differently or on how I can use all of the Oracle normal query language would be greatly appreciated.