Search results for query: *

It is not an homework :-). I am an oracle developer trying to work on unix platform. The data file(2nd file)is being generated by an oracle query. But while ftping this data file to the target system we need to ftp another file also which is going to contain a header record with the...

Hi Guys, I need to display the following information in a file. This file is going to contain only one record which is displayed by running query on another file(2nd file). DATE is the date 2nd file created, TIME: time 2nd file created, RECCNT : # of records in 2nd file. BLANK: 17 black...

Hi Guys, I am using a script to insert a record count on the top of a text file. But now the source file has changed and the new files are in a compressed format. So I will have to uncompress each file attach the record count as header and compress it back. I tried to do something like this...

I have to extract data from a table using a query as follows select * from table A where A.somecoulmn NOT IN(select anothercolumn from b) AND (..........); The problem I have is that, in table 'A' 50 % of the rows have Null values for column 'somecolumn'. So the above query pulls only the...

I have a table that I need to query based on a column. The column contains two types of values. First type has the first character as alphabet and then numerals. The second type has all numerals. I need to query the table based on this first character. I tried to use substr(column,1,2)not...

Hi ernieah, Thanks for the answer. Can you please post the other example as well. its always better to have more than one options. U never know which may work better. Thanks, N

I have a job that runs everyday. It looks for a file in a particular directory and takes it as an input file. This file is generated by some previous job. Sometimes this previous job does not run depending on various conditions that are unable to predict. But then my job still looks for that...

Can you please tell me how I can join table 3 to table 1. In table c, I have to pull out the records which match with the ssn in table a and filter only those which has the somecode coulmn as '0'.

Hi, I have 3 tables table1 a, table2 b and table3 c as follows a.ssn a.name1 a.name2 a.addr1 a.addr2 a.addr3 a.city a.state a.zip b.somenumber c.somecode I have to pull the data from above 3 tables. I have to match the records based on the column 'ssn' which is present in all tables. The...

SantaMufasa, I agree with Dagon. Aren't we committing after every 10000 deletes at a time. I am still confused where the commit is going to be. Can you please explain, if what you said is true, how is it so. Thanks, N.

Thank You Dagon, But where are we doing the commit in this script. Or does it automatically commit with every loop. Thanks, N

I have a large table from which I need to delete all the data and reload it again. I do not have a truncate table right on this table. When I try to do a delete on the table, I run into rollback space errors. Somebody suggested me to use a pl/sql and do frequent commits. I have not used pl/sql...

I have a large data file. I need to find how many records in a particular column had a specific value. e.g. Its a third column in the file and the position of the column is 30 to 34. The values in the column is a combination of 1's and 0's like 10000 11010 11111 00000 01111 How can I find the...

I want to load data from dat files into a database. But before that I want to make sure that there is enough space in the DB to hold the data. How do I find the space in the database. Thanks, Navin

I have a large text file. The first line of this file is the record count of that file. What would be the command to delete this line from the file. It is a very large file. So I cannot open it in vi and delete the line. Thanks Navin

I need a script to pull yesterday's date each time when I run it. Right now I have mydate=`date '+%Y%m%d'`. But it pulls todays date. How can I pull the date of the day before. Thanks, Navin

Forgot to paste the script Thanks, Navin The existing script is as follows: for file in * do lines=`wc -l $file` ( echo "Lines in file = $lines" ; cat $file ) > tmp$$ mv tmp$$ $file done

Hi Guys, I am extracting data from a table and putting it into a number of text files. While doing this I am displaying the number of records in the file, on the top of the same file as a header record. I am using a modified version of the following script posted by Dickiebird to achieve this...

Thanks Salem, This is exactly what I wanted. But the script prepends the # to only one file in the directory. How can I display the # in all files in the directory. Thanks, Navin

I am extracting data from a table and putting it into a number of text files. While doing this, I need to find out how may records are extracted into each file and display it on the top of the same file as a header record. Anybody has idea how to do this, Thanks, Navin