My employer wants me to take an orcle certification (OCA), and currently
I studying for the 1Z0-007 exam. However I find the test-exam questions
quite theoretical. I'm therefore looking for a book or tutorial, that
can give my a bit more hands on experience with oracle. My ...

Vennela Technologies Pvt. Ltd. is a Leader in ERP Training and
Projects in India Vennela Technologies has been in Training from last
4 years. Vennela trained more than 4000 users in Oracle Applications
till date.

IIRC, there is a RAC configuration setting that determines the level
of consistency in the view
of the data between multiple RAC nodes. The tradeoff is between
maximum consistency and

Ive got a view that unions two similar tables
Ive got function that uses that view to find the last record and spits
out a column.
when i run the function by itself it always work.

Is there a way to use EXECUTE IMMEDIATE together with BULK COLLECT for
fetching rows from a query where the column list is built by the app at
runtime or is DBMS_SQL the only way to go?
Thank you. Kind regards,

select p.phone,p.account_number,o.amount from users_phones p, orders
o
where  p.account_number = o.account_number and p.status=1 and p.eci=0
and o.validation_date > sysdate-15

I have implemented Data Guard in Oracle 9i.  I will need to migrate my
databases to 10g.  In this environment using the Grid Control and
corresponding Web GUI to implement Data Guard is not an option.  Other
than Oracle's site, most docs on the web on Data Guard seem to be on

Is there a way to have rwclient report a standard error when it has
got no data from the queries in the report?
Any help will be appreciated.

I seem to have deleted my original post - twice! So
I'm going to start over - as before, database entity
names are fictitious.
I was in TOAD logged in to schema1 (Oracle 9i).

I want to do a "Select distinct" including a table which has LOB columns and
I see from the Oracle documentation that this is not possible.
all of my tables have a unqiue primary key which is an integer and is
included in the select target list. is there any way to tell oracle ...

We have one application which has 2 users(A,B) created in our DB on
solaris.
Now the query is mainly related to licensing.
How will oracle10g considers these users?

Hello Oracle People,
I'm trying to figure out how to import a transportable tablespace I
found.
The tablespace contains the "sample schema"

When running the following query on Ora10.2.0.3 32bits Win., I got a
ORA-00904 error, which said "BB"."S" is not a valid identifier.
with a as ( select 'x' r, 'x' t from dual ),
    b as ( select 'x' s, 'x' t from dual)

I was in schema1 (not the actual name) in TOAD -Oracle 9i - and tried
select count(*) from schema2.table1; (not the actual names)
I got an 'invalid or unknown table'  error, although, as you
will see below, schema1 has read access to schema2.