title: view the values for unsupported data type in oracle
body: <p>I have created a type including a map member function in Oracle live. </p>
  
  <pre><code>select value(r),r.rid
  from rectangle r;
  </code></pre>
  
  <p>When I executed the above one it will display [unsupported data type] as the value(r) column output. How I can view the real data in it? Because that value is important in map member function to compare.</p>
  
  <pre><code>create type rectangle_t as object(
    rid varchar(2),
    lengths number,
    width number
  );
  ALTER type rectangle_t add map member function area return number cascade;
  create or replace type body rectangle_t map member function area return number is
    BEGIN
      return self.lengths*self.width;
    END;
  END;
  create table rectangle of rectangle_t;
  INSERT INTO rectangle VALUES('a',10,5);
  INSERT INTO rectangle VALUES('b',20,10);
  INSERT INTO rectangle VALUES('c',5,2);
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/pDAGE.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/pDAGE.jpg" alt="enter image description here"></a></p>