Shell Programming and Scripting

sqlplus user/pwd@DEV
for i IN (select * from table)
loop
-- for every record I need to switch to UNIX and move the files to some directory.
end loop

> ./destfile.shl

# here document for sqlplus code:
sqlplus user/pwd@DEV <<-EOF
set serverout on size 1000000
spool destfile.shl
DECLARE
  fname varchar2(256):=NULL;
BEGIN
dbms_output.enable(1000000);
for i IN (select fname from table)  --or whatever you need to do to get a resultset
loop
    dbms_output.put_line( '/usr/bin/mv '||fname||  ' /destination/some/directory ');
-- for every record I need to switch to UNIX and move the files to some directory.
-- no you do not
end loop
END;
/

EOF

# now execute all your commands
# READ destfile.shl for errors first then run destfile.shl
#
# ./destfile.shl  uncomment for production.