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.
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
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
ex.Message = \"ORA-20586: SOME TEXT SOME TEXT.\\nORA-06512: at \\\"RMM.LOKAC\\\", line 116\\nORA-06512: at line 2\"
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.
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
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.
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?
I have a problem with fetching a timestamp from an Oracle database. The table is created as follows: create table csi(start_time timestamp);
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
加载中,请稍侯......