There are two queries:
1. SELECT
      RR.*, a.NAME
FROM

I have a dynamic query which basically loop through an ID field in a
table then build queries dynamically then union all the queries
together, such as:
select * from (complex subquery) where a = 1

Is it a must to use Raw devices with RAC?
What is the justification of using RAW on standard Oracle instances?

We are running ORACLE 8i  on a SUN OS 5.8.
We do a cold backup nightly during the 12:00 AM - 3:00 AM window.
One night the backups went beyond 3:00 AM and the database came up
during the backups.

I have a view that is defined by a number of joins and it is good to
provide that view to the users because it makes it simple to select
from.
However, I would like to select from that view records that meet

I am trying for the first time to connect VB6 and oracle express 10g (and I
am brand new to oracle)
1 ) I installed, Oracle and the various universall installer
2 ) I created a user with all privileges and a table "CUSTOMERS"

Could anyone help me to convert mysql table schema to oracle table
schema.
enum in mysql is a string OR SET datatype.
CREATE TABLE `builds` (

I´ve psoted sometime ago a question like this but, now it´s more
specific
I need a fast way to be warned on failed login attempt with some
importante schemas.

Can anyone let me know why the advisory is saying i can so drastically
reduce my PIO's by reducing my db_cache_size?
This was from a statspack 15 minute snap on 9.2.0.3
Buffer Pool Advisory for DB: MERLIN  Instance: MERLIN  End Snap: 24

As part of an application to automate server management, I need the ability
to access servers via secure shell in order to execute shell commands /
scripts, and also the ability to receive connections from servers via ssh.
One partial solution I have created is a custom agent that ...

Does anyone has a function which returns the Oracle host version, but
with flexible partial version, just like this
SQL> select version(5) from dual;
VERSION

If Buffer busy wait indicates that "multiple process are trying to
access a buffered block simultaneously".  How can segment header
(freelist contention)  can be a reason for this. ? Segment Header is
there in the physical files. How can this cause BUFFER busy wait.

Does anybody know why oracle (9i) creates different execution plans
when doing a
"create table as select" and a "select" (where both selects are equal)?
Oracle doens't always do this, but it's very frequent.

Dear Gurus,
Why I m getting some values in minus..........
and which TBS is more used and which not.
select

Given a table, is there a way, using SQL, to figure out,
which columns are part of the primary key?
Given two tables, I'd like to create the "on" condition
of a merge statement.