This discussion is archived
4 Replies Latest reply: Nov 1, 2012 10:34 AM by sb92075 RSS

Del records from flat files

user13632611 Newbie
Currently Being Moderated
Hi all,

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. lets see

My table table structure is

desc unix_logins
Name Null? Type
----------------------------------------------------- -------- ------------------------------------
UNIX_LOGIN NOT NULL VARCHAR2(7)
NAME_LAST VARCHAR2(20)
NAME_FIRST VARCHAR2(20)
NAME_MI VARCHAR2(1)
LOGIN_CONTACT_TN VARCHAR2(12)

and abc.txt

UNIX_LOGIN
---------------------------------------
abc
bdf
fyz
rmt
lik
......

My Oracle is installed in Linux plat form. Can please suggest me how can do it.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points