Visit Our UNIX and Linux User Community

Search Results

Search: Posts Made By: Pratiksha Mehra
2,318
Posted By Pratiksha Mehra
Shell script to be run every one hour
How can we run shell script every one hour.
Anyone having code unit for this?
1,606
Posted By Pratiksha Mehra
But I want to update the row with full string
But I want to update the row with full string
1,606
Posted By Pratiksha Mehra
The thing is I want to udate a row with clob...
The thing is I want to udate a row with clob value ,
Sqlldr will only insert a row
1,606
Posted By Pratiksha Mehra
Error inserting a clob file into DB table
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 =...
8,442
Posted By Pratiksha Mehra
Its like 20140521122301 where its...
Its like
20140521122301

where its YYYYMMDDHHMISS format..
8,442
Posted By Pratiksha Mehra
I tried date -d $substring2 but this doesnt...
I tried date -d $substring2
but this doesnt take the mins and secs
8,442
Posted By Pratiksha Mehra
Check if a string is a valid timestamp in UNIX.
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
2,319
Posted By Pratiksha Mehra
Problem loading default date column in sqlldr
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...
3,590
Posted By Pratiksha Mehra
Hi, I have text file as EG.txt the...
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...
3,590
Posted By Pratiksha Mehra
Actually I don't want full log file I just want...
Actually I don't want full log file
I just want the records loaded n number of records rejected
3,590
Posted By Pratiksha Mehra
Number of rows loaded via sqlldr
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
878
Posted By Pratiksha Mehra
entry_data_control=`sqlplus ${sysuser}/${syspwd}...
entry_data_control=`sqlplus ${sysuser}/${syspwd} << EOSQL
whenever sqlerror exit sql.sqlcode;
whenever oserror exit failure;
INSERT INTO...
878
Posted By Pratiksha Mehra
Inserting a row using shell
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...
7,003
Posted By Pratiksha Mehra
:) thanks it worked ---------- Post updated...
:) 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...
7,003
Posted By Pratiksha Mehra
Querying v$session table
Hi All,

I'm using below code

entry_data_control=`sqlplus ${sysuser}/${syspwd} << data_control
whenever sqlerror exit sql.sqlcode;
whenever oserror exit failure;...
1,692
Posted By Pratiksha Mehra
I thought it can be done using AWK
I thought it can be done using AWK
1,692
Posted By Pratiksha Mehra
processId is any number: the output is like: ...
processId is any number: the output is like:

8742
N
these are the values returned by 2 select queries
1,692
Posted By Pratiksha Mehra
cant i do it frm single sqlplus
cant i do it frm single sqlplus
1,692
Posted By Pratiksha Mehra
SQLPLUS command with more than 1 select statement
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
...
952
Posted By Pratiksha Mehra
I used terminated by clause It worked :)
I used terminated by clause
It worked :)
1,857
Posted By Pratiksha Mehra
sqlplus ${sysuser}/${syspwd} << EOF >...
sqlplus ${sysuser}/${syspwd} << EOF > ctl_file.ctl
WHENEVER SQLERROR EXIT FAILURE;
WHENEVER OSERROR EXIT FAILURE;
set longchunksize 200000 long 200000 pages 0 head off...
1,857
Posted By Pratiksha Mehra
The table column is of type CLOB.. I had to...
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...
1,857
Posted By Pratiksha Mehra
Selecting a value of column through sqlplus
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...
952
Posted By Pratiksha Mehra
SQLLDR :Data not loaded completely
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...
583
Posted By Pratiksha Mehra
Could u pls show the syntax.. How can I check...
Could u pls show the syntax..
How can I check if it ran in parallel or not
Showing results 1 to 25 of 38

 

Featured Tech Videos

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