hi fellows,
can any body tell me how to pass unix variables to oracle
code is... #! /bin/ksh echo ENTER DATE VALUE's read START_DATE END_DATE sqlplus xyx/abc@oracle select * from table1 where coloumn1 between $START_DATE and $END_DATE;
is this is correct way...........
Thanks in advance
....by searching the forums for 'sqlplus' [to start with]?