To discuss Oracle Forms & Reports related technical issues.
nadia
Posts: 15 Joined: Mon May 14, 2007 1:26 am
Location: Syria
Post
by nadia » Sun Mar 16, 2008 5:07 am
Hi,
I've a report query and i want to get the distinct values of each column in this query, is there a way to do this?
I've oracle 10g and reports 6i.
Regards
admin
Posts: 2063 Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:
Post
by admin » Sun Mar 16, 2008 9:19 am
Use distinct in your query,
Select distinct id, name from employees;
nadia
Posts: 15 Joined: Mon May 14, 2007 1:26 am
Location: Syria
Post
by nadia » Mon Mar 17, 2008 4:55 am
Hi,
Thanks for your reply.
I want the unique values for each column separately. The output will be like this :
IND_TIME_YEAR: 2007, 2008
IND_TIME_MONTH: 1,2,3,7,8
CON_ID: 123,234,345
GVN_ID: 098,087
Regards,
mirza_rehan
Posts: 132 Joined: Sun Apr 02, 2006 10:36 am
Location: Pakistan
Post
by mirza_rehan » Sat Apr 05, 2008 5:11 pm
Asslaam-o-Alaikum,
Nadia sorry for late reply.
please send me yours table structure and also send me report format and required columns
regards
Rehan Mirza
+971-50-1792629
Users browsing this forum: No registered users and 7 guests