DB Help - Removing text between two characters!!

[nittu02]

Hi, am using Oracle,

 

And i need a biggg help from any of you DB Gurus. I have some values in a column in the DB, which goes something like this:

[03-Jan-2008 21:53(GMT) Username] Test for notification

[03-Jan-2008 21:53(GMT) Username] Initialization

 

Each row will contain the first part [03-Jan-2008 21:53(GMT) Username] multiple times. My problem is that i need to remove this from the row while displaying, so that it will appear like this:

 

Test for notification

Initialization

 

How do i remove everything between the [ and ] ???

[vinays84]

Code:

SUBSTR(dbColumn,INSTR(dbColumn,']',1,1)+2)

[nittu02]

Thanks, but that will remove only the first ] right? I have multiple phrases like that..

[vinays84]

What does one value of the DB column look like?

That means the value of that column for only one row.