I am using oracle as back end. In database there is a table with 5000 records and 160 columns. i want to display all th开发者_如何学Goese records in gridview(in asp.net, c#). But it takes more than 10
I have a table partitioned based on time stamp (like partition1 will have 9 months old data, partition2 have 6 months 开发者_运维技巧old data, partition3 have 3 months old data and so on)
I have been trying to figure out why this PL/SQL purge script runs slowly for datasets where the record table has a a few hundred thousand or more records.Prior to script execution, a certain subset o
How would you create a table where a number of the columns have default values that come from another table?
I have yet to find a good comparison of technologies for accessing Oracle from .Net applications... Are there significant diffe开发者_运维技巧rences between Microsoft\'s System.Data.OracleClient prov
I don\'t know the best way to ask this, but let me explain the issue and it may help. We currently have a feed of data that is distributed to us using an Oracle OAI hub. The data is fed to us using D
We are using dbms_xmlgen.getxml utility to generate xml using sql queries which fetches data from almost 10-15 related tables.
Is there a way in cx_Oracle to capture the stdout output from an oracle stored procedure? These show up when using Oracle\'s SQL开发者_StackOverflow社区 Developer or SQL Plus, but there does not seem
I\'am a asp.net web developer. I have the Oracle Client 11 instaled to test some features (EF support), but my applications must be in Oracle10 because my customer uses it.
if I do select * from table1 where table1.col1 = \'xx\' and table1.col2 = \'yy\' and table1.col3= \'zz\'`
加载中,请稍侯......