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: 649
        
I have two Oracle questions.
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
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