Show value from DATA_DEFAULT field 1

ALL_TAB_COLUMNS (or USER_TAB_COLUMNS) describes the columns of the tables, views, etc.

I know my TABLE_NAME and COLUMN_NAME and the default value for that field is a character 'A'

When I do:[tt]
SELECT DATA_DEFAULT
FROM [blue]USER_TAB_COLUMNS[/blue]
WHERE TABLE_NAME = 'MyTable'
AND COLUMN_NAME = 'MyColumn'[/tt]

or
[tt]
SELECT DATA_DEFAULT
FROM [blue]ALL_TAB_COLUMNS[/blue]
WHERE TABLE_NAME = 'MyTable'
AND COLUMN_NAME = 'MyColumn'[/tt]

I do not see the default character 'A', I see (in TOAD):


I can double click on (WIDEMEMO) (whatever that is) and I can see the default value for that column:


What would be the SQL to get the 'A' (the actual default value) of the field in my table?

[tt]SELECT [red]WHAT?[/red]
FROM ALL_TAB_COLUMNS
WHERE TABLE_NAME = 'MyTable'
AND COLUMN_NAME = 'MyColumn'[/tt]

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson