hello...
i have encountered several sources on the net stating that
regularly rebuilding an index yields no "measurable" improvement
in performance...

I'm having trouble comparing CLOBs. To be specific, I have a CLOB
parameter being passed in to a procedure, and a CLOB variable being
selected into. Both CLOBs are essentially long text data - I want to
treat them as character strings and compare these two 'strings' to see

hi everyone...
i have a bunch of codes here where i browse the computer for a txt file
then collect the information and store it into a database.. but i had this
error "invalid table name " and "invalid column name" when i run the

I have a requirement to do custom processing for any new
transaction, which happens in a Oracle database.
When there is a new transaction in the oracle database, how can
I know the following information.

in a firebird-procedure I habe the statement:
for select TITLE in DOCUMENTS d where d.STATUS = 'online' do
begin
path = 'd:\'||vUserDir||'\'||TITLE;

OK I admit I haven't done much research into this but i'm just looking for
some hands-on experience.
Oracle 10g supports the FLASHBACK DATABASE feature. This allows to do a
recovery based on information stored in a flashback area (flashback logs).

orange      May 14, 5:16 pm     show options
Newsgroups: comp.databases.ms-access
From: "orange" <orange...@mail.ru> - Find messages by this author
Date: 14 May 2005 14:16:49 -0700

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
I've created a table:

I started up a Oracle 10g database running on a WinXP machine and found
this:
ORACLE instance started.
Total System Global Area  171966464 bytes

Can anyone suggest any free lightweight clients that just allows basic
table viewing and basic query using either Java thin/thick or ODBC.  We
have installed Oracle's Instant client on windows for a bunch of end
users and they are not happy with just the DOS version of sqlplus.

I have a file that has patient data. The file contains multiple
patients.  A patients has multiple records I want to process patient by
patient.  I know of a way that I can read and write simultaneously.
How can I dead and put it in a temp space and process it and then read

please anyone can explain how i can import a file?
i have a *.dat file.. please when i use imp command this tell me "only DBA
can do this"..

conn bdj/bdj@hub92 works fine
but
conn bdj/bdj
results in ora-12560 and i'll become disconnected.

How to extract the records of same datetime from a table?
I have a table 'tbl' with datatime column 'call_time'. there is no
unique constraint or primarykey.
How can I extract only the records of same call_time values?

We installed a standard 9.2.0.6 database on Windows 2000. It
was a standard installation, with the possible exception that
the demo tables were installed.
However, when we tried exporting some schemas yesterday, the