i have object type
create or replace type header_o object( col1 number, col2 number, col3 number);
then create table
create table tab1( id number, header header_o);
so want make comment on header.col1
when try
comment on column tab1.header.col1 'comment goes here';
oracle raises missing keyword.
how can make work?
oracle comments on column of object type table
no, cannot. oracle doesn't support feature.
from documentation, add comments to:
- table, view, or materialized view
- indextype
- operator
while, trying add comment object type. add comments table column.
for example,
sql> create or replace type header_o 2 3 object 4 ( 5 col1 number, 6 col2 number, 7 col3 number) 8 / type created. sql> create table tab1 2 ( id number, header header_o 3 ) 4 / table created. sql> comment on column tab1.header 'comment goes here' 2 / comment created.
Comments
Post a Comment