Summary: I am trying to fetch the records from oracle database and write on to xls file for that I did the following. I am trying to run the sql script from ho...
Summary: Hi, I have a file with sequence numbers in it. I want to insert few more sequence numbers from a new file checking the maximum sequence numbers availa...
Summary: I have a file (sme.txt) that contains 530,000 records. Sample 5 lines of the file: LBAB1 0000006982 11119026 01224624005 19880421 99991231 (end line) ...
Summary: Ok, I know this is the UNIX forum, but for the sake of closure here's my latest attempt at writing an oracle delete package (as opposed the shell and ...
Summary: Hi, I got the solution myself #get last record tail -2 $1/Atul_rel.txt > $1/tmp #remove space from last record sed 's/[ \t]*$//' $1/tmp > $1/tmp1 #d...
Summary: Hi. I connect with the DB Oracle usualy from an application in Developer, not in VB, but I think you need the software sql*net, from Oracle, not only ...
Summary: Hi, I have a very large file (top_03.txt), a sample of which is like this: (start) district,site,type,phone_no,revenue,duration,time,count CL,CLE88897...
Summary: Hello all, I have problems with my shell. I need to get “out” parameter from oracle stored procedure into shell display it. Please, tell me what I...
Summary: My file is unsorted, has fixed length fields with no delimiters or white space and I want to drop all records where a portion of the record (the uniqu...
Summary: Hi, I am facing some problems with the unix file system.My problem is I am fetching some records from the database and storing it in a file.the size o...
Summary: I have some records from a database. The database of course has all the field definitions and lengths so can display the data in a structured/easy to ...
Summary: 1. How to list the contain of the tape by should of tarring method? ===> tar tvf <tape device> 2. How to extract one of the file from the tape? ===...
Summary: I want to delete header and trailor record from a file. For the time being i am testing for deleting trailor record from file and then dumping the rec...
Summary: I am trying to print barcodes on an oracle report from oracle applications. I can load the barcode fonts as soft font on the printer's memory. I can d...
Summary: We have an exe which takes care of all the printing requests ,each request is assigned a print type.For printing purpose we have set up pritnt types a...
Summary: Thanks a lot! This really worked. Now another related question. Now that I got my unique key into a file, I want to take that key and go against mu...
Summary: Hi Ghostdog/nails, I still get the same error. Furthermore i just realised that I don't need to take the values following .set. Only take records from...
Summary: Hi, I have a complex shell scripting requirement. 1. I need to fetch last 7 days archived log files by querying database. 2.Then I have to compare th...
Summary: Hi, i have ksh script to fetch the data from oracle database and store the output in a .xls or .csv file. But the output having more then 70,000 rows....
Summary: I want to calculate nos of record from a text file with three coditions matched. Three conditions are appeared seperately in three line and Record sta...
Summary: Could you explain it a lil bit more what does destype and desname do? Can I invoke a script from oracle say a trigger? The world is a stage, but the p...
Summary: What is th fastest way to read and write records from a file. I am using cat input.file | while read i do echo "$i" >> output.file done Is there...
Summary: Hi, I have four files three in the following format col1row1, col2row1, col3row1 col1row2, col2row2,col3row2 col1row3, col2row3,col3row3 and the fourt...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
