How to play with set of values in Oracle?

select distinct column_value from table(sys.odcinumberlist(1,6,2,3,1,4,7,5))
order by column_value;
select column_value
from table(sys.dbms_debug_vc2coll(‘Six’, ‘Two’, ‘Three’, ‘Seven’))
order by column_value;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s