[Oracle] SQL SELECT cast to table

Pubblicata il: 8/10/2016
[Oracle] SQL SELECT cast to table
Fonte: GROGLOGS.BLOGSPOT.IT

In Oracle it is possible to cast one type to another simply by using the CAST keyword. This also applies to collections, meaning that the result of a SELECT can be casted to varray or nested table; in this case it is necessary to add the MULTISET keyword and make sure that all elements in the collection have a valid match. Eg suppose you have a type: CREATE TYPE int_list AS TABLE OF...

Continua a leggere
Notizie correlate
Commenta
FACEBOOK