SQL> set heading off
SQL> variable v_type varchar2(32)
SQL> exec :v_type := 'disclaimer';
PL/SQL procedure successfully completed.
SQL> select text from standard_text where text_type=:v_type;
The content expressed here is my own and does not necessarily reflect that of Oracle Corporation,
its affliates or clients, or anyone else for that matter. The content expressed by
visitors is their own. The content on this site is not guaranteed to be fit for any purpose
and no warranty of any kind is expressed or implied. If you choose to use any content from
this site, it is at your own risk.
Always use a non-production system to assess the
suitability of any content from this site in your environment.