search results

  1. I am running a query that results in a multiset of custom Oracle type, I\'d like to use the resulting multiset in another query and concatenate it with a VARCHAR2 field.
    stackoverflow.com/.../15278639/oracle-​multiset-to-string - Cached
  2. MULTISET informs Oracle Database to take the result set of the subquery and return a collection value. Table 5-1 shows which built-in datatypes can be cast into which ...
    docs.oracle.com/cd/B19306_01/server.102/​b14200/functions... - Cached
  3. Multiset Operators . ... The ALL keyword instructs Oracle to return all elements in nested_table1 that are not in nested_table2. For example, ...
    docs.oracle.com/cd/B19306_01/server.102/​b14200/operators... - Cached
  4. and Oracle White Papers: Oracle CAST Function: Version 11.1 : CAST With Collections: Using Multiset With A VARRAY: CAST(MULTISET(<select ... CAST With Strings ...
    psoug.org/reference/cast.html - Cached
  5. ... Thanks for the question regarding \"Coexistence of CAST/MULTISET operators and ... CREATE OR REPLACE TYPE t_string_ary2 AS ... Oracle shall not be liable ...
    asktom.oracle.com/pls/asktom/​f?p=100:11:0::::P11... - Cached
  6. The Oracle CAST function converts one data type to another. ... CAST({ expr | MULTISET (subquery) } AS type_name) ... convert string to date
    www.dba-oracle.com/t_oracle_cast.htm - Cached
  7. ORACLE CAST MULTISET. Asked by: oleggold Solved by: oleggold. Hi, I\'m trying to implement nested table and everything gooes Ok till I got to trying to populate it ...
    www.experts-exchange.com/Database/​Oracle/Q_24023208.html
    More results from experts-exchange.com »
  8. Tim Hall has the definitive collection of string aggregation techniq ues in Oracle. If you\'re stuck on 9i, ... SELECT deptno, tab_to_string(CAST(MULTISET ...
    stackoverflow.com/questions/4326868/​equivalent-to... - Cached
  9. William Robertson\'s method uses the XML features of Oracle 9.2 upwards. Each string i s transformed into a collection of XML ... ( 24 MULTISET ( 25 ...
    www.oracle-developer.net/​display.php?id=412 - Cached
  10. MULTISET « Collections « Oracle PL/SQL Tutorial . ... Character String Functions: 12. Aggregate Functions: 13 . Date Timestamp Functions: 14. Numerical Math ...
    www.java2s.com/Tutorial/Oracle/0520__​Collections/0220... - Cached