Search Results

Ok, let me describe the requirement again and that is copy the files from one location to another and rename the copied files.
Source location and names to rename the files comes from SQL query....

Actually report_path is the location where pdf report is saved on server. i have to copy it to /opt/report folder. As report name is with id so i will rename with report_name.
through SQL, path and...

#!/bin/sh
. /opt/ora/oracle/db/tech_st/11.2.3/PROD_darwin.env
#sqlplus -s "apps/apps" << EOF
no=$(sqlplus -s apps/apps<<EOF
set heading off
set feedback off
Select ...

now after removing $ script output shows Query results. but variable report_name and report_path shows blank. below is the output.
[oracle@darwin ~]$ . /home/oracle/scripts/test2.sh
SP2-0734:...

#!/bin/sh
. /opt/ora/oracle/db/tech_st/11.2.3/PROD_darwin.env
#sqlplus -s "apps/apps" << EOF
no=$(sqlplus -s apps/apps<<EOF
set heading off
set feedback off
Select ...

#!/bin/sh
. /opt/ora/oracle/db/tech_st/11.2.3/PROD_proddb.env
sqlplus -s "apps/apps" << EOF
no='sqlplus -s apps/apps<<EOF
set heading off
set feedback off
Select ...

#!/bin/sh
. /opt/ora/oracle/db/tech_st/11.2.3/PROD_proddb.env
sqlplus -s "username/password" << EOF
no='sqlplus -s username/password<<EOF
set heading off
set feedback off
Select ...

#!/bin/sh
sqlplus -s "/ as sysdba" << EOF
SET HEADING OFF
SET FEEDBACK OFF
Select
pt.user_concurrent_program_name , OUTFILE_NAME
FROm
apps.fnd_concurrent_programs_tl pt, ...

Hi,
for your queries blow is the response.
Is this homework/assignment? There are specific forums for these.
This is assignment
What have you tried in your script so far?
Well, i am new...

Hi,

I require help to complete below requirement through Linux Script.

I have a SQL query which shows two columns as output. One is Report Name and other is report path. Query return multiple...