Show value from DATA_DEFAULT field
Show value from DATA_DEFAULT field
(OP)
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:
SELECT DATA_DEFAULT
FROM USER_TAB_COLUMNS
WHERE TABLE_NAME = 'MyTable'
AND COLUMN_NAME = 'MyColumn'
or
SELECT DATA_DEFAULT
FROM ALL_TAB_COLUMNS
WHERE TABLE_NAME = 'MyTable'
AND COLUMN_NAME = 'MyColumn'
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?
SELECT WHAT?
FROM ALL_TAB_COLUMNS
WHERE TABLE_NAME = 'MyTable'
AND COLUMN_NAME = 'MyColumn'
I know my TABLE_NAME and COLUMN_NAME and the default value for that field is a character 'A'
When I do:
SELECT DATA_DEFAULT
FROM USER_TAB_COLUMNS
WHERE TABLE_NAME = 'MyTable'
AND COLUMN_NAME = 'MyColumn'
or
SELECT DATA_DEFAULT
FROM ALL_TAB_COLUMNS
WHERE TABLE_NAME = 'MyTable'
AND COLUMN_NAME = 'MyColumn'
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?
SELECT WHAT?
FROM ALL_TAB_COLUMNS
WHERE TABLE_NAME = 'MyTable'
AND COLUMN_NAME = 'MyColumn'
---- Andy
"Hmm...they have the internet on computers now"--Homer Simpson
RE: Show value from DATA_DEFAULT field
DATA_DEFAULT is the correct column, but it appears your tool is hindering you. Try the same query using SQL*PLUS in text mode and you may get better results.
Unfortunately, data_default is a LONG datatype and those can be difficult to deal with.
RE: Show value from DATA_DEFAULT field
Yes, TOAD was messing up my output
When I did it in my code, everything is working just fine
---- Andy
"Hmm...they have the internet on computers now"--Homer Simpson