Hi experts!
I am a beginner who wants to learn Oracle.
Where shall I start?
Shall I start learning PL/SQL first?

Hi NG,
I'm using 9i and I want to do a multi-column multi-row update. (SQL Server:
Update Set From Where)
What is the best method of this in Oracle?

I have a table that will always have few records. In one of my
procedures I need to get the values from one of the fields of this
table, and randomly select one value from this list. This value will be
used to update a record on another table.

I have a varchar type column say Gender.  I have shown the no. of
people in the gender column as count(gender) Total_members.  Now I want
to compute sum of this Total_members column.
And then calculate percentages for each member using the derived total

I was'n able to start the Oraclecontextservice80 on NT.
I'm receiving file already exist when trying to start the service.
Please help. Thanks!

I have a quick question regarding how Oracle allocates storage space
for its data types. In particular, I have been tasked develop processes
to move data between Oracle and DB2 databases which both are set to
use UTF-8. Now, I have no problems moving data from the DB2 tables to

I've got the following table of product types
CREATE TABLE product_types
(
 LOW_RANGE                    NUMBER(19)       NOT NULL,

Why doesn't the following work?
----------------------------
connect sys/pass@test as sysdba;
create table stats$user_log

I'm trying to create a database (10gR2, Linux) which uses asm.
Asm runs and I can query the views and everything.
Now, on a different account I try to create the database.
I've used dbca for creating the scripts and then tried to set

I am relatively new to Oracle and am assigned to determine the spec for a
few servers to house Oracle databases. I need your help in shedding a light
on the factors involved in making a wise decision for the features and specs
of the servers.

Just started my new job, and definately hit the ground running!
Platform:  Solaris 5.9
We just installed Oracle 10.2 EE on a server that already  has 8.1.7.4
installed.  This is my first time to actually get my hands on a

in the explain plan of an sql-statement I have the following part:
BITMAP CONVERSION TO ROWIDS
and then a Bitmap-Index is used.
Now, I deleted the Bitmap-Option from this index and the sql-statements

Hola,
Os escribo porque tengo unas dudas a cerca del backup en Caliente y
necesito estar seguro al 100% sobre el tema. Una vez que he realizado
el backup de los distintos tablespaces (begin backup/endbackup), ¿he

how to write the query in oracle
Add a column which sums up the last 4 weeks from the start date
selected (meaning range of date 1st to 7th) (the 4 weeks should stop on
the 31st).

I'm using 9i and I have this join in a procedure:
INNER JOIN
   (  
   Select EscPer.escalationpercent, EscPer.headerid