New answers tagged

0

SELECT q'{error detail : &ERROR_DETAIL }' FROM DUAL;


0

SQL> SELECT 'error detail : ' || &ERROR_DETAIL from dual; Enter value for error_detail: 'the field x.y is mandatory' old 1: SELECT 'error detail : ' || &ERROR_DETAIL from dual new 1: SELECT 'error detail : ' || 'the field x.y is mandatory' from dual 'ERRORDETAIL:'||'THEFIELDX.YISMANDATORY' ----------------------------------------- error ...


0

It would be a waste of time using an index when you ask for all rows of a partition. Also, searching for 'LOA' in a varchar2(2) column has little chance of success.


Top 50 recent answers are included