How can I 'select' all items from a table variable?
Actually, I want this syntax to use to create a subquery that I can
use to join against.
I have a CSV string, and I wanted to use either

i have a little problem with a formula in oracle which i dont know how
to do it all, i have done many attempts but no success!
i will write the result i am aiming to get here:
Month Year    SP-20.2    SP-20.1    SP-20.6

We have an Immediate Opportunity for you as Oracle HR Technical
Consultant
Location                     :        Green Bay, WI.
Employment type    :           12 months.

i want to get the top 3 product that are the most sold, i want to use
in the where clause, rowNum <= 3 but i dont know what is the exact
syntax, my attempt is this:
select  Prod_Code , sum(qty) from purch

I installed OC4J on RHEL to use as a reporting server together with Apex
3.0. The installation went fine, but I have 1 important problem. Whenever I
close the console session that started the oc4j process, the process gets
terminated and there is the error "JVM termination" in ...

  I have a table with the following two columns and sample data:
   tran_date  DATE;
   digits        NUMBER;
   10/2/2007      0.000738889791980111

I have tried to autostart an oracle instance by following  the
instructions here:
http://www.oracle-base.com/articles/linux/AutomatingDatabaseStartupAndShutdownOn
Linux.php
following an install described here:

   I am traying to upgrade database source : 9.2.0.8.0 destination :
10.2.0.3 with 10.2 Database Upgrade Assittant. At the end when program what
to start upgrade i saw information :
1 - The instance version does not match the dictionary version which is

I was working as a trainer(contractor) for Oracle University Turkey
and for their education partners. One of their partners tried to force
me about a training that OUT(Oracle University Turkey) will not know
anything about the education(with photocopy books).

I want to perform a cartesian outer join with the old plus-sign
syntax. So far I've come up with (and it works)
SELECT ...
FROM A,B

There are two type to write select qurey left or right outer join
1.
from table1 left outer join table2 on (table1..column1=table2.column1)
2.

i have a column in my database with Long datatype, and i have to
update the values in it.
when i am trying to update it via
UPDATE UM_TB_PD_BU_ACCSS SET nm_prdct_dvsn_id = 1,vc_bsnss_unt_cd =

I am new to Oracle.  I need to connect to a Oracle 8 database to
extract some data.  I have read some of the postings and wonder what
is the least involved way to connect the two.  Is the Oracle OLE
driver (not OLEDB) good?

Does anyone have oracle 10g training slides.
Please forward me if there any slides are available.
Thank you
RA