Search Results

sorry arun, am not getting your point

Hi All,

I am asking this question again here because seems like i am doing some mistake in unix part. please help me what i need to do now on this, why am facing issue, it is passing variable, but...

Hi Junior,

I have modified my script like this

and file has below content

'324324324'
'232423434'
'232424444'
'234324444'


UNIX SCRIPT

d=`paste -sd, file.txt`
sqlplus -s...

Hi Junior,

thanks a lot,

can you also help me how i can put single quotes with the help of sed command in each record

like this

'3423432432432'
'2343243243243'
'3243243242343'


if...

HI Junior,

Thanks, i pasted here because they peoiple told me to put in sql forum, that is why i pasted same question here again.

appreciate if you let me know how what sed command is doing...

i have file in which i have employee id are there and every time number of employee id are different in file means number of count of employee id in file are every time different.
343535435 ...

Hi All,

am getting confused, please let me know how i can do this

how
in_put number :-nvl('&1',0) can take all values from file.

---------- Post updated at 06:01 PM ---------- Previous...

HI Rudic,

Appreciate, if you just little bit explain me this program.

---------- Post updated at 04:46 PM ---------- Previous update was at 02:52 PM ----------

HI Rudic,

i trying to...

i have oracle

---------- Post updated at 04:03 PM ---------- Previous update was at 03:51 PM ----------

Hi Ditto,

We have passed $file_count variable to .sql file.

what does this command...

Hi Rudic,

is this command, can i read some tutorial on this, please let me know where i can study this, i did google, not getting anything on this.

HI Rudic,

what does
($(paste -sd, file))


do.

but how i can call this in .sql, how $filecount replace in .sql file

select * from tablename where acc in (
45456546456, 45464564565, 67854353454, 67657612132)

Hi Friend,

I have one file in which some number are mentioned and number of lines are vary every time

And i need to pass that number to my sql command from script.

Suppose i have file...

appreciate if you can explain me this little bit

---------- Post updated at 01:26 PM ---------- Previous update was at 01:26 PM ----------

or is there any way we can store current time and we...

Hi Corona,

U mentioned sleep $SECONDS, but u did not declare this variable in above, what is that, can you please explain me this code more

sorry dear but i have also not perl, is there not any variable calucaltion method

Hi,

I have no GNU command

---------- Post updated at 11:29 AM ---------- Previous update was at 11:19 AM ----------

and i have aix system and it did not work there

Hi Drl,

i can not use at, cron facility. that is why i use sleep command

I need help in script.

I want my one script execute every time at 6:30 am and i have no cron access.

So i am putting sleep command there , Script may took half an hour 35 min , it depend upon...

what -- this is doing in front of uc

i agree when export found it become uc =2 as per condition

then

uc && ! (-- uc )
2 && ! (how uc becomes 1 here as per ur condition )


while...

sorry Rudic, i did not get first command execution, appreicate if you can explian me more for this special

uc&&!--uc

HI All,

I have one file like this


export count
------------------
0
src_sys max rec(upd_dt)
----------- -------------
bkba 30-oct-2014
hjbs 30-oct-2014


i have...

thanks a lot, can you please help me where i can learn these such topic, i want to go through in detail,

i have ran script and looks like it is working, but i need to check with my manger...

sorry chubler, can you please explain in brief.
&& c=\\"$c"


"${v/$c/}"

HI chubler,

i remove that character also, still same output.

---------- Post updated at 06:48 PM ---------- Previous update was at 06:47 PM ----------

and also please let us know what this...