Member Avatar for hillol

hi
i m very new to shell script.
my prob:
i have a dat file and a database table(oracle).
one column of that table and dat file is same.
i want to replace another column of that table matching the value of the column of the table with that of the column of that file.
i want to do it ina shell script using sqlplus.
how can i do it?

is it possible to use shell variable within sqlplus?

  • 2 Contributors
  • 1 Reply
  • 236 Views
  • 14 Hours Discussion Span
  • Latest Post Latest Post by jim mcnamara
Member Avatar for jim mcnamara

The short answer is "yes". If you give an example of the data then we can help you.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.