The source table has a column which is varchar2(100).
If I create a view new_view on the column as
select substr(column_name, 1, 20) new_col from table,
then "desc new_view" command shows size of new_col as 60 i.e. 3 times

Consider this simple query:
select max(c1) from
(select 1 c1 from dual
union all

I just installed 10.1.0.3 on solaris 9 and found that it has a listener
on port 8080. (XDB or something to that effect) Where do I disable this
process???
Thanks,

We're implementing SAP on IBM AIX V5.3 with Oracle 9i and we have
several databases that are almost 1 TB in size.  Currently we do the
backup by:
1)  put db in backup mode

Can anyone recommend some helpful books to get me up to speed on
Oracle?
I recently took a job at a small chain as a database manager of a
database containing transaction-level information for all the retail

Let's say I have two schemas in a database.  Both with the same stored
procedures however one had some updates made to it.  Is there an easy
way to see what the differences are between the two schemas as far as
the stored procedures without taking them one at a time and doing a

OK... I started from scratch again.  Here is what I did:
SQL> alter database recover managed standby database disconnect from
session;
Database altered.

we encountered a very strange problem with searching in our XMLType
database.
Our configuration is:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production

We are trying to duplicate our production database onto a test server.
We are running Oracle 8.1.7.3 on HPUX.
I read through the manual and have hit some road blocks maybe someone
can help with.

I have a procedure with the following code in the body of the function:
EXECUTE IMMEDIATE 'TRUNCATE TABLE PREVIOUS';
EXECUTE IMMEDIATE 'RENAME CX_DVA_PREVIOUS TO TEMP';
EXECUTE IMMEDIATE 'RENAME CURRENT TO PREVIOUS';

I am used to SQL server which has clustered and non-clustered indexes.
If I have a 2 column table in Oracle and am doing all my lookups using
the first column, will an index benefit?  As I understand it, it will
because Oracle does not have a clustered option and the table data

Hello Oracle DBA's
I need the output like step 8.
What SQl statement is reqired without using any intemediate views..
bla..bla

I have database with ISO-8859-2 code page set
(POLISH_POLAND.EE8ISO8859P2)
I write a WinForms application which uses
those data (System.Data.OracleClient)

After upgrading 8.1.7  to 9.2.0.5
the service doesn't start the database.
The register is OK
Can you help me ???

Hello experts,
as said in the topic, I need to restore a backed up database on a
different host.
Both are running Oracle 8.1.7 and I made the backup with the following