For like we have %. for ex: if we give ad% it ll fetch all the records which starts with ad but i should use regexp_like. for regexp_like what can be used so that it acts as % for like. i cant use ^ad because from UI we ll give something like ad* to fetch.
Before query:select * from employee where fname like 'pr%';
Present query:select * from employee where fname regexp_like 'pr+';
for present query i m getting the values which contains pr but i want to get values which starts with pr.
Testdata: if pr* is given then i should get program etc i.e the value which starts with pr.