Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: navink123
  • Order by date
  1. navink123

    Header Record Question

    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...
  2. navink123

    Header Record Question

    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...
  3. navink123

    how to change a filename in the loop

    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...
  4. navink123

    NOT IN & NULL problem

    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...
  5. navink123

    I have a table that I need to query

    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...
  6. navink123

    how to check for a file and exit if not found

    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
  7. navink123

    how to check for a file and exit if not found

    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...
  8. navink123

    large table join problem

    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'.
  9. navink123

    large table join problem

    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...
  10. navink123

    pl/sql to delete from a large table

    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.
  11. navink123

    pl/sql to delete from a large table

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

    pl/sql to delete from a large table

    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...
  13. navink123

    Find record count of a particular value in a column in a text file

    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...
  14. navink123

    how to find the available space in database

    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
  15. navink123

    Command to delete first line from a text file

    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
  16. navink123

    Date script

    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
  17. navink123

    diaplay number of lines as a header record

    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
  18. navink123

    diaplay number of lines as a header record

    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...
  19. navink123

    prepending number of records on top of each file

    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
  20. navink123

    prepending number of records on top of each file

    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

Part and Inventory Search

Back
Top