Home:ALL Converter>Usage of REF datatype in Oracle

Usage of REF datatype in Oracle

Ask Time:2015-06-29T13:50:07         Author:LockStock

Json Formatter

I'm trying to understand how the REf datatype works. I gather from the Oracle documentation that REF is some type of pointer to an object. This is how I tried using REF:

SQL> create type roo as object (
  2   a number,
  3   b REF roo);
  4  /

Type created.

SQL> create table yoo ( a roo );

Table created.

How do I now insert values into the table yoo ?

Author:LockStock,eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/31108641/usage-of-ref-datatype-in-oracle
yy