OraFAQ Forum: Server Utilities » questions and answers on oracle 9i sql

Home » RDBMS Server » Server Utilities » questions and answers on oracle 9i sql

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

questions and answers on oracle 9i sql [message #72926]

Tue, 16 December 2003 06:29

seyi ojo
Messages: 1
Registered: December 2003

Junior Member

pls sir 'am presently under going my ocp training and i and i'll be doing my exam next year pls i need assistance from you in terms of questions and answers on oracle 9i sql

Report message to a moderator

Re: questions and answers on oracle 9i sql [message #73809 is a reply to message #72926]

Fri, 16 July 2004 10:07

fadi
Messages: 5
Registered: March 2004

Junior Member

hi
i have a problem when i install oracle 9i on my computer when i start the oracle 9i setup i got an error from the windows xp the error message is :-

setup.exe has encountered a problem and needs to close. We are sorry for the inconvenience.

and i dont know what is the problem exactly , i try to reinstall windows xp , but i got the same result pls help me pls

Report message to a moderator

Re: questions and answers on oracle 9i sql [message #73869 is a reply to message #72926]

Tue, 27 July 2004 18:42

devarajan
Messages: 1
Registered: July 2004

Junior Member

how to select the second max sal of the particular worker in a particular department with name,depcode, sall fields (give me sql query)

Report message to a moderator

Re: questions and answers on oracle 9i sql [message #73937 is a reply to message #73869]

Thu, 05 August 2004 03:04

Krish
Messages: 13
Registered: November 2001

Junior Member

select name,max(sal),depcode
from employee
where sal <> ( select name,max(sal),depcode
from employee)
group by name,sal,depcode;

Report message to a moderator

Re: questions and answers on oracle 9i sql [message #73943 is a reply to message #72926]

Sat, 07 August 2004 00:00

fadi
Messages: 5
Registered: March 2004

Junior Member

hi
i just wana ask if there is a procedure builder in
oracle 9i , as in previous version of oracle and
if exist , how can i find it ???

thanks bye

Report message to a moderator

Previous Topic:	Import tables Alpha to Windows
Next Topic:	HELP! sql*loader control file - date formatting

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 17:12:09 CDT 2024