Verify Database 32/64 bit creation

to check  database been created originally in a 32-bit environment and is now on a 64-bit platform

select decode(instr(metadata, 'B023'),

              0,

              '64bit Database',

              '32bit Database') "DB Creation"

  from kopm$;