Apr-21-2022, 04:36 PM
I have a file:
cat file1.txt cel01 cel02 cel03 cel03I have a Oracle DB cursor that brings some values from to variable VAL_CEL1.
cursor_fgnmaes.execute("select distinct failgroup from v$asm_disk")I want to exclude all entries found in file1.txt from cursor query , something like:
cursor_fgnmaes.execute("select distinct failgroup from v$asm_disk where failgroup not in [ALL_LINES_FROM_FILE]")How can I do that? I tried opening file and read line per line but did not work.