Hi,
using unix shell scripting we are retrieving records(4 columns) from table and seems that one of the column data is coming as "harry potter & hermione granger","potter&harry" ..etc., by taking these values as a parameter and pass it to another table to insert these records. whenever we are inserting these records scripting is failed. Could you please help me out.
Here data is coming dynamically to a particular column and we use that column as one variable and those variable we are passing it to a insert statement. All these things will do in unix environment.
In oracle directly we have to use escape charater(\) and based on that we can insert the records.
Thx in advance