my query does not work bad for the small tables but maybe exists
something more productive:
select F1 from A
where F1 not in (select F1 from B)

I think it would be benficial to request a new newsgroup:
comp.databases.oracle.pissing.contest
or, if that is offensive, then:
comp.databases.oracle.argument.clinic

I'm looking to create a trigger using the Oracle Enterprise Manager.
I want a table feild to be updated based on an event from another
table.
I have 2 tables (PPLP and PAWU) the first table (PPLP) has the

does the last two lines of the query have sense?
SELECT a.f1, a.f2, b.f1, b.f2FROM  a, b
WHERE a.f1 = b.f1
AND a.f2 = b.f2

Can I somehow find the list of Package/Procedure Names that use the
specified table?
I do not have DBA privilege, but the table exists at my schema.
Thanks

i have installed 10g lite on Windows XP Pro. I can connect via msql. But i can't connect with sqlplus.
I tried with:
sqlplus system/i@odbc:polite
and with

What is the purpose of TZ_OFFSET()?  For example,
select TZ_OFFSET('-3:0') from dual;
select TZ_OFFSET(sessiontimezone) from dual;
select TZ_OFFSET(dbtimezone) from dual;

Here is my table (all types are NUMBER):
SQL> desc sc.graphe
Name
-------------

How can I delete archived log files in such a way that they show up as deleted in the v$archived_log
view of a primary database (standby destination)?
I'm trying to keep the disks of a standby db from overflowing with archived logs.
Lots of Greetings!

Can anybody tell me where l can get some detailed information on using
Oracle ADI software, recommend a book etc
Regards
Michael Beckinsale

We are currently running Oracle 9i (latest patches applied) with Real
Application Cluster (RAC) technology on Windows 2000 Advanced Servers.
We have a two node configuration and are witnessing a problem with one
of the nodes (always the same one) being evicted from the cluster every

Hey all,
About a week ago Oracle released their first quarterly
maintenance/security patches.   I'm curious as to how others out there
are handling it?   My manager asked me to look at the patch and

I have a very basic question. I am trying to read/write large documents from
a web-app to Oracle 9i using php4.3.
When I try to use CLOB column and print data directly, the web browser or
server does not understand that it is clob and just prints out object. Then

I am new to database design and data modelling.I want to know which
book r usefull for me in the intial stage on 'RDBMS Concepts' and data
modelling.

When I create a table with a not null column, Oracle implicitly
creates a check constraint "<field> is not null":
    > create table AAA (B number(10) not null);
    > select * from user_constraints where table_name = 'AAA';