Like Operator is not working in oracle view -

Like Operator is not working in oracle view -

i have created view in oracle. fetch info view. have written sql query. query not working not having specific condition. if give status query executes. problem not occurring if joined same number of tables (that used create view) instead of using view. in next giving oracle query.

select * "920_search_report" lm_culture = '7aacb509-271d-4aca-e040-e00adea40aae' , hand_person_info_guid = 'eebd4257-7856-4c6e-b6b8-9b886e89e397' , ( lower(handicap_type) lower('%dq871j%') or lower(skskodenr) lower('%dq871j%') );

the above query executes , returns 1 record if omit or comment 3rd line query not homecoming records, should homecoming 1 or two. query given below:

select * "920_search_report" lm_culture = '7aacb509-271d-4aca-e040-e00adea40aae' --and hand_person_info_guid='eebd4257-7856-4c6e-b6b8-9b886e89e397' , ( lower(handicap_type) lower('%dq871j%') or lower(skskodenr) lower('%dq871j%') );

can help me solve problem.

oracle view