Search Results

Thank you Cero, I had doubts that there is a way somewhere to do this. but it's clear as there is no way for such actions.
Would like to thank all participants once again, Thank You!

Tyler_durden, this is requested by the DBA team, using bind Variable is preferred in continuous operation that user variable Bind Variables ...

Using this way
echo "SELECT ename from emp where empno = $i;"'\n'will pass the empno as value, I was looking to pass it as sql bind variable which looks like
echo "SELECT ename from emp where...

Bartus11, Amazing...
Thank you ahamed101 I just wanted to grep the line where Bartus11 line solved it.

Hello,

I have a log file with many lines and I want to grep pcific values from spcific lines, I'm not sure if it is possible or not

Sample
16-11-11 19:54:13:INFO:Connection to device ip...

Thank you durden
the last part of code is what I was looking for, but there is another issue now. using this way will use the sql bind variables.

I still need to use bind variables from oracle...

Sorry but it is not clear to me at which point in the first code you are opening the connection.
Kindly repeat it marking the line for opening the connection.

That's too much close to what I'm looking for,
The only point left is i do need to open the connection one time for each array

is it possible to wave
connect user@database/password
to be...

Hi Felipe,
every line of code helps, I'm learning from great ideas that are being shared here.
May be it is my mistake that I didn't clear my point earlier but I'll try to explain more my issue
...

Sorry for pushing, but they are many files that must be parsed in array using advanced grep for each file and then load it to sql.
Writing them in files mean extra diskspace and better file...

thank you itkamaraj for the immediate response, I'm trying to find a way to do it in one connection.
is it possible to pass the shell array to an sqlplus array and loop on the sqlplus array itself?

Dears,
Newbie here and tried to search this topic for 3 days now with results.
I have a shell array and I want to use it in sqlplus with one connection.

here is what I have for now
...