将数据从CSV导入Oracle(Importing Data from CSV to Oracle)

   IT问题网   2021-02-19 00:00:00

问 题

您好b $ b

我想将数据从csv导入oracle,导入时我需要



验证每个具有所需格式的单元格数据,需要检查列名是否相同。



请建议如何继续。

解决方案

有很多选项:



1)您可以使用codeproject中的文章来读取csv文件(只搜索)和自己做逻辑。

2)有数据迁移程序(只搜索谷歌)。

3)sql服务器有一个数据转换向导,可以做到这一点。 / blockquote>
有很多方法可以解决这个问题,从你的问题看起来你需要执行一些指定的数据检查和验证,在这种情况下你可以使用两件事



1)构建一个应用程序,它将从csv文件读取数据进行验证,然后将其存储在某些离线存储中(比如数据表),一旦你在一个表中拥有所有有效数据,你就可以一次将数据插入到oracle数据库中。在某种文件或其他东西中保存无效数据的记录总是一个很好的做法(它由你决定如何做到这一点。



2)在数据库中创建表并为列添加验证条件(类似它会允许仅当日期有效且全部时才插入。我认为它在oracle中称为检查约束,然后您可以使用oracle提供的默认实用程序将数据插入表中并将无效数据保存到其他文件中。



希望这有助于

标签:数据导入



分享:

  • 微信
  • QQ好友
  • QQ空间
  • 新浪微博


热门推荐

如何使用存储过程传递id(how to pass id for where using stored procedure)

problem how to pass id for where condition when using mys ...

使用cookie值加载gridview(Load gridview using a cookie value)

problem i have a method to load a gridview according to a ...

只有添加足够的行才能启用垂直滚动条,才会显示ClistBox(ClistBox doesn't display until enough lines are added to enable the vertical scroll bar)

problem i have an application that adds lines to a list b ...

DateTime数据类型的算术运算。(Arithmetic Operations on DateTime Datatype.)

problem hi, i have been trying to find a way to do arit ...

将图像插入Word(Insert Image to Word)

problem how to compress inserted image in word using dsof ...

我如何缩进给定的XML(how can i indent a given XML)

problem is there any easiest way to indent given xml i ...

我想将Outlook消息保存到sql server db(i want to save outlook messages to sql server db)

problem hi could you please help me on saving outlook m ...

我如何在cookie中保存令牌(how I can save the token in the cookie)

problem hi, i am creating the web service au ...

C#.net中的ModalPopupExtender(ModalPopupExtender in C#.net)

problem while i am clicking the modal popup extender wind ...

需要帮助来更改密码表格(need help to change password form)

problem hi everyone, i am still newbie in vb. ...

CMap或CMapPtrToPtr(CMap or CMapPtrToPtr)

problem hi, i want store the objects in cmap ...

如何创建新的任务栏(how to create new task bar)

problem hi, i want to create new taskbar,can any one hel ...

在C#.net中旋转PDF文件(Rotate PDF File in C#.net)

problem hi , how to rotate pdf file in c#.net ...

在C#.Net中旋转图像文件(Rotate Image Files in C#.Net)

problem hi, how to rotate image files(jpeg,ti ...

如何交换字符串中的字符(how to swap characters in a string)

problem hi all. i''m new in .net and i want t ...

如何在SHAREPOINT 2010中集成twitter(How to integrate twitter in SHAREPOINT 2010)

problem hi to all, this is siddiqali working ...

检查应用程序是否正在运行(Check If Application Is Running)

problem is there a way to run a loop that wou ...

如何使用radiobuttonlist?(how to use radiobuttonlist)

problem i want to write select query for selectedindexcha ...

如何计算日期差异和数字差异(How to Calculate Date Diff And Num Diff)

problem glnotranscationdate deposit withdraw transid loan ...

ie6浏览器问题在我的网页上(ie6 browser issue in my web page)

problem my webpage displaying 1 inleft bottom corner only ...