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: 582
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