Search Results

hi all,

i have a for loop statement in my ksh code. it only returns the first value retrieved not the value for the other rows.

ex: acct_id value = returned value in the for loop
1 ...

hi all,

i am experiencing an error which i think an incorrect syntax for the where clause passing a variable was given. under is my code.

sqlplus -s ${USERNAME}/${PASSWORD}@${SID} << END1 >>...

Hi All,

I want to format the retrieved varchar2 value in the database to $9,999,999,990.00 but remained as a character value. Is it possible?

Example: 378273.23 to $378,273.23

below is the...

thanks pludi and bakunin. the solution you gave worked :)

Hi pludi,

thanks for replying, i do what you had said giving this input:

sqlplus -s ${USERNAME}/${PASSWORD}@${ORACLE_SID} <<EOF

but the same error still occurs

Hi all,

I'm trying to run an sql inside a loop which looks like this

#!bin/ksh
while IFS=, read var1 var2
do

sqlplus -s ${USERNAME}/${PASSWORD}@${ORACLE_SID} << EOF
insert into...

just go to this link https://www.unix.com/newthread.php?do=newthread&f=30

Hi all,

Does anyone know how to code in ksh that will remove the first character in a string variable and replace that variable without the first character?

Example:

var1=ktest1 will become...

Thanks for the help. I got the solution. I only removed the space in the coding from appointmentDate[recordNumber] = $(echo ${appointmentDate[recordNumber]}|sed -e 's/\"//g') to...

I have a korn shell code here on a while do statement which replace the string stored on an array removing double quotes characters on it but it doesn't work.

example record: appointmentDate[1] =...