Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Excel query to Oracle Database

TerryChenJun 3 2010 — edited Dec 27 2017
Dear all:

I want to use Excel link to Oracle Database to query data, and I don't want to install the Oracle Client and through ODBC. Can some one tell me how to do?




Regards
Terry
This post has been answered by Satishbabu Gunukula on Jun 7 2010
Jump to Answer

Comments

mariohik

I tried to follow the steps on this "https://docs.microsoft.com/en-us/ef/core/querying/user-defined-function-mapping" page but couldn't generate sql because it can't convert string[] or IEnumerable<string> to the parameter.

Alex Keh-Oracle

The most straightforward way is to use FromSqlRaw to call the SQL directly.

mariohik

@alex-keh-oracle ,
.NET 7.0 allow us to use string.Join (C# code) on our query.
Will Oracle convert string.Joing (C# code) to LISTAGG (PL/SQL code)?

Alex Keh-Oracle

I'm not sure I understand the question. The .NET String class does not have an implementation that ODP.NET can override unless you are asking about ODP.NET OracleString class.

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 7 2012
Added on Jun 3 2010
#oracle-services-for-microsoft-transaction-server, #windows-and-net
6 comments
225,971 views