DSXchange

He meant "factors" rather than literally "parameters". Sqlldr isn't a magic bullet that makes any load faster, you need to determine if it is applicable depending on the nature of the load being performed. And how to improve any bulk load would be a good conversation to have with...

Can you guide me what are the steps to be take to get rid of this special character. The first step is always identification. If you don't see anything "special" in the source file using the methods already listed, show us what the character is in your Oracle table. You can use the Oracle...

I agree... and done.

Ding ding ding!

pandeesh wrote:By default , green means success and red means aborted. But I don't agree with that. I feel it should be universal.

Out of curiousity, what would "universal" colors be for success and aborted for you? To me, that would be... green and red.

Is the "B" column defined as a CHAR? If so, what is your $APT_STRING_PADCHAR environment variable set to?

They're definitely Oracle partitioning algorithms.

If I understand it correctly , you are trying to parameterize a function ...Suppose you have rule table which gets populated & depending on the value , you need to either A + B or A - B or A * B . Here the operand between A , B is parameter . Not really sure how you drew that conclusion from th...

... hence the 'at the moment' part.

Since what's under the covers is no longer Universe, uvsh was depricated and replaced by dssh. However, there is no difference between the two that I am aware of and both are still supported at the moment.

we are using trim(col). I need to parameterize the trim and get the function in run time. e.g something like TRIM_PAR(col). I'm withholding comment until I understand what the above is supposed to achieve. Right now I don't see the point, so much like Ray I'm looking for a better, more concrete exa...

No, it's not. Re-read Ray's post, specifically point #3. Those are representations of a single character, not a "^" character followed by an "@".

Off we go to where I think this belongs based on your posting history.

We know what it holds, Ray asked for the actual value in the field - 1, 25, eleventy-seven? This to validate how it was being 'multiplied'. And best to resolve the posted problem before moving on to other issues (which really should be in a separate post) rather than treating this as a long, run-on ...

abhilashnair wrote:How can I pass output of a SQL query as parameter in a job

It would help if you clarified what exactly it is that you are asking. This SQL output and 'parameter' - are you speaking of the same job that is running the sql? Or another, downstream job?