If I have an entity Student and there is an attribute DOB holding the
student's date of birth, how can I calculate his age today in years and
months?
Have been trying this but can't seem to get the syntax right.

I am trying to add second database in oracle 10g on windows 2003 server
but when ever i am trying to issue Create Database MYDBName .... it
gives an error. database name do not match orcl.
Please help me to create database using create database statement not

Can anyone please advise of a good method for creating a 'library cache
pin' wait event in order that I can test out some scripts I have to
capture information.
The only way I currently have of doing this is (as per Metalink):

Oracle Corporation has won summary judgment in a significant patent
infringement suit concerning its clustered database software. The
ruling ends the proceedings against Oracle but allows Oracle to proceed
on its claims that MangoSoft's patent is invalid and unenforceable.

I recently installed Oracle 101.0.4 with cpu oct 2005 patch on it. I am
creating a new database instance using dbca.  Do I need to apply catcpu
after new instance is created or dbca installation scripts with
automatically pick it up.

Hey OMLET guy, OracleXG, Amjad, Madasgar Schnootz, Lil, or whatever
else you're going by right now.
I just wanted to give all these professionals you've bashed a chance to
know better who you are.  Some of them you have committed severe

La Di Da Di, we likes to party
We don't cause trouble, we don't bother nobody
We're, just some niggaz who're on the mic
And when we rock up on the mic we rock the mic (right)

I'm also a programmer, as working in front of computer day and day, my
right hand is so tired and get some pain. So I tried to mouse in both
hands. I find that it is really an efficient way to release pains. At
first I switched the mouse buttons in windows control panel, but it

I wonder what needs to be done to uninstall streams from the d/base? Do
I just drop the user (strmadmin)?
Thanks,
Eugene

Hi Gurs,
Does oracle have anythink equalent to TANDEM ( Non Stop SQL ) whree the
trasanction never fails.

In 8.1.7.4, we've been experiencing very annoying locks that completely
block many sessions, every time we try to define a mat. view that
performs
a join against 4 tables. In V$LOCK suddenly lots of sessions appear

I've read conflicting thoughts about indexes and foreign keys.
One train of thought has it that you always create indexes for all foreign
keys.  The other train of thought said that not all foreign keys really need
an associated index.

following situation:
Oracle-Versions: 8i, 9i, 10g
Database-Server: Solaris 9
Backup-Server: Redhat AS4; Kernel 2.6.9-5.EL

i am a beginner in oracle forms 10g and pl/sql
(sorry , unfortunately my english languge is weak)
i have a problem  , please help me
i want to set an icon on push button in oracle 10 g

          We can enforce primary key constraint by using both unique
and non-unique index. I want to know when to use unique index and when
non unique.
Thanks in advance.