79427587

Date: 2025-02-10 15:45:57
Score: 3
Natty:
Report link

This works as a general query, not sure about in PL/SQL with an INSERT INTO, but it should work:

SELECT nvl((SELECT data FROM table WHERE id = 'thisone'), 'NULL') FROM dual;

Reasons:
  • Low length (1):
  • No code block (0.5):
  • Unregistered user (0.5):
  • Low reputation (1):
Posted by: Graham