Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Multiple distinct

662385Nov 3 2008 — edited Nov 4 2008
I wish to Have many cols with the distinct function attached in one statement if possible, I think the closest to this may be the union but it is all returned in one column. any possibility that you can get it to show in multiple columns? eg i have(animal col) dog dog cat (house number col) 13 23 17 21 23 so they show dog cat in one col 12 23 17 21 and the numbers in another
I am using oracle 11g

Comments

Iloon Wolff-Oracle
Hi,

Have a look at: http://htmldb.oracle.com/pls/otn/f?p=20297:13:3512503096593871
611580
Thanks iellen, Thanks a lot for this. But it seems that i need to learn some sophisticated ajax or javascript for this. ;)

Can you give any idea on identifying all rows which are getting updated while i'm updating one or more records in the report?

Thanks for your help.

-Sudipta
Iloon Wolff-Oracle
I found an example for you
http://www.inside-oracle-apex.com/2006/11/generic-solution-for-depending-select.html

Kind regards,
Iloon
Denes Kubicek
If you want cascading select lists in a tabular form, there is no way arround javascript and ajax. See this example:

http://apex.oracle.com/pls/otn/f?p=31517:176

Also, for knowing which records get updated you should use checksum. I have a number of examples regarding this issue here:

http://apex.oracle.com/pls/otn/f?p=31517:170

Denes Kubicek
-------------------------------------------------------------------
http://deneskubicek.blogspot.com/
http://www.opal-consulting.de/training
http://apex.oracle.com/pls/otn/f?p=31517:1
-------------------------------------------------------------------
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 2 2008
Added on Nov 3 2008
18 comments
14,927 views