Home » SQL & PL/SQL » SQL & PL/SQL » Query needed
Query needed [message #239444] Tue, 22 May 2007 07:39 Go to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member

Dear friends,

Am a new guy in this forums.This is my first forum and new guy to oracle.
I have two tables :

DEPT:

deptno

10
20
30
40


and

EMP:

empno deptno
---------------
1 10
2 10
3 20
4 20
5 30
6 30
7 40
8 40


i expecting the output below:

empno deptno
-----------------
1 10
2
3 20
4
5 30
6
7 40
8

Expecting Your replies..better and best.
Any body help me..
pls urgent help me..
Regards,
Arun..
Re: Query needed [message #239448 is a reply to message #239444] Tue, 22 May 2007 07:48 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
akkumar81

Any body help me..
pls urgent help me..



Are you drowning?!?

Use BREAK SQL*Plus command.
Re: Query needed [message #239468 is a reply to message #239444] Tue, 22 May 2007 08:21 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
We already answered you to this point.

Regards
Michel
Previous Topic: TO_CHAR masks for decimal numbers
Next Topic: Open a file of any type stored in long raw field.
Goto Forum:
  


Current Time: Sun Dec 04 11:00:23 CST 2016

Total time taken to generate the page: 0.04529 seconds