oracle10g
Oracle error:- LRM-00116: syntax error at 'control' following '='
Oracle DB/Windows XP:- I am running an batch file开发者_StackOverflowthat calls an“.ctl” filewhich in turn calls an “.xls” file, both present in the same folder.[详细]
2023-04-11 20:18 分类:问答Difference Between Drop And Drop Purge In Oracle
I am using Oracle Database and I am a bit confused about Drop and Purge Commands. In fact for me both does the same thing. Removes the t开发者_JS百科able with schema from database. What is the main di[详细]
2023-04-11 19:03 分类:问答Exracting substring from given string
I have data as following 1)MAXO_INSTR_INTERFACE 2)MAXIS_VENDOR_INTERFACE 3)MAXIMOS_EMPS_INTERFACE2 I need to extract String开发者_开发百科 which is located betweenboth underscores in PL/SQL as[详细]
2023-04-11 18:47 分类:问答custom exception and parsing message from exception
ex.Message = \"ORA-20586: SOME TEXT SOME TEXT.\\nORA-06512: at \\\"RMM.LOKAC\\\", line 116\\nORA-06512: at line 2\"[详细]
2023-04-11 18:04 分类:问答Unable to load DLL "OraOps10.dll"
Hi dear all my friends, I got some oracle problem in my c#.net window based application.I am using oracle 10g express version and vistual studio 2008.[详细]
2023-04-11 06:59 分类:问答Oracle select query taking too long
We have an internal application based on .Net which calls certain procedures in Oracle (10g). One 开发者_如何学Pythonof these queries is run to get in/out parameters of these procedures. It\'s a prett[详细]
2023-04-11 05:35 分类:问答Oracle 10g (Win 64-bit) installation on Windows 7 64 bit fails [closed]
Closed. This question is off-topic. It is not currently accepting answers. 开发者_JS百科 Want to improve this question? Update the question so it's on-topic for Stack Overflow.[详细]
2023-04-11 05:15 分类:问答jOINING tables with millions of rows
i have the sql below that returns 35k rows and take about 10 mins to run. both tables have millions of row. how can i improve this sql?[详细]
2023-04-11 01:27 分类:问答Getting Timestamp results in java.sql.SQLException: General error
I have a problem with fetching a timestamp from an Oracle database. The table is created as follows: create table csi(start_time timestamp);[详细]
2023-04-11 00:22 分类:问答optional foreign keys one of which must be mandatory - how?
I have a table that has two optional foreign keys, each to a different table and one of which HAS to be filled in, but it doesn\'t matter which one.I was thinking about using a trigger to enforce this[详细]
2023-04-10 23:09 分类:问答