Sometimes is useful to put the result into a variable and wrap up some plsql code around it:
select message_text from X$DBGALERTEXT where rownum <= 20;
Sometimes is useful to put the result into a variable and wrap up some plsql code around it:
select message_text from X$DBGALERTEXT where rownum <= 20;