dbsaint-检索表格EXCEL [英] dbsaint - Retrieve form EXCEL
问题描述
如何从Excel检索数据(使用sql)到Oracle数据库中的表.我正在使用dbsaint.
为此，我应该使用哪个开发人员工具而不是DBSAINT?
最简单的方法是将数据从Excel导出到CSV文件.然后使用外部表将数据插入数据库表中.
导出CSV文件可以像另存为..."那样简单.但是请注意您的数据是否包含逗号.在这种情况下，您需要确保安全地分隔字段和/或确保分隔符是您的数据中不会出现的其他字符:|〜|之类的字符集(竖管). 了解更多信息.
外部表是在Oracle 9i中引入的.它们就像普通的堆表一样，只不过它们的数据保存在外部OS文件中而不是数据库中.它们是使用DDL语句创建的，我们可以对它们运行SELECT(它们是只读的). 了解更多信息.
还需要一些其他的数据库基础结构-CSV文件必须驻留在OS目录中，该目录定义为Oracle字典对象.但是，如果这是您要定期执行的任务，那么付出的努力是非常值得的. 了解更多信息.
我对DbSaint不太了解；它是某种数据库IDE(例如TOAD或SQL Developer)，但专注于廉价的低端"市场.它可能不支持此确切的活动，尤其是从Excel导出为CSV的情况.
How can I retrieve data (using sql) from Excel to a table in Oracle database. I am using dbsaint.
Instead of DBSAINT, which developer tool should I use for this purpose?
The easiest way to do this is to export the data from Excel into a CSV file. Then use an external table to insert the data into your database table.
Exporting the CSV file can be as simple as "Save as ...". But watch out if your data contains commas. In that case you will need to ensure that the fields are delimited safely and/or that the separator is some other character which doesn't appear in your data: a set of characters like |~| (pipe tilde pipe) would work. Find out more.
External tables were introduced in Oracle 9i. They are just like normal heap tables except their data is held in external OS files rather than inside the database. They are created using DDL statements and we can run SELECTs against them (they are read only). Find out more.
Some additional DB infrastructure is required - the CSV files need to reside in an OS directory which is defined as an Oracle dictionary object. However, if this is a task you're going to be doing on a regular basis then the effort is very worthwhile. Find out more.
I don't know much about DbSaint; it's some kind of database IDE like TOAD or SQL Developer but focused at the cheap'n'cheerful end of the market. It probably doesn't support this exact activity, especially exporting to CSV from Excel.
这篇关于dbsaint-检索表格EXCEL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
