oracle9i_开发者

Cost of a query in/dependent of amount of data

Could you please tell me whether the cost of a query is dependent on the amount of data available in the databas开发者_如何学Goe at that time?[详细]

2023-04-12 18:49 分类：问答

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 分类：问答

ORA-22813: operand value exceeds system limits

I\'m having an issue with an oracle object I created. The goal of the stored procedure is to either retreive all wires contained on an airplane or compare the list of wires with another one (past airp[详细]

2023-04-09 02:01 分类：问答

How to block row to be selected in Oracle 9i?

We have table in database, using Oracle 9i(9.2), we must made policy for SELECT query, some group of users can access for exact row and some cannot, standardly it solved by VIEWs:[详细]

2023-04-06 00:53 分类：问答

Selecting all rows after a row with specific values without repeating the same subquery

I have a table t1 and t2 which I join and order to form data set set1. Two columns c1 and c2 form a unique identifier for the rows in set1.[详细]

2023-04-04 02:05 分类：问答

using MERGE in 9i

I want to do something like this in 9i MERGE INTO SAT_DEMANDS D USING (SELECT DISTINCT d1.PRODUCT_ID AS product_id, CA.CUST_ID as allocated_cust[详细]

2023-04-02 04:51 分类：问答

Oracle 9i auto increment trigger/sequence doesnt work

The following SQL, upon being executed on an Oracle 9i server, yields the the error \" ORA-04098: trigger \'DBO.W开发者_如何学PythonTF_TRIGGER\' is invalid and failed re-validation\".[详细]

2023-04-02 00:44 分类：问答

Are statistics computed for indexes associated to primary keys in Oracle 9?

I\'m beginning to work with Oracle and I\'ve learn that in Oracle 9 statistics aren\'t collected for an index unless you use COMPUTE STATISTICS, but you can\'t use that option when defining a primary[详细]

2023-03-31 07:21 分类：问答

Datawindow - datasource - storedprocedure error - cannot create datawindow

While applying the datawindow datasource as a procedure, the following error message will开发者_开发知识库 show.[详细]

2023-03-27 20:42 分类：问答

Oracle PL/SQL - How to create a simple array variable?

I\'d like to create an in-memory array variable that can be used in开发者_运维知识库 my PL/SQL code.I can\'t find any collections in Oracle PL/SQL that uses pure memory, they all seem to be associated[详细]

2023-03-27 06:28 分类：问答