Search Results

Hi All,

I have a requirement to make a oracle concurrent program end with
warning based on a given condition. If the condition is true, the
concurrent program should end with completed...

Hi Corona688,

I did the cat ~/.ssh/id_rsa.pub | ssh user@remote.machine.com 'cat >> .ssh/authorized_keys2' when prompted for the remote machine's password, I keyed in the password.
But it...

Ho Corona668,

Thank you for the reply . I followed the steps in the article that you mentioned to the point where I must run the command
ssh-copy-id -i ~/.ssh/id_rsa.pub username@mystery

But I...

Hi All,

I am trying to transfer a file from one server to a remote server using SFTP. Client is not ready for key setup.
I am working on Solaris 10.
Here is the code.

#!/bin/ksh
# sample...

I am trying to find all the oracle forms that have text item invoice_id in Solaris ( SunOS 5.10)

If I use

grep -i -l 'invoice_id' *
I get only those oracle forms that have 'invoice_id' in...

Thank you everyone for the prompt reply.
I changed the delimiter in the sed command to # and it worked.
Thanks again
Megha.

Hi All,

Following is my issue.

$MAIL_DOC = test.txt
test.txt contains the following text .

This process was executed in the %INSTANCE% instance on %RUNDATE%.

I am trying to execute the...

Hi DGPickett,

I am facing this issue when I try to display the value of the sql query from the korn shell. even if its userdate or sysdate .

this is my code
VALUE=`sqlplus -s /nolog...

Hi Cero,
Thank you for the reply.
Yes. I am very sure on that part.When I run the query in sqlplus , I get the userdate in the format that I am using in the query. ie, MMDD . I do get a value .
I...

Still no luck . Am not sure why the process is unable to display the value.
Please let me know what I am missing here.

Thanks
Megha

Hi

The tried the above and I still get the same output.
MMDD is
The value is not being displayed.

Thanks
Megha

Hi All ,
I am trying to pass a value from sqlplus to korn shell .
There is a table tab1 in Oracle that has a column userdate.
I need to pass the userdate to the korn shell . This is what I am...

Hi Coronoa688,

Thank you for the reply. I am on SunOS 5.10
I have this in a korn shell script
USERDATE=$1

echo "Script parameter User date = $USERDATE"
The output is Script parameter User...

userdate=$1
echo "Script parameter user date = $userdate"I tried this and get blank values for month and day

echo "2012/09/19 00:00:00" |awk -F"[ /:]" '{print "Month:"$2"\nDate:"$3}'I also tried...

Hi vidyadhar85

Thank you for the reply.
But it does not display the month and day .
I get blank values.
Please let me know if I am missing something here.

Megha

Hi All ,

I am trying to extract the day and month from a user supplied date . But not able .
Please help .
This is what I am trying to do , I have followed other articles in this scenario.
...

HiCorona688

I do agree with you but I am developing a script that handles exceptions like these just in case.

Thanks everyone.

Megha

Hi Team ,

Is there a way I can check to see if the same file say , test.dat exists multiple times in the directory path ?

Please help.

Thanks
Megha

Thank you Vbe.

I am running the shell script from the Oracle apps concurrent manager. Will that make any difference?

Hi

The command is

cat <path of the pdf file> | /usr/bin/acroread -toPostScript | lp -d <printer name> -n2 -o uncollate

How to use code tags...

The OS is SunOS 5.10
I am using lp -d <printer name> -o uncollate -n2.

The uncollate option if it works , will resolve my issue. But its not working.

As there are 4 pages in the pdf and I...

Hi

I have a pdf file that is being generated using the rwrun command in the shell script.
I then have the lp command in the shell script to print the same pdf file.
Suppose there are 4...

Hi ,

I have a data file in this format.


p1 p2 p3
10 0
10 0 1000


I am using a sqlloader script to load the data into the database table.There is a unique constraint on the columns...

Thank you so much durden_tyler.
But I forgot to mention something. Apologise for not mentioning it before.
table1 that I referred to in my example is not a table. Its a cursor .I am getting data...

Hi All ,

I have two tables. I will provide sample data in the tables below.

table1:


dept_id dept_name rep_id admin_lastname
10 dept of int.medicine Paul
10 dept of int.medicine...