SELECT Ename FROM Db
WHERE UPPER(Ename)='A BC';
samir pradhan
Last Activity: Jul 31 '12, 06:35 AM
Joined: Jul 26 '08
Location:
-
hi
subtract the "date of birth" from "sysdate" to get the age and then find out who is eldest.Leave a comment:
-
to view the user:
sql> show userLeave a comment:
-
Hi Priyanka.
i m confused that u got the error while installation.
as i know
ORA-00922 Missing or invalid option, causes due to syntax error.
specifying a maximum length on a date or long datatype also
causes this error.
or like Yew12's case where Yew12 was trying to create the ROOM table first before creating PROPERTY table also causes this error.
...Leave a comment:
-
Hi. I have a suggestion for u.it may work.
If u have already installed oracle9i and forms 10g remove both from ur system.
after that first istall forms 10g ,then install oracle9i.
during 9i installation specify or SID as "orcl".
after complete installtion of both
Replace the contents of listener.ora which is located at $ORACLE_HOME\ne twork\admin\lis tener.ora with the text below.
...Leave a comment:
-
what u want to do ?
u have already created a table having a person column of person_type and u want to insert some data in it
or u want to create a table having a person column of person_type ?
plz clarify.Leave a comment:
-
How to connect oracle 9i database & developer suite ?
Hi Everybody. I am new in this forum.
can anybody help me to explain the connection procedure of oracle9i database and oracle 10g developer suite ?
Thanx
No activity results to display
Leave a comment: