I'm the novice user Oracle. I look for books connected with Operations
in Oracle with the use of  LOB types  I found only so far "Oracle
Database Application Developer's Guide - Large Objects" (http://
download-uk.oracle.com/docs/cd/B13789_01/appdev.101/b10796.pdf) in

I have asmlib 2.0 installed (on Centos 5) and configured, when I .../
oracleasm createdisk VOL1 /dev/VolGroup00/u02 for 3 disks all are
created as they should be. I do a listdisks and I see my disk ( VOL1
for example ). I also look in /dev/oracleasm/disks and see VOL there

hi all i have the following formula, it is giving me 70% of the result
i want would you please check where the mistake might be?
the formula is :
SELECT TO_CHAR(purinv.Inv_Date,'mm')

Our CMDB database (vendor supplied) stores information in a
singlevarchar2 field.
The DATA:
Name

I have a following XML file
<ITEMLIST>
       <ITEM>
               <NAME> Item1  </ITEM>

Hi all , i want to get out of the data, the most popular good/month i
have in my data, i figured out that it would be the one having the
maximum sales, so i m using the following formula to see for every
month, and every product, and how much were the sales this month,

hi all, how ca put multiple statmwnts in sum(case statment?
like if i have 4 regions, and 1 product, if for each region the
transport fee is different, in a sum case how can that be done, is
there any " nested if statment". i tried this and of course this is

Could someone tell me what is this DBUA0 instance ?
I am playing around with Suse Linux 10.2, using dbua to upgrade a 10.2
instance to 11g. The instance is pretty basic, it doesn't even have
the sample schemas installed and partitioning is the only extra

Could someone please help me to better understand the application of
collections in PL/SQL? Specifically, I wish to better understand when
to use a record, table of records, and various arrays. Plus what are
the trade-offs for applying one over another in various situations.

We are trying to install a 2-node RAC with NFS (Oracle 10.2.0.2.0 on
RHEL4) and getting the error below when using dbca to create the
database.
The error occurs when dbca is done creating the DB (100%).  Any

hi all , i want to take out of the data (more than one table) the
total purchases and the total sales, put each in a column near to each
others and group the rows by months and years, so i thought in pseudo
code something like this would work:

I am trying to set up Oracle for Dataguard in 10g for a Physical
standby and its working correctly. Now I have the following doubt :
When we create a database using dbca, the Flash database window allows
you to enter the place where you want this to happen and there is a

JustOracle.com is a great source for Oracle jobs across all sectors
like Apps Functional, Apps Technical, DBA, Developer, Web server,
Designer, Trainee, Analyst, and Programmer etc for Oracle
Professionals.

hi all i am having the following error :
ORA-00920 invalid relational operator
i read the quotes of other people who had the same problem but i didnt
understand how this ties to my situation, since it is about memory and