Search Results

SQL*Plus:
Release
10.2.0.4.0
-
Production
Copyright
(c)
1982,
2007,
Oracle.
All
Rights
Reserved.
Usage
1:
sqlplus
-H
|
-V
-H

I cannot use those tools here :(

I have already tried it,but the problem is still the same:(


END IF;
END;
EXIT;
commit;
/
EOF`
done

I have executed it but the output sql files are not as expected.
SELECTQuery_$TimeStamp.sql is created with 0 bytes and
Query.sql ,UPDATEQuery_$TimeStamp.sql are filled with sql usage.

more...

Hi I have executed the above one the script ran with out any errors but the tables values are not updated :(.

---------- Post updated at 04:42 AM ---------- Previous update was at 04:37 AM...

I have tried in this way but getting some unexpected results can you please check if the script is fine :(

nawk '{{print $1,$2,$3}}' ./$DirectoryName/AuditGroupTableTableData_$TimeStamp.txt |...

It can be done but the .sql file should not contain statemnts other than select queries.This file will be used for another process also.So I cannot append update statements ,pl'sql code to that.
So...

I have tried this one and sorry for not replyin to that..I have another requirement...so this post :(


while read usage_id
do
echo "select usage_id,intrl_drop,intrl_err from usage_id where ...

I have an input file with contents like :

1LMXTJJD0W28TX2
1LS1XJGDEVWAC5T
1LK81JVDE2HRNDG
1LMXTJJD0W28TX2
1LS1XJGDEVWAC5T
1LK81JVDE2HRNDG
1LMXTJJD0W28TX2


I need to read each...

Hi ,
I have a query like
select err_qty,drop_qty,unbld_qty,orig_qty from usage_data;

I need to store the values of these fetched fields in variables,
Need to edit them and update the new...

Thankyou very much for the help:)

It worked fine I have got the desired result but has such msgs at the begining of result

SP2-0042: unknown command "echo off" - rest of line ignored.
SP2-0734: unknown command beginning "linesize...

This behaved the same way I have frst mentioned ,query output being replaced.
and output.txt file is created with zero byte size.

I have forgot my password for frst ID and later retrieved:)
I have tried with the one you mentioned above but it is throwing this error:

new1.ksh[36]: select: cannot execute
new1.ksh[36]:...

Can you please suggest me the change I need to do to get rid of this problem:(

Perfect !!! Thanks for the time ahamed:)
It worked fine.
You have spared lot of time for this...Thankyou verymuch:)

#!/bin/ksh
db_user=$DB_USER_NAME
db_pwd=$DB_PASSWORD
db_sid=$TWO_TASK
if [ $# -ne 1 ]; then
echo "\tUsage: MoveUsageProcessing <BC Log file Name>"
exit 1
else
BCLogFileName=$1
fi
grep -i ...

Tried with the one you mentioned,it succeeded but thrown a not found error msg:

new1.ksh 20111011.71BC.LOG
log file path is : './20111011.71BC.LOG.txt'
new1.ksh[17]: ret: not found
203969...

it is throwing this error:
[B]
ew1.ksh[17]: ret: not found
[B]

code I have used:

#!/bin/ksh
db_user=$DB_USER_NAME
db_pwd=$DB_PASSWORD
db_sid=$TWO_TASK
if [ $# -ne 1 ]; then
echo...

It worked fine with the output file,but the messages are still appearing over the screen
the code used is :

#!/bin/ksh
db_user=$DB_USER_NAME
db_pwd=$DB_PASSWORD
db_sid=$TWO_TASK
if [ $# -ne 1...

It worked but can we make the output file to contain only the query output with out unnecessary data ,
the output file contents now is :

more output.txt
SQL> set pagesize 0 feedback off...

The output file contains sql statements like:

SQL> set pagesize 0 feedback off verify off heading off echo off linesize 100
SQL> select * from bus_event where ack_party_name like...

yes it worked but with a little change,

select * from bus_event where ack_party_name like 'MOVE_USAGE_DAEMON%' and event_data_text like '%$var_ack_party_name%';

removed double quotes.
with...

Yes I have got the output in output.txt file:
contents of output.txt file is :


more output.txt
SQL> set pagesize 0 feedback off verify off heading off echo off linesize 100
SQL> ...

I ran the above with variables replaced by actual values and the output is displayed on the screen.
output is like:


SQL*Plus: Release 10.2.0.4.0 - Production on Wed Nov 23 00:26:04 2011
...