OraFAQ Forum: SQL & PL/SQL » Reg : Comment (Drop)

Home » SQL & PL/SQL » SQL & PL/SQL » Reg : Comment (Drop)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Reg : Comment (Drop) [message #246614]

Thu, 21 June 2007 08:31

iamdurai
Messages: 96
Registered: April 2007
Location: Chennai

Member

iamdurai@gmail.com

Hi,

I have created comment on EMP table also created ename column.

creating TAB Comment Time--> COMMENT ON TABLE [schema.]table IS 'text';
Creating COL Comment Time--> COMMENT ON COLUMN [schema.]table.column IS 'text';

Is it possible to remove the comments.

My oracle version is

Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production

Reds
Thangam.

Report message to a moderator

Re: Reg : Comment (Drop) [message #246616 is a reply to message #246614]

Thu, 21 June 2007 08:39

Michel Cadot
Messages: 68719
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Set it to '' (empty string).

Regards
Michel

Report message to a moderator

Re: Reg : Comment (Drop) [message #246631 is a reply to message #246616]

Thu, 21 June 2007 09:10

iamdurai
Messages: 96
Registered: April 2007
Location: Chennai

Member

iamdurai@gmail.com

Hi Michel,

i did like is
" COMMENT ON COLUMN [schema.]table.column IS ''; "

now the column value is Null is it correct?

Reds
Thangam.

[Updated on: Thu, 21 June 2007 09:12]

Report message to a moderator

Re: Reg : Comment (Drop) [message #246636 is a reply to message #246631]

Thu, 21 June 2007 09:18

Michel Cadot
Messages: 68719
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes.
NULL means no comment.

Regards
Michel

Report message to a moderator

Re: Reg : Comment (Drop) [message #246644 is a reply to message #246636]

Thu, 21 June 2007 09:33

iamdurai
Messages: 96
Registered: April 2007
Location: Chennai

Member

iamdurai@gmail.com

Thanks Michel.

Report message to a moderator

Previous Topic:	Read Column name in select query
Next Topic:	External Table - Problem while retrieving the data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 08 19:11:11 CST 2024