Home » SQL & PL/SQL » SQL & PL/SQL » Reg : Comment (Drop)
Reg : Comment (Drop) [message #246614] Thu, 21 June 2007 08:31 Go to next message
iamdurai
Messages: 96
Registered: April 2007
Location: Chennai
Member

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.
Re: Reg : Comment (Drop) [message #246616 is a reply to message #246614] Thu, 21 June 2007 08:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Set it to '' (empty string).

Regards
Michel
Re: Reg : Comment (Drop) [message #246631 is a reply to message #246616] Thu, 21 June 2007 09:10 Go to previous messageGo to next message
iamdurai
Messages: 96
Registered: April 2007
Location: Chennai
Member

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 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes.
NULL means no comment.

Regards
Michel
Re: Reg : Comment (Drop) [message #246644 is a reply to message #246636] Thu, 21 June 2007 09:33 Go to previous message
iamdurai
Messages: 96
Registered: April 2007
Location: Chennai
Member

Thanks Michel.
Previous Topic: Read Column name in select query
Next Topic: External Table - Problem while retrieving the data
Goto Forum:
  


Current Time: Sat Dec 10 18:47:16 CST 2016

Total time taken to generate the page: 0.05353 seconds