Hi,
i'm using SQL*Loader to load oracle tables.. can i please know whether I can use shell scripting inside a .ctl file 'coz the infile name will be always changing every 15 minutes. So i need to dynamically create the infile name which I can do it in shell scripting. Given below is what i'm...
hi,, what i'm trying to do is if the number is less than 10 , I want to add a zero before it.. like, if it is 9 output should be 09.. and i'm using c-shell.. can you pls help me out ?
Am trying from y'day.. but this following switch case is not at all working.. problem is if i give this multiple choice for "case" its not working.. it just works when i give just one value for "case"... your help appreciated...
Switch Case problem....
switch ($month)...
hi, i need to load a table using sqlloader every 15 minutes.. and the thing is the infile's name will be changing every 15 minutes but with a definite format like xyz_20020709_1015.txt,xyz_20020709_1030.txt etc..
can you suggest me a way for loading the table ? is it possible to invoke sqlloader...
Hi,
I've a C Shell script inside which I do a ftp to a site. Is there any way of taking the PID of that ftp process alone 'coz when I tried to take the PID, I could just get the PID of this script alone. I used $$ to take the PID. Thanks in advance.
Hi,
Can I know how to get the previous date ? Now I'm using like,
currdate=`date +%Y%m%d`
ydate=`expr $currdate - 1`
this was working fine till y'day(10-31-2002) but today e'thing gone wrong 'coz
currdate returned 20021101
and ydate returned 20021100 but...
Hi TDATGOD,
Thanks for your awesome reply... Actually I'm new to Unix Shell Scripting.. Can you please clarify me some doubts in ur script.... Sorry if I am disturbing you again..
Doubt 1 :
the following line gives syntax error saying
Error message : if: Expression syntax...
Hi,
I've a C Shell Script running every 15 minutes which opens a ftp session and downloads files from remote site. But sometimes the ftp session hangs up due to network delay or anyother reason and the session remains open. But after 15 minutes another ftp session opens according to my...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.