We are trying to create a sql which will create a script of
partitions to compress which are older than a certain date. That information
is kept in High_value. When displayed high_value looks like this
TO_DATE(' 2017-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS',
'NLS_CALENDAR=GREGORIAN')
So the first thing we did was to query where high_value like
'TO_DATE%'. We got an invalid character error. Long story short, we
discovered that high_value's data type is long. There must be a way to
translate this into text. SQLplus, Sqldeveloper, and TOAD all do that. The
question is how do they do it? Does anyone know how it is done?
Thanks,
Liz