This content has been marked as final. Show 4 replies
I have a text file abc.txt, i want to delete records from a table take the input from the txt file from linux operating.
It's not clear what you mean. Do you want to delete records from a table if those records exist in a txt file?
You can create an EXTERNAL TABLE on the text file and then use that 'table' in a query that deletes records from your table.
See this Oracle-base example of creating an external table on a text file
DELETE FROM myTable where LAST_NAME in (SELECT NAME_LAST from myExternalTable);
Create an external table which uses abc.txt as its source (syntax to do so can be looked up in the documentation).
delete from unix_logins a where a.unix_login in (select b.unix_login from abc_external_table b);