If you have this in a Tcl file:
oraparse $cur {
delete from ELLIPSE.MSF096
where STD_TEXT_CODE = 'SC'
and STD_KEY in (select STOCK_CODE from ELLIPSE.MSF100 where
STOCK_CODE not like 'DW%')
and rownum < $batch
}
The "096" on MSF096 is highlighted as a number as well as the "100" on
MSF100. Some check should be made that the number isn't embedded in a
string.
Robert
_______________________________________________
Scite-interest mailing list
[email protected]
http://mailman.lyra.org/mailman/listinfo/scite-interest