I need to 'fill in the gaps' in the results of SQL1 - notice that it
doesn't
return any results for 06/01/2006.
SQL2 returns results for all dates, with a forced count of 0.

I'm currently running Oracle server 8.1.7 on Windows 2000 server.
Looking to upgrade to Windows XP Pro.
My questions are: Can I go straight to Oracle server 10 or do I need to
first upgrade to 9 and then upgrade to 10? Is 10 different enough from

Hi Im A unix admin,
now asked to support oracle DB server administration,
can any one please please help me with some good docs and CHEAT SHEETS.
As a trade off I can share some of my unix administration and SAN and

I am using
"Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production"
I am building some views.  I am using a "WITH" clause that selects a large set
of items, and then the main query joins with the "with" query on one of the

I'm no Oracle expert, not even newbie level :-)
I just need to know if it is possible at all to obtain the list of
tablespaces for the logged-in user.
For example, after I log in to the SQL Plus console and type a command

Hey all,
 I have a 9206 enterprise database running on windows 2003 standard
with the 3GB switch.   My SGA is 1200M and my PGA target is 300M,
currently the maximum pga allocated (v$pgastat) is 380M.  So, if I add

I'm in the situation that I have to install the Oracle Partitioning
Option on an allready productive database.
The installer CDs are version 9.2.0.1
The version of the running system ist 9.2.0.6

I read from Oracle technology Network that Linux Red Hat Fedora 4 is
recommended to install 10 G 2.
So I downloaded the five ISO files from the Fedora site.
The documentation suddenly indicates that I have to boot from the CD

What system privs or roles must be provided to a non-dba user to allow
them to use the sys.user_* views that are inturn linked to sys.$* tables?
Thanks

i want to run a pl/sql program from sql plus
how is it possible?
how to set server on

I am new to Oracle and need some help. I installed 10g on my laptop
with windows media center. I had problems logging into the SQL editor.
I tried deinstalling 10g and still was left with 10g in my drive. How
do I clean it all up and then reinstall 10g or an earlier version of

In the first place, excuse by my badly groins.
Now my question:
¿Which is the best form to write a consultation of the type join?
Ansi-89:

Much of my group works on a reporting application. In order to achieve
greater SQL re-use we have tried to use views to avoid re-writing the
same portions of SQL. The problems we've run into so far include: (i)
union-alls in views seem to force evaluation of the view rather than

I would like to run something by you all -
Environment: Win2k3 Server, Oracle 9.2.0.6, physical standby
arrangment.  The standby server is on the far end of a DS3.
Archivelogs are sized at 125MB.  At times the standby falls fifteen-

I'm a new Oracle DBA and have just undergone my first Oracle upgrade
(10.2.0.1).  My programmer has shown me an error from XMLQuery
returning a Java error ORA - 29532.  Below is the XML code and the Java
Error.  Can anyone please tell me where I went wrong?