Can someone explain me the difference in PL/SQL behaviour on numbers in 10g?
(Executed on Windows XP 32-bit)
SQL> select * from v$version where rownum=1;
BANNER

i am new on oracle and this group
do anybody know why i cannot see updates from my asp code which added
with isqlplus.
i see the rows after a while from OraOLEDB

Is it possible to tune this statement without having to use a rule
hint?
select 'DATABASENAME:  ORA_UNDO_SPACE: UNDO_AU: '||round(f.undo_au)||',
UNDO_SIZE: '||round(g.undo_size)|| ' MB used in

Hi, does anyone know if Oracle is going to continue support Oracle9i ?

         I m trying to make replication between two oracle servers of
same versions but i am getting error like Version mismatch ..
Can anybody tell me what would be the probable cause of it.

Can someone explain to me how difficult it will be to have live links
to data displayed on a website with an oracle database??
Thank you
Shahram

In my oracle 9i Schema there is a table called 'AREA'
When I ran a DTS from SQL Server to populate some tables in my schema
it erroneously created another table by the name 'area'.  how it is
possible to create two objects with the same name?

I have
PGA_AGGREGATE_TARGET=20G
in my init.ora and select * from v$pgastat gives me
aggregate PGA auto target about 2Gb during peak load hours.

On one machine I have an oracle-instant-client installed.
( SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jan 10 09:41:29
2006)
This client I use to connect to several databases

I know this question is repeated many times, but i could not find a
solution w.r.t my problem.
On trying to run dbca i get the below msg
"jre was not found in /u01/app/oracle/product/9.2.0/

Is there a built in view that will tell you the last time a datafile
autoextended?
TIA

A multinational organization who specializes in Oracle Managed Services
and
Consulting to both the private and public sectors. Companies goal is to
provide quality

I have installed 9.2i server and 10g client onto a windows laptop
machine. Should I delete one of the TNSNAMES.ORA files? If so, which
one? The server was installed first, then the client, so that the
client then comes above it in the search path.

I'm working on a java stored procedure that needs to be able to send
requests via HTTPS. Oracle Version 9.2.0.6.0 currently has jdk 1.3.1
installed in the RDBMS.
 1) Since Java Secure Socket Extension (JSSE) is a part of JDK 1.4.0,

I read that ASM instance comes with AIO enabled by defualt (probably
filesystemio_options=asynch and disk_asynch_io=true), does anyone know
if the instances (RAC in my case) that are using the ASM diskgroups
needs also to be setup with AIO enabled or since all DB relevant files