It is urgent, because i need to modify one big file which contains near about 50,000 records. For which i need to put quotations marks and commas and then i need to use those records in one sequel statement which is very urgent for me. That is why i mentioned it is urgent.
I'm not a moderator so it's no big deal :) Just as a suggestion, you might want to post the real issue when you say something is Urgent in the subject line. I imagine many of us try to look at a posting quickly if someone marks it urgent. If people mark postings as urgent when they are not, it may lead people to start treating Urgent posts like any other which would be a shame. Also, you probably would have gotten a better answer to your real question. You probably don't need "Unix Commands" for this problem. You probably need to look at something like awk or sed.
Are you saying that you have a text file that you need to insert some delimiters around to bring the file into the database? If it's not in a fixed-length format and the data isn't uniform then that's probably going to be an issue. If you
can email me a sample of 40 or 50 rows I'd be glad to take a look and help you out if you haven't resolved the issue already. Send the file to Oracle_8_DBA@hotmail.com
Senior Database Administrator
For your requirement,you can use like this
This command will work like this starting from 1st line to the end of the file(last line), 's' for substitutes, (next dollar sign $ means) end of each line substitute double quotes and g for globally.
Hope this helps you.