在excel中运行oracle sql查询?

时间:2021-04-08 01:03:21

Is it possible to have the queries I have written in developer run in excel? I can connect to the db in excel but I'm unsure of how to find and run the queries.

是否有可能让我在开发人员中编写的查询在excel中运行?我可以在excel中连接到db,但我不确定如何查找和运行查询。

1 个解决方案

#1


0  

Check out this page.

看看这个页面。

Once you're able to connect, you should be able to query the database in its native language. Select the Power Query tab, then the drop-down From Database -> From Oracle Database. Simply copy/paste your existing Oracle query into the SQL Statement box and you should be good to go.

一旦能够连接,您应该能够以其母语查询数据库。选择Power Query选项卡,然后选择From Database - > From Oracle Database。只需将现有的Oracle查询复制/粘贴到SQL语句框中,您就可以开始使用了。

In case you don't already have it, Power Query is an add-in for Excel. You can find it here.

如果您还没有它,Power Query是Excel的加载项。你可以在这里找到它。

#1


0  

Check out this page.

看看这个页面。

Once you're able to connect, you should be able to query the database in its native language. Select the Power Query tab, then the drop-down From Database -> From Oracle Database. Simply copy/paste your existing Oracle query into the SQL Statement box and you should be good to go.

一旦能够连接,您应该能够以其母语查询数据库。选择Power Query选项卡,然后选择From Database - > From Oracle Database。只需将现有的Oracle查询复制/粘贴到SQL语句框中,您就可以开始使用了。

In case you don't already have it, Power Query is an add-in for Excel. You can find it here.

如果您还没有它,Power Query是Excel的加载项。你可以在这里找到它。