|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Sql query output to ksh arrays
day_table table contains data like
12-May-2005 15-May-2005 10-Jun-2005 27-Jun-2005 02-Dec-2005 30-Dec-2005 I want to assign these values to a 2D array and later use them 1 by 1. I am doing following, but its not working... set -A days `sqlplus -s $MMUSER/$PASSWORD@$ORACLE_SID <<EOL SET HEAD OFF SET FEEDBACK OFF SELECT start_date, end_date FROM day_table; EXIT SQL.SQLCODE; EOL` i=0 while [ $i -lt ${#days[*]} ] do print ${days[$i]} (( i=i+1 )) done Can anybody help me out? |
![]() |
| Viewing: Dev Shed Forums > Operating Systems > UNIX Help > Sql query output to ksh arrays |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|