I have a table t1(name, value).
The entries are (a1, 40), (a2, 233), (a3, 22).
Is it possible to write a query which tells me whether the value is
above/below 100.

I have a table with a column whose values are very skew. A large
majority of rows has a single value for this column. I have an index,
a not-null constraint and a frequency histogram on this column.
The CBO uses the histogram data correctly when I query with an

Hello,
I'm a bit brainwashed by the SQL Server Programming dialect...
I'm trying to update a column in a table, and immediatly do a select of
that column in one statement.

I am trying to learn how to duplicate a database using RMAN.  I am
running oracle 10.0.1.0.3.  Here is what i did so far.  I installed
Oracle on my Aux server.  This server has the same directory structure
as the target server and both are windows server 2003 sp2. I then

i am trying to create a new text file on the server using utl_file
package in the write(w) mode but the file is not being created
automatically. i hav to create it every time. The file should be
created automatically isn't it?

I have 2 identical Solaris servers (freshly installed v490 - dual CPU
8GB RAM). The OS (Solaris 10) were both installed to an agreed spec by
2 diff consultants (all disk mirrored and striped).
I created identical 9208 DB instances on both servers (using identical

***Hi***
Common scenarios that have solutions described in the Using ISA Server
2004 with Exchange Server 2003 document are there for you to read.
http://it-techexperts.com/MCSE/GAISA09.asp

I have the privilege on create any views on the database, and also I
have the select privilege on v$mystat, but I could not create the view
as below,
create view myView as select * from v$mystat, it says 'ORA-01031:

Can someone please explain to me what exacly is the difference between
the two commands:
ALTER SYSTEM ARCHIVE LOG CURRENT;
ALTER SYSTEM SWITCH LOGFILE;

Can someone point me to site(s) or products that are built on this
thing (besides asktom, which I think is built on it)
I'd like to see something with lots of tables and interfaces.
Particularly, interfaces that don't just fill rows in a table, but

All, I must be missing the woods 'coz of the trees but here goes:
=============================================================
SQL> desc NED_PRODUCT_CARD;
Name                                      Null?    Type

I'm wondering is there any simple way to find unused oracle users for
a period of time ? ( which has not logged into the oracle database for
some period time ).
I found we could enable audit connect or create logon/logoff trigger

we have currently a multi-master replication environment where we have four
databases. Now we have to move one database to another node.
Any hints what we have to consider
Thank you in advance!

I want to use PL/SQL procedure / triggers to send an email when a new
entry is created in a table in Oracle .
Kindly suggest the logical way to do so .
Thanks and regards,

I am using Oracle 10.1.0.4 on Windows Server 2003. Today, in
production, no one could connect to database. They will just keep
waiting and may get an error:
ORA-25254: time-out in LISTEN while waiting for a message