Help! Paste Multiple SQL output result to exec command


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Help! Paste Multiple SQL output result to exec command
# 1  
Old 10-09-2009
Help! Paste Multiple SQL output result to exec command

Hi,

I want to write the shell script to change multple file name (the file name is get from DB)

e.g.
Code:
 cp db1.txt file1_new.txt
       cp db2.txt file2_new.txt
       cp db3.txt file3_new.txt

I have write the script like this:
Code:
VAR=`sqlplus -s $LOGON @<<ENDOFTEXT
  set termout off
  set feedback off
  set pagesize 0
select 'cp '||file_name||' new'||file_name from table;
exit
ENDOFTEXT `
echo $VAR
for p in $VAR
do
  echo "  command=[$p]"
done

the result is
command=cp
command=db1.txt
command=file1_new.txt
......

How can I get the expected result and run it, like this
command=cp db1.txt file1_new.txt
command=cp db2.txt file2_new.txt


Thank you very much!!!

Last edited by pludi; 10-09-2009 at 03:13 AM.. Reason: code tags please...
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Linux find command seems to not transmit all the result to the '-exec command'

Hello. From a script, a command for a test is use : find /home/user_install -maxdepth 1 -type f -newer /tmp/000_skel_file_deb ! -newer /tmp/000_skel_file_end -name '.bashrc' -o -name '.profile' -o -name '.gtkrc-2.0' -o -name '.i18n' -o -name '.inputrc' Tha command... (3 Replies)
Discussion started by: jcdole
3 Replies

2. Solaris

Exec command - different output

Hi Guys, I am trying to to execute the below script in two different machines#!/bin/ksh ############################################################################### # File : pause ############################################################################### print "\nPlease Press \033Its... (4 Replies)
Discussion started by: s_premkumar
4 Replies

3. Shell Programming and Scripting

Storing multiple sql queries output into variable by running sql command only once

Hi All, I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise. Eg : Select 'Query 1 output' from dual; Select 'Query 2 output' from dual; I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies

4. Shell Programming and Scripting

Create Multiple UNIX Files for Multiple SQL Rows output

Dear All, I am trying to write a Unix Script which fires a sql query. The output of the sql query gives multiple rows. Each row should be saved in a separate Unix File. The number of rows of sql output can be variable. I am able save all the rows in one file but in separate files. Any... (14 Replies)
Discussion started by: Rahul_Bhasin
14 Replies

5. UNIX for Advanced & Expert Users

Output the SQL Query result to a File

Hello Guys, This message is somewhat relates with last thread. But I need to re-write thing. I start over a little. I am stuck now and need your help. Here is my script- #! /bin/ksh export ORACLE_HOME=/opt/oracle/app/oracle/product/9.2 /opt/oracle/app/oracle/product/9.2/bin/sqlplus -s... (5 Replies)
Discussion started by: thepurple
5 Replies

6. Shell Programming and Scripting

How to assign the result of a SQL command to more than one variable in shell script.

Hi Friends... Please assist me to assign the result of a SQL query that results two column, to two variables. Pls find the below code that I write for assigning one column to one variable. and please correct if anything wrong.. #! /bin/sh no=' sqlplus -s uname/password@DBname... (4 Replies)
Discussion started by: little_wonder
4 Replies

7. Shell Programming and Scripting

Capturing the output from an exec command

Hi, I'm new to ksh - unix platform. I'm writing a small script which will search my current directory and will search for file names which it takes input from the users. Here is the code I'm having. 1 #!/bin/ksh 2 echo "enter a file name to be searched in the current dir : " 3 read... (1 Reply)
Discussion started by: avik
1 Replies

8. Shell Programming and Scripting

Paste Command does not align my output

I'm trying to "paste" two files but the result is not aligned. File1 looks like this: dog.csv cat.csv elephant.csv cougar.csv File2 looks like this: 2323 33 444 545545 Then I run a paste command: paste File1 File2 > result.cnt Then result.cnt file is created like this:... (4 Replies)
Discussion started by: jplayermx
4 Replies

9. UNIX for Dummies Questions & Answers

Grabbing result of sql command

Hi guys, Is there a way a script can run an SQL statement and dump the results into a variable which can then be used later in the script? Thanks. (3 Replies)
Discussion started by: hern14
3 Replies

10. Shell Programming and Scripting

any possible to run sql result and output to file

Hi, I search all post...and no soluation about..if i would like to run a sql statement and output the result to txt file. for example, i usually run "sql" to logon the database and run select statement. Then I need to copy the output into the result.txt. Can I run the script to do this... (7 Replies)
Discussion started by: happyv
7 Replies
Login or Register to Ask a Question