927851 wrote:But there does not seem like any use of escape characters in the query you posted. You are you trying to achieve. Can you be clearer on your requirements?
Is it possible to use multiple special characters using ESCAPE opeartors.
select * from mak
I want to display all the records in single select query. Is it possible? Please advice.
This range of characters is the set of Non-Keyboard (non-printable) characters.
set define on; set escape on '\'; with data as ( select 'some_data' col from dual union all select 'some ^ data' col from dual union all select 'some % data' col from dual union all select 'some \& data' col from dual union all select 'some!data' from dual ), inp_chr as ( select '&i' inp from dual ) select * from data, inp_chr where instr(col, inp) > 0;