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?
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\'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
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:
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.
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
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\".
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
While applying the datawindow datasource as a procedure, the following error message will开发者_开发知识库 show.
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
加载中,请稍侯......