Help! Paste Multiple SQL output result to exec command


Login or Register for Dates, Times and to Reply

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Help! Paste Multiple SQL output result to exec command
# 1  
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 for Dates, Times and to Reply

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

Test Your Knowledge in Computers #218
Difficulty: Easy
A peer-to-peer network sets all connected computers equal and all connected computers share the same abilities to use resources available on the network.
True or False?

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

Featured Tech Videos