viola!!

The trick is the end of the phrase has to have 4 single quotes to make it work with sqlplus. I am guessing the fourth quote matches the first quote before he delete and the other 3 quotes end the last value in the where clause.


select 'delete from OPS$ORACLE.object_baseline
where owner = ''' || owner || ''' and object_name = ''' || object_name || '''
and table_name = ''' || table_name || ''' and column_name = ''' || column_name || '''' rest of sql statement .......