Search Results

As per my understanding your requirment is to pick all the files from log.txt which have .c extension and then need to compare them with file_list.csv.If this exists then store them in another file.

Hi,
May be i m wrong but try this
I think in the firstline of command ` is missing in end.
Put it and try u'll definetly get desired answer.


file_list=`sed 's\,\ \g' file_list.csv`
for file...

Thanks a lot .Itz working.You are real genius.I have leart a lot from you.
If you don't mind will you please send me the discription of the code.

Hi AIGLES
Thanks for your response.
I had made a little change in input too.I am posting here both input and output.



ALTER TABLE tbla
ADD ( cola1 VARCHAR2(11),
cola2 VARCHAR2(12)...

I need to do all the modification in previous code.

Here firstly i need to check whether
the table exits or not.If exists then searching for line having "ADD constraint" and
need to...

Hi aigles

Thanks for the help.I need one more favor.I have modified the code according to my need but now need to add one more condition.while we are searching for line having "add"can we do...

Hi everyone,
I have a script in which i need to add some codes.Right now my scripts takes table name from i/p file data.txt then matches it with data in another file table.if table exists then it...

Thanks alot AIGLES.its working now.

hi
i have used /usr/xpg4/bin/awk and nawk
in both cases getting error.

---------- Post updated at 08:00 AM ---------- Previous update was at 07:53 AM ----------

hi i have used your code...

hi Aigles,
sorry for troubling you.
but still the code is bailing out near line containing "getcols".

No i have not tried use /usr/xpg4/bin/awk or gawk till now.
i don't no how to use these applications.

Hi Aigles,
Thanks for the reply.
still giving the same error.

Please help me with this.

hi its not working with nawk

---------- Post updated at 04:11 AM ---------- Previous update was at 04:01 AM ----------

hi Gathrit

I have tried it but still the same problem


awk '...

hi Aigles,
thanks for your reply but i am getting errot while executing your code.please help me with that.

awk '
NR==FNR { tbl[$1]++ }
/ALTER TABLE/ {
tbl_name = $3;
getcols =...

Hi everyone,

I have n number of data in my file "temp" in following order.In each line table_name and
column_name are different.input data is in same format each query in three lines.

ALTER...

hi all
i have two files in unix
1.table.name
2.all.tables
i need to check the availability of all data of table.name in all.tables.both the table contains n number of data.i need a script which...

i have tried that earlier but its a single string fields are not seperated.
one more thing by using sed command i can store the extracted table names in new file by using redirection operator.

hi ashwin but the strings in my file is in one field.i need to extract the table_name from each string where this is between alter table add add.then i need to store the extracted data in a file.i...

thanks a lot for the help.
can we do it using awk.

hi
I have posted it earlier but i was unable to put my exact problem.This time posting in parts.
I have a text file which i had transferred to UNIX.It has strings like:

alter table table_name...

hi guru
i have no problem in sql part .the only problem is to read data from the file.i need to extract all the table names between alter table and add.there is no field separation it's a single...

hi
MY requirments are:
1.to read data from a txt file which i had transferred to UNIX using FTP.
for eg: my file contains many lines of data like "alter table tablename add(column name)".
2.Now...

Hi all,
I am new in this field
I need to write a script to read a data from txt file.My file contains data in the form of many lines.I need to read the lines which contains "alter table table_name...