Search Results

Got it :)
Thanks a lot!!!!

I had pasted only a part of the data in my previous post, sorry abt it

This is the actual data in the file

0049DA06152009FPA06USD 000000000000D000000000009.9 ...

This is a sample data from the file test123.dat

0049DA06152009FPA06USD 000000000000D000000000009.9

If i use awk '{if(substr($0,65,1)==" ")sub(substr($0,65,1),"9");print}'...

Hi
I'm trying to use awk in a file(test123.dat).
My requirement is to to check for the 65th position, if the 65th position is a space then replace the 65th position by the number 9.

This is...

$ /dba58/d037/staging/sqlplus
/dba58/d037/staging/sqlplus: cannot execute
$ /dba58/d034/app/oracle/product/920/bin/sqlplus
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found...

I know the database instance which I am trying to connect to.
Is there a way available which I can use to exactly findout the location of sqlplus which i shld use to connect

/opt/PSscripts/clone/scripts/.0.6_BAK/bin/sqlplus
/opt/PSscripts/clone/scripts/.0.6_BAK/sqlplus
/dba58/d001/app/oracle/product/816/bin/sqlplus
/dba58/d001/app/oracle/product/816/sqlplus...

$ cd /usr/oracle
/usr/oracle: does not exist

Prev the .profile has only following contents
# This is the default standard profile provided to a user.
# They are expected to edit it...

$ cd $ORACLE_HOME/bin
/usr/oracle/bin: does not exist

This is what I get when I try to do as u suggested....

anyother way???

I am trying to connect to Oracle Databse from UNIX box using sqlplus command. But i get sqplus not found message.

$ sqlplus
sqlplus: not found

I have searched in forums and all are...

It Worked :) !!!
Thanks a lot!!!

Hi vgersh99!!!

I tried with command that you've given
awk '{printf("%23.16f\n", sprintf("%.2f", $6-1))}' xxx_yyy.hrv | head -5 | tail -1

but i get the output as
220730.7099999999991269
...

Hi

I'm using awk to manipulate the data in the 6th field of the file xxx_yyy.hrv.

The sample data that is available in this field is given below
220731.7100000000000000

When i tried using...