Search Results

How can we run shell script every one hour.
Anyone having code unit for this?

But I want to update the row with full string

The thing is I want to udate a row with clob value ,
Sqlldr will only insert a row

Hi all,

I am reading control file log from my server and putting it to a variable
for j in $(cat $dirname/ctl_file.log)
do

if [ -n $j ]
then
Y=${#fileclob_ctl_file}
if [ $Y =...

Its like
20140521122301

where its YYYYMMDDHHMISS format..

I tried date -d $substring2
but this doesnt take the mins and secs

Hi all,
I have date and time value in a string,
I want to check if it is a valid date and time.

Need help on this.

Thanks

Hi All,

My control file looks like:
LOAD DATA
APPEND
INTO TABLE MK9210_PROD_DL.MK9210_PROD_EG_6
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS
(
STUDY CHAR
,PATIENT INTEGER EXTERNAL
,CPEVENT...

Hi,

I have text file as EG.txt

the file content is like:

CACZ885M2301|1569009|MONTH0|ERT|7001455|SUPINE|12
CACZ885M2301|1569009|MONTH0|ERT|7001455|SUPINE|12...

Actually I don't want full log file
I just want the records loaded n number of records rejected

Hi all,
I'm loading data in database through sqlldr.
I want to know the total record count
And the number of records inserted in table..
what is the logic to achieve that.

Thanks

entry_data_control=`sqlplus ${sysuser}/${syspwd} << EOSQL
whenever sqlerror exit sql.sqlcode;
whenever oserror exit failure;
INSERT INTO...

hi all,

In first run,I am inserting a row into an oracle table through shell script,
in the same shell script when I query this table the count comes as 0.

When I run the same script again...

:) thanks it worked

---------- Post updated at 04:43 AM ---------- Previous update was at 04:38 AM ----------

I am inserting :
timestamp=`date +"%Y%m%d%H%M%S"`
value of timestamp into a date...

Hi All,

I'm using below code

entry_data_control=`sqlplus ${sysuser}/${syspwd} << data_control
whenever sqlerror exit sql.sqlcode;
whenever oserror exit failure;...

I thought it can be done using AWK

processId is any number: the output is like:

8742
N
these are the values returned by 2 select queries

cant i do it frm single sqlplus

Hi all,

I'm using below code

processId=`sqlplus -s ${sysuser}/${syspwd} <<CHK_PROCESS
whenever sqlerror exit sql.sqlcode;
set head off feedback off echo off pages 0
...

I used terminated by clause
It worked :)

sqlplus ${sysuser}/${syspwd} << EOF > ctl_file.ctl
WHENEVER SQLERROR EXIT FAILURE;
WHENEVER OSERROR EXIT FAILURE;
set longchunksize 200000 long 200000 pages 0 head off...

The table column is of type CLOB..

I had to add this:
set longchunksize 200000 long 200000 pages 0
Now its working for me..

Now I want to get this clob value to a shell variable , ao am...

Hi All,

The value of a column in my DB table is:
LOAD DATA
APPEND
INTO TABLE MK9210.EG
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS
(
STUDY CHAR
,PATIENT CHAR
,CPEVENT CHAR
,NAMEG CHAR...

Hi ,

I am using below control file
LOAD DATA
APPEND
INTO TABLE LSHADMIN.EG
TRAILING NULLCOLS
(
STUDY CHAR
)

and the text file to load data is

CACZ885M2301

When I run below...

Could u pls show the syntax..
How can I check if it ran in parallel or not