OraFAQ Forum: SQL & PL/SQL » Show only one of the duplicate values in a column

Home » SQL & PL/SQL » SQL & PL/SQL » Show only one of the duplicate values in a column

Sun, 07 September 2014 08:16

hahaie
Messages: 194
Registered: May 2014

Senior Member

hi,
How to duplicate values in a column is displayed only once?
(The same thing in group report).
see file attachment

Sun, 07 September 2014 08:18

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/

It can be done using sqlplus

Sun, 07 September 2014 08:22

hahaie
Messages: 194
Registered: May 2014

Senior Member

Very hard to get.
The first link
I do not code.
And the second link
I already search but could not find

Sun, 07 September 2014 08:58

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I do not code.
what do you do when you are not coding?
do you Read The Fine Manuals?

http://docs.oracle.com/database/121/SQPUG/ch_six.htm#SQPUG486

Do you speak SQL?
Do you thank folks for answering your questions?

Sun, 07 September 2014 23:02

hahaie
Messages: 194
Registered: May 2014

Senior Member

thanks,
but in address linked use BREAK ON Statment that no define in plsql oracle

Sun, 07 September 2014 23:09

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

NEVER use PL/SQL when same can be done in plain SQL.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/

Previous Topic:	Exception : No data
Next Topic:	Getting only the first occurrence of the sub string in the given string

Goto Forum:

]

Current Time: Fri Apr 26 03:08:43 CDT 2024