New answers tagged oracle-11g-r2
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