Search Results

Thank you so much Stomp. This is what I am looking for.:b::b::b::b:

Hello All,

I have a requirement to redirect stdout and stderr to 'log' file and stderr alone to 'err' file.

Can someone please help me with this?

Thanks in advance

Hello All,

I have a UNIX script which will prepare anonymous oracle pl/sql block in a temporary file in run time and passes this file to sqlplus as given below.



cat > $v_Input_File...

Thankyou very much Aia. You solved my issue. :b::b::b:



Thanks RudiC for your reply. I know xargs runs the parallel jobs in background, but i don't want to do it myself using &.

Hello All,

I have a requirement in which i need to run few Oracle sql files in parallel.
I want to use xargs command [I don't want to use & and send the job to background] to achieve parallelism....

. /home/user/EDW_ENV.sh
The . is an alias for Source command. This will execute the above file in the same process as the shell file that is calling above file. Since these two files run under the...

If i use your code each row will go into one array element. But how can i know how many columns are there in the sql query actually?

For example if we consider below row, how can i select col1,...

Identifying columns individually in the query to load into array is the problem I see here. Because I need to pick some delimiter for identifying columns. I can not choose ',' or 'AS' as they are...

Thanks for your reply.

Shell is the preferred. Because we are planning to use this script to work across multiple databases. But please provide PL SQL code also if you have any.

Hello All,

I have a requirement in which i will be given a sql query as input in a file with dynamic number of columns. For example some times i will get 5 columns, some times 8 columns etc up to...

Hello,

I have one variable coming from one file:
abc=$xyz/filename.txt where $xyz is defined in .profile file as say, /usr/dev/src

i am passing abc variable to one perl script as input...