Search results for query: *

Hi Guys I want to find out how to get the following result? Table 1 col1 Col2 123 100 123 200 Table 2 c1 c2 123 189 123 190 The result I need is as following: 123 100 189 123 200 190 Can you help me with the query for this one. I tried to normal join it give...

How to find out if the FTP file is finished loading in unix. I am getting a file from different box. After I have received the file in full I want to move it to a different directory. How can I find out if ftp has finshed loading it to my box Thanks for your help

Hi I am selecting from one table which have more than 18M rows and joining it with table B which has about 1M rows. Query is like select a.row1, a.row2, a.row3, B.some_row, a.row4 from first_table a, sce_table b where a.key = b.key...

HI All I would like to cut a part of the file name I have a flat file lets say ABC12345.TXT and 2nd file name is DELL500.TXT file_name=$(echo ABC12345.TXT | sed/\.TXT//) file2=DELL500.TXT I would like to create a new name by joining some parts of both the names; I want the out put to be...

HI all Can any one please help me with this? I have a flat file. I just want to add something to its first line and not want to touch rest of the file. e.g Firstlineofflatfile20080220 010800650022000003190000000+000002ECLPSE BIG E SPEAR000022505 ^M...

Hi All I am trying to reformat a flat file but im facing a issue let me explain myself Orignal File: 010800650022000003190000000+000002ECLPSE BIG E SPEAR000022505 ^M 010800650034000003470000000+000006YORK MINT TIN 000012405 ^M...

HI All I have a fixed length flat file. I want the records in the flat file to be loaded to two different database tables based on a condition, before that I have to create two file out of one file. Let me give you an example; 01082008011300046coffee 46 02602008011987456phone 56...

Hello All, I would like to rename files. Let me example what I am trying to do. I have files coming in daily; testfile200803101_508400.ZIP.PGP testfile200703005_879850.ZIP.PGP These are example only. one thing is for sure that it will start with "testfile" and ends with ".ZIP.PGP" I would...

Hello All I got a question please allow me to explain my problem first. I have 5 files in a directory; a.dat b.dat c.dat d.dat e.dat I will like to write a script which will cp the files one by one to new file and then do some other work. so what will happen is; until file is found LOOP cp...

HI all I want to copy a file name. Please let me explain myself; filename20070824 cp filename20070824 test_filename20070824 The problem I have is that I want to use * instead of the date. I want to cp it in such a way that it keeps the name of the file and just adds "test_" at the start of...

HI Al How can I generate a track file? thanks

Hi ALL I got few columns which are varchar2(4) at the moment they have values like 01, 54, 39. in short they are two digits i want to convert them into four digits like 0001, 0054,0039. col1 col2 col3 04 39 54 57 89 99 78 56 89 convert it to : col1 col2 col3 0004 0039 0054...

Hi All How can we find out if the 3rd position and/or 4th in all the records of a flat file is space or not? e.g AB8798723498 20071201 ca94567 TC A9398js sfkji390809 20060108 JJ897987987 897897 2154863 How can we check if there is spaces or there is a character on 3rd and 4th position in...

Hi all I have a small problem Let me explain myself with an example I have a text file “test.txt” cat test1.txt D1Helloo How are you doing??? TCklsjdf9098 809809 23423298098098 909809809098 D1kkdjd098234908 9084235098345908 092838 D1230498234098 0990823...

Hello, I have a typical requirement. I have a flat file which is a fixed length one. In this flat file from 3rd position to 21st position (i.e 19 characters) is allocated for the acc #. The acc # may not be of full length. The length can vary from 10-19 characters. Now my requirement is that I...

Hi All I have flat file e.g: T18909 ij8kkjl23498 908234098 98234098 D1 89723498234098 9283j9 P3lks034982349 I to get only the first two character from every line into a variable.so, i can check if its T1, D1 or something else. How we can do it? Thanks all

Hi All! I got a small problem. let me explaing myself here. i have a flat file; ab1234567890cdefghj AB8373839112CDEFGHI MN2348897345KJSDFKL They are fixed length lines. I want to replace characters from 3rd place to 8th with 0's so my out file look like; ab0000000090cdefghj...