I would have searched google if I would know how this statement is
called.
I searched the SQL reference but could not find it.
I use it but I don't know the term.

Helo
I was install an oracle xe on fc4 . But I don't want the default database  
, so i was delete controlfiles and database files , change database sid  
and create it manually . It works - but htmldb not. Where can I find files  

 I see the function-based index restrictions from otn
link,http://www.oracle.com/pls/db92/print_hit_summary?search_string=Restrictions+for+
Function-Based+Indexes
Function-based indexes are not used when OR-expansion is done.
for example:

               I am facing Problem in Update Query when I am Updating
the Oracle table "ACCOUNT" From the Sql Server Table "Account" using
DBLINK ("@DBL_NO_GCMS" which itself refers to SQL SERVER Data Base
Through Oracle Transparent Gateway Connectivity), as When I Fires the

Given a LOB locator, e.g OCILobLocator object,  is it possible to
obtain the associated table name, column name and rowid for that LOB
record?
Thanks

Oracle 10.1.0.3
We are just starting to work with data warehousing, and are having some
problems with query rewrite.  I need several materialized views that
have a raw data type.  This appears to mean that query rewrite will not

In Oracle 9i I need some help determining exactly what I am using as
far as product name.  I do not know the difference between WebDB,
HTMLDB, Oracle Applications Server, OAS with Web Portal etc.
I have installed Oracle 9i DATABASE with the http (Apache) server

Hi.  I have heard that Oracle Admins are considered the best in the
world. I thought I'd see if you guys can help me with an SQL query that
has had me pull out some hairs off the top off my head.

I want convert NVARCHAR2 to VARCHAR2,fail in oracle 8.1.6, but succeed
in oracle 9.2.0;
this is my tables,for same sentence like this :
SQL> desc n1

Hi, all.
I got into a little bit of confusion with my rman (8i on AIX) recently.
Long story short: if I log into the rman executable with the rman ID ,
after having granted the rman ID sysdba privs, and then watch the

when we give ' select * from emp;'
it gives an  output.
can you get the same output by putting some value in statement below
select * from ********** where table_name='EMP';

Can anyone give me any advice on lowering this parameter
in Oracle 8.0.5
Thanks in advance.
------------

I am having problems finding similar errors on the web. I am interested
in using Datapump (Oracle 10g) for nightly backup with a simple
database. I was trying out a Datapump example and got errors which I
traced to LCR$_DDL_RECORD and LCR$_ROW_RECORD missing definitions

I have a problem with one of my update queries.  Im trying to update
table 1 column x_number which is datatype number() using the data in
table 2 column x_char which is datatype char().  The following query
does not work as i get the error value is not a number.

I'm encountering a strange problem with the 64 bit ODBC driver that comes
with the 64 bit (x64) 10.2 client. I have installed the client and that all
went fine, and I can use sqlplus to access my databases.
Now, I have setup an ODBC datasource using the Oracle ODBC driver that gets