4 Replies Latest reply: Nov 1, 2012 12:36 PM by Brian Bontrager RSS

    Del records from flat files

    user13632611
      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.