# pick-list does not work within a builtin function

**URL:** <https://forums.toadworld.com/t/pick-list-does-not-work-within-a-builtin-function/29485>\
**Category:** Toad for Oracle - Beta\
**Created:** [March 26, 2014, 11:25am UTC](https://forums.toadworld.com/t/pick-list-does-not-work-within-a-builtin-function/29485 "2014-03-26T11:25:41Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![droeschley\_109](https://avatars.discourse-cdn.com/v4/letter/d/9f8e36/32.png) [@droeschley\_109](https://forums.toadworld.com/u/droeschley_109)\
**Post date:** [March 26, 2014, 11:25am UTC](https://forums.toadworld.com/t/pick-list-does-not-work-within-a-builtin-function/29485/1 "2014-03-26T11:25:41Z")

</div>

SELECT min(oq.  
FROM qa3.outbound\_quote oq

Pick-list will not work when using a function such as MIN. Using .50 beta. This works in 12.1

---

<div class="post-metadata">

**Author:** ![Dennis\_Paulus](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/dennis_paulus/32/138_2.png) [@Dennis\_Paulus](https://forums.toadworld.com/u/Dennis_Paulus)\
**Post date:** [March 26, 2014, 11:48am UTC](https://forums.toadworld.com/t/pick-list-does-not-work-within-a-builtin-function/29485/2 "2014-03-26T11:48:09Z")

</div>

I see this too - thanks. I’ll create a CR for it.

**From:** droeschley\_109 [[mailto:bounce-droeschley\_109@toadworld.com](mailto:bounce-droeschley_109@toadworld.com)]

**Sent:** Wednesday, March 26, 2014 2:26 PM

**To:** [toadoraclebeta@toadworld.com](mailto:toadoraclebeta@toadworld.com)

**Subject:** [Toad for Oracle - Beta Discussion Forum] pick-list does not work within a builtin function

**[pick-list does not work within a builtin function](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/21677.aspx)**

Thread created by droeschley\_109

SELECT min(oq.

FROM qa3.outbound\_quote oq

Pick-list will not work when using a function such as MIN. Using .50 beta. This works in 12.1

To reply, please reply-all to this email.

[Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/21677.aspx?subscribe=false) on this subject.

Or [  
Unsubscribe from Toad for Oracle - Beta](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86.aspx?subscribe=false) notifications altogether.

Toad for Oracle - Beta Discussion Forum

[Flag](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/21677.aspx?AbuseContentId=8e1cb569-5509-40d0-83af-e15165b289bb&AbuseContentTypeId=46448885-d0e6-4133-bbfb-f0cd7b0fd6f7&AbuseFlag=true)  
this post as spam/abuse.

![](http://gyk.r.mailjet.com/o/04j0/f3470b5d/3g2iy86e.gif)