从Oracle数据库中获取数据 [英] Fetching data from oracle db

问题描述

我有一个从oracle同义词读取数据并将其插入sql数据库的应用程序.以前使用的oracle数据库为8g，当前更新为11g.从那天起，我无法通过表格来获取数据.在8g中，我已经获取了将近1,00,000行，但现在我只尝试了20,000行.该应用程序不会引发任何错误，并且在尝试执行查询时也处于空闲状态. />
我的查询非常简单，例如从SynSample中选择*".


在Oracle Sql Developer中，记录正在快速加载.当单独尝试代码时，它会延迟.

谁能帮我取回记录.

I have an application which reads data from oracle synonymn and insert it into sql database. Previously the oracle db used was 8g and currently updated to 11g. From that day i could not table to fetch data.In 8g i have fetched nearly 1,00,000 rows but now iam just trying only 20,000 rows.The application not throwing any error and also being idle once it tries to execute the query.

My query is very simple as like this "Select * from SynSample".


In Oracle Sql Developer,the records are loading fastly. While trying from code alone it gets delayed.

Can anyone help me in fetching the records.

推荐答案

在这里看看:Oracle Data Provider for .NET(C#版本)入门 [

Have a look here: Getting Started with Oracle Data Provider for .NET (C# Version)[^]
All you need to do is to install Oracle Data Access Components (ODAC for Oracle 11g) with Oracle Developer Tools for Visual Studio version 11.1.0.6.20 or later..., because .NET applications require the use of what is known as a managed data provider (where "managed" refers to code managed by the .NET framework); the data provider is the layer between the .NET application code and the Oracle client connectivity software.

这篇关于从Oracle数据库中获取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！