Setting the primary key of a object type table in Oracle

Posted by Rek on Stack Overflow See other posts from Stack Overflow or by Rek
Published on 2010-03-08T07:16:02Z Indexed on 2010/03/08 7:21 UTC
Read the original article Hit count: 550

Filed under:
|
|

I have two Oracle questions.

  1. How can I set the primary key of a table when the table is made up of an object type? e.g.

    CREATE TABLE object_names OF object_type

  2. I have created a Varray type,

    CREATE TYPE MULTI_TAG AS VARRAY(10) OF VARCHAR(10);

    but when I try to do

    SELECT p.tags.count FROM pg_photos p;

    I get an invalid identifier error on the "count" part. p.tags is a MULTI_TAG, how can I get the number of elements in the MULTI_TAG?

© Stack Overflow or respective owner

Related posts about programming

Related posts about Oracle