Dear All good day! I am junior in oracle database.
I have a project with oracle to implement and I need your help. I made a View in oracle and the user who will see this View, I want to make an ODBC in windows 10 which will feed the application with data by executing some queries. ODBC will be used by excel 365 and desktop power bi (32 bit). The problem is that the database that has the Data is oracle 9i and there I can't find any driver to "extract the data". In my searches I found an intermediate solution to install oracle 11 and oracle 18 so that 18 connects to 11 and 11 to 9 but that is not accepted by the company. Does anyone have any idea how I could "directly" extract data from oracle?
Also another issue I have is that in View the columns are in Greek e.g. ΟΝΟΜΑ,ΕΠΩΝΥΜΟ,ΗΜΕΡΟΜΗΝΙΑ_ΓΕΝ,ΑΜΚΑ,ΑΦΜ,ΨΞΘΥ etc. Τhe problem is that I can run queries in the database using sql*plus , when I go to run a SELECT * FROM VIEW WHERE ΨΞΘΥ =1234567890 query in the view, it gives me an ORA error -00911: invalid character (this query returns results when run in DbVisualizer). Does anyone have any idea how I can run the above query without getting an error?
Thank you in advance,
Best Regards,