OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Oracle Query

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

Oracle Query [message #372857]

Wed, 14 March 2001 05:28

Seema Sinha
Messages: 1
Registered: March 2001

Junior Member

Hi Oracle champs,

Can you help me in writing this query. There is a dept and an employee table as in SCOTT/TIGER.

I want an output like this using sql statement

Dept Name Employee Name
Sales Jim
Joe
Kinsy
EDP Smith
Farhens
John

.......

Seema

Report message to a moderator

Re: Oracle Query [message #372862 is a reply to message #372857]

Wed, 14 March 2001 14:46

Joachim Lindner
Messages: 30
Registered: February 2001

Member

At the SQL*Plus prompt type BREAK ON Dept_Name before executing your statement.

Report message to a moderator

Re: Oracle Query [message #372868 is a reply to message #372857]

Wed, 14 March 2001 23:42

Thirumalai Prakash
Messages: 6
Registered: March 2001

Junior Member

Try this query

select d.dname,e.ename from scott.dept d,scott.emp e where d.deptno=e.deptno group by d.dname,e.ename

S.Thirumalai

Report message to a moderator

Previous Topic:	varchar2
Next Topic:	ERROR-MESSAGE 20955 / 21408

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 16 11:08:25 CDT 2024