Recent content by jhammer98

I have noticed a slight difference in the output... the '@' produces 'H -- Hi 'H -- Hi from this script: select 'Hi' from dual; / quit When I ran it with the '<', I got the following: (notice the prompts) SQL> 'H -- Hi SQL> 'H -- Hi I don't see how this could affect the data...

To forewarn you...This is potentially a very stupid question. I'm trying to figure out why things aren't running consistently in one of my batches. While perusing the logs I've only found one difference between the several runs. The script that is producing varying results is called like...

Just to follow-up... I created the directory for the incoming files: CREATE DIRECTORY GWEST_in AS '/faprd_in/SMART/GWEST'; Then I created a seperate directory for the log and bad files: CREATE DIRECTORY EXTTABLOG AS '/cfprd/smart/cmg/exttablog'; Finally I created my external tables using...

I found this: http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:16212348050 Hope it helps... ~Jake

So far so good with external tables as long as I use the /tmp directory. Now the problem I'm having is my files are landing on an NFS mount point that the Oracle user does not have access to. I'm pretty sure oracle can read the directory but I'm afraid it cannot write the log and bad files to...

Can anybody think of any disadvantages to external tables? This is the first time I'm working with them and from my experience thus far, this will be the way I do things from now on. TIA, ~Jake

That's my next approach...Thanks Santa! Other that saving on tablespace, what are the advantages to external tables?

Hi all, I have a situation where I have 2 different fixed length flat files coming in that I want to load into a single table. The first file contains half the detail for the record and the second has the other half. Can I use an external table to hold the records if the file layouts differ...

The third option will not work because by doing it that way I would have to outer join table B to 3 different tables. The first way that I posted (with the NVL conversions) takes about 1.25 minutes to insert 110,000 records. The cursor method from BJCooper takes a little over 3 minutes for the...

Both solutions work, the NVL conversions as well as the cursor method. Now my question is which is better? At first I thought the cursors would be a better implementation because of Oracle's bulk binding capabilities. Then I got to thinking about how declaring an explicit cursor on top of an...

Perfect!!! I knew I was on the right track, I just coudn't get it into code like that. Thanks a lot!!!

Yes.

The problem updating the records in table A is all the 'join information' I need to update the records is in table C. Once I insert data into A I have nothing to join on for the update.

Hi, I have a strange situation here. I'm trying to find the most efficient and least 'costly' way to insert records into a table. Currently I am doing an INSERT...SELECT... The new data I want to add will need to be updated before it is inserted ONLY IF the incoming data is null. For...

ok...it needed some help $SOURCE had to be enclosed by 3 single quotes... execute omni_processing.delete_processed_data('''$SOURCE''','T'); Thanks for reading anyway... ~Jhammer