Search Results

Search: Posts Made By: vikas_trl
2,306
Posted By vikas_trl
Thank you so much Stomp. This is what I am...
Thank you so much Stomp. This is what I am looking for.:b::b::b::b:
2,306
Posted By vikas_trl
Help required with Stderr and tee command
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
7,123
Posted By vikas_trl
Control not returning from Sqlplus to calling UNIX shell script.
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...
2,765
Posted By vikas_trl
RESOLVED: Help required with xargs to use sqlplus
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 &.
2,765
Posted By vikas_trl
Help required with xargs to use sqlplus
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....
2,534
Posted By vikas_trl
. /home/user/EDW_ENV.sh The . is an alias for...
. /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...
3,712
Posted By vikas_trl
If i use your code each row will go into one...
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,...
3,712
Posted By vikas_trl
Identifying columns individually in the query to...
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...
3,712
Posted By vikas_trl
Thanks for your reply. Shell is the...
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.
3,712
Posted By vikas_trl
Request: How to Parse dynamic SQL query to pad extra columns to match the fixed number of columns
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...
1,646
Posted By vikas_trl
Help required regarding variable expansion in UNIX
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...
Showing results 1 to 11 of 11

 
All times are GMT -4. The time now is 07:37 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy