oracle
Oracle Pro*C precompiler errors on EXEC SQL statements in included files
I\'开发者_如何学JAVAm converting some legacy code to Oracle Pro*C.I\'m on a Linux box using Oracle 11.2. We are using \".cp\" as the suffix for Pro*C source files.I\'m not much of a C developer so I a[详细]
2023-04-11 12:36 分类：问答How to write an XQuery which crosses an xsd:any element?
A schema contains a <xsd:any/> element. The code, by some external information, knows that in place of any there is a specific XML structure (e.g. foo).[详细]
2023-04-11 12:19 分类：问答How do you ORDER BY in a query using MINUS?
I want to ORDER BY the result of a MINUS query. My first attempt doesn\'t work: SELECT * FROM Table1 MINUS[详细]
2023-04-11 11:38 分类：问答No data found in trigger
I have a problem with my trigger. It returns \"no data found\" and i don\'t know how to resolve it. Can you help me ?[详细]
2023-04-11 10:52 分类：问答Oracle 11 Index only for part of the data
I\'m using a table a table called T and have a column called C_I (Index) and C_D (Data). Now I would like to only have the row in the index if C_D = null.[详细]
2023-04-11 09:54 分类：问答String manipulation in a column in an Oracle table
One of my tables\' column contains names, for example as \"Obama, Barack\" (with double 开发者_运维知识库quotes). I was wondering if we can do something to make it appear as Barack Obama in the tables[详细]
2023-04-11 09:50 分类：问答avoid 'IF' , if possible to check different condition in where clause
I have a query in which column used in where clause in changed depending on the parameter of the stored procedure:[详细]
2023-04-11 09:41 分类：问答How can i forbid an master-detail insert with no detail in Oracle Forms
I\'m trying to create a block which represents an order and that block has a master-detail relationship with the block order_itens.[详细]
2023-04-11 09:22 分类：问答Is there a way to change the exception message in oracle?
I have 开发者_开发知识库a PHP application on top of an Oracle DB. In the database, there are some constraints defined. When they get violated, I get a plain constraint violated message. I would like t[详细]
2023-04-11 07:17 分类：问答Oracle APEX Trigger - Can I affect 'Table A' when I execute a trigger on the insert of 'Table B'?
OK guys, here is my problem. I am trying to create a Trigger in Oracle APEX that will insert the 1st row on table \'APEX_LOGS\' with the default values spelled out below when I submit a row for table[详细]
2023-04-11 07:11 分类：问答
加载中,请稍侯......