oracle
External Tables - "partial record at end of file" error when using FIXED
I am getting a \"partial record at end of file\" error when using FIXED parameter with External Tables.[详细]
2023-04-13 03:31 分类：问答Could not resolve connect identifier error when connecting remotely
I have a web service application.The server ip is .....216. It\'s a database aware application. The database is in another server with ip ......217. Now when I run the application from 216 it works, I[详细]
2023-04-13 03:26 分类：问答How to insert string in CLOB type column in oracle db using c#.net
i am trying to save a xml file as a string in clob type column in oracle db from c# am not sure how to insert clob type data from c#.[详细]
2023-04-13 03:14 分类：问答SQL Optimization: CONNECT BY ... START WITH
I have a query using CONNECT BY and START WITH statement like below. The query in the IN clause took less than 5 seconds to run and returns 3000 rows. fact_table contains 20M of records. How can I opt[详细]
2023-04-13 03:09 分类：问答How often does oracle revise a query plan?
When running a performance benchmark for our data processing application we start with a FOO_TABLE empty and then insert records from one thread while in another thread we select the same records from[详细]
2023-04-13 01:42 分类：问答What is wrong with this simple (Oracle) SQL stored procedure code?
I\'ve looked over so many tutorials on the net, and I see quite a few similar questions to look over that don\'t answer my question since they use different SQL implementations. I\'m using SQLPlus, or[详细]
2023-04-12 23:07 分类：问答fetching data using rownum in oracle
I h开发者_开发百科ave a query in oracle to fetch data from table using rownum but i didn\'t get any data.[详细]
2023-04-12 23:06 分类：问答Cannot call oracle stored procedure and function
Might be too simple question to ask, but I do need help. I am creating a stored procedure in Oracle 10g, but I cannot call it. I am using SQL Developer to manage the database.[详细]
2023-04-12 22:54 分类：问答How to save XML document in oracle database
i want to save a dynamically generated XML document in the o开发者_如何转开发racle db using c#.net can anyone tell me the way to get this doneYou didn\'t mention your Oracle version.(You should always[详细]
2023-04-12 21:37 分类：问答Oracle SQL query fails only in one process: "ORA-01405: fetched column value is NULL"
I\'m trying to call a system stored procedure in a \"plugin\" that I\'ve built. When I test my plugin out in a test application, it works fine. When I run the plugin in the targeted app I\'m building[详细]
2023-04-12 19:39 分类：问答
加载中,请稍侯......