Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to use LIKE operator for passing the filename parameter for concurrent program

3173025Jan 29 2018 — edited Jan 30 2018

Hi,

I have a concurrent program with one parameter (p_file_path)

For this, i need to pass the file path using LIKE operator,means it should consider which are having like ;AA%' from particular path. eg: /utldata/inbound/AA_20180130.csv

Lets say, i have a file in this path as: /utldata/inbound/AA_20180130.csv

Can we pass parameter using LIKE operator either in SQL*loader program OR concurrent program parameter, say it should pick files which starts with 'AA_%' from that path. Lets assume only one file will be there in that path.

Could some one help me on this.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 27 2018
Added on Jan 29 2018
#sql-pl-sql
3 comments
990 views