or maybe you can try this sql:

  • select decode(instr(banner, 'Enterprise'), 0, 'Standard Edition', 'Enterprise Edition') from v$version where banner like '%Oracle%'
    /