I have DB Link defined in my Oracle DB I work with from JSP application
which uses
Tomcat's connection pool. When remote DB is available, everything is
fine. But when

Please correct me if i am wrong.
Internally, the order of execution for a SELECT statement is as
follows:
FROM clause

Please correct me if i am wrong.
Internally, the order of execution for a SELECT statement is as
follows:
FROM clause

Anyone know about tool that helps designing indexes ? the tool must
consider user queries and stats on tables.

We did an Oracle 10g install of the base software.  We could not get
the DBUA to work, so we decided to re-install Oracle, chosing it to
perform the database upgrade at the same time.
We removed the ORACLE_HOME directory and all the contents.

I have this kind of data
ID     Text
1        a
1        b

I have a file with one statement
INSERT INTO COPS.PRODUCT_TITLES (ISBN, TITLE) VALUES ('1230512980', '
Lab Activities & Long-Term Projects, AlgOneInter Crs 2');
But when I try and run this (using "start myfile.sql" in sqlplus) I

I'm trying to run SQLPLUS from within a Tomcat CGI script. I have had
no trouble running this same script on Apache and IIS web servers but
in this case I've been told to use Tomcat as a Standalone server. (OS
is Win2003 Enterprise Ed. ; DB is 9i)

  We had a query (written by an app guy ) to do some call usage
processing (telecom billing system ) ...
These were the 2 queries ,,,(in a perl script )
Needless to say he was doing it very inefficiently and the report he

This thing is very frustrating!  If Oracle is going to invent an
installer, it should work!
We ran the installer, and, we selected that it should also upgrade the
database.  Now, the install instructions say that the Net Configuation

Oracle 9iR2
Take the following string (it is a piece of SQL)
select c1,c2
from   (select c1,c2

I have a performance problem with a view. I need to convert a string
field to a number field in the select statement of the view. But when I
do this, the index on the table seems to be ignored, which is
problematic with the response speed.

i am working with Oracle 8.1.7.0.0 and need to keep updated one table
with the changes from another table. The idea i am following is through
materialized view log that tracks all the changes made to the master
table.

         1. The version of oracle is (Oracle 10g Release 2).
         2. This error is given when the Informatica's repository
being created.
         3. The schema through which the repository is being created

I'm currently encountering a weird problem with one query. Because I
want to look into how CBO is treating this query, I tried using event
10053. Before running a statement I'm issuing:
alter session set events '10053 trace name context forever, level 1';