Home » SQL & PL/SQL » SQL & PL/SQL » comment
comment [message #1533] Thu, 09 May 2002 07:53 Go to next message
vv
Messages: 5
Registered: May 2002
Junior Member
gurus, I have a question.
comment on table items is 'description of items';

is this a DDL command or what?
how can i call this from pl/sql? use dynamic sql?

thanks
Re: comment [message #1534 is a reply to message #1533] Thu, 09 May 2002 08:19 Go to previous messageGo to next message
vv
Messages: 5
Registered: May 2002
Junior Member
Okie.
I got the solution.!!
thread is closed
Re: comment [message #1690 is a reply to message #1533] Wed, 22 May 2002 23:58 Go to previous messageGo to next message
M.P.KIRAN KUMAR
Messages: 9
Registered: May 2002
Junior Member
hi,

comment on table is SQL * Plus command which is used to put the comments on tables or columns.
but i do not know about calling from pl/sql...
u can view the comments using
user_tab_comments for tables
user_column_comments for column names
Re: comment [message #1693 is a reply to message #1533] Thu, 23 May 2002 00:04 Go to previous message
M.P.KIRAN KUMAR
Messages: 9
Registered: May 2002
Junior Member
comment on table/column is a sql * plus command
Previous Topic: datatypes
Next Topic: Insert statement involving outer join
Goto Forum:
  


Current Time: Fri Apr 19 21:21:28 CDT 2024