Search results for query: *

Awesome thanks!!! It works!

Hi, I have two tables (TABLE1 and TABLE2) and they have 3 columns that are the unique key in each. These unique columns are the same in each table. My question/issue is how to get the records in TABLE1 NOT IN TABLE2??? I did a manual check and I know there are 2 records in TABLE1 not in...

Hi, I'm getting the Field in data file exceeds maximum length. Is there some limit that I'm unaware of??? The column it is failing on is VARCHAR2(4000). The data file is pipe delimited and the file it is failing on is only 260 characters??? I'm confused on why I'm getting this error... has...

Cool Thanks PHV for your help!!!

PHV, So, if I have multiple files... I just keep increasing the numbers? sed '2,/BEGIN 3RD FILE/d;/END 3RD FILE/q' main.dat > 3.dat

Annihilannic, I was curious if you could please explain the file name creation... When I run it, I was wondering where it gets the name. I tried with different names, i.e. BEGIN ACCOUNT| END ACCOUNT| BEGIN PCC| END PCC| The file names are P for the PCC and ACCOU for the ACCOUNT?

Wow... fast replies!! Thanks for your help. It works!!!

Hi, I have a data file like the following: BEGIN 1ST FILE| 1|2|3|4|5 6|7|8|9|10 END 1ST FILE| BEGIN 2ND FILE| A|B|C|D|E F|G|H|I|J END 2ND FILE| BEGIN 3RD FILE| .....ETC.... Is there a way to extract the data just for the 1ST File and then 2ND File and etc...? I need to ouput the 1ST FILE to...

Thanks, it works!!! Greatly appreciated!

Hi, I have a table that has the following: LEVEL_ID CHAR(2) LEVEL_DESC_TX VARCHAR2(240) LEVEL_CAT_TX VARCHAR2(240) The data file contains a pipe delimited file: 1|FIRST LEVEL| 2|SECOND LEVEL| 3|THIRD LEVEL| ...etc... The LEVEL_CAT_TX field, I need to merge the contents of the...

Awesome! Thanks for your help... You saved me lots of coding. :)

Oracle 8i Hi, I have an issue on how to extract data from a single table that stores the data for different levels of a Hierarchy in the same columns. Here's an example: PARENT_VALUE CHILD_VALUE 100 200 100 300 200 ABC 200 DEF 300 ZZZ...

Thanks for your help!!!

Hi, I have a data file (input_file.dat): BEGIN DATA EXTRACT 1|AUG-05|10002|2260388115.38|-4151079.23|2256237036.15|0|0 1|SEP-05|10002|2256237036.15|-4612568.24|2251624467.91|0|0 1|AUG-05|10002|1843860115.32|61745489.54|1905605604.86|0|0 1|SEP-05|10002|-488569233.24|0|-488569233.24|0|0 END DATA...

Thanks for all your help, greatly appreciated!!!

Just to clarify... the file is created on a unix server and we transfer it to another unix server.

There is an extract process that creates the file. When that file is created it has the control characters. Then we FTP transfer the file over to another unix server via a bin transfer. I just tried the FTP again with an ascii transfer and the control characters are still there? I just...

Hi, I have a data file that contains Control Characters: A|TEST^M B|TESTING^M ...etc... Is there a way to remove the Control Characters in the data file via a ksh unix script? Thanks for your time.

I found a solution: SET ESCAPE ON SET ESCAPE "\" test_tx := 'Test one \& two'; It works!!! yeah.

Hi, In PL/SQL, the & is used to a variable holder. So, if you tried to make a variable like: test_tx := 'Test one & two'; it asks for the value of two when trying to execute the code. Is there a way to make PL/SQL accept the text as is? So, basically ignoring the & so that the text keeps...