Sponsored Content
Top Forums UNIX for Advanced & Expert Users Problem while calling Oracle 10g SQLPLUS files Post 302115991 by jim mcnamara on Monday 30th of April 2007 02:08:09 PM
Old 04-30-2007
Code:
tablename="TAB"
spoolfile="myfile.txt"
sqlplus user/pwsd -s<<EOF
spool "$spoolfile"
select * from "$tablename";
exit
EOF

Here document.
 

7 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

oracle 10g

I have download Oracle 10g for Solaris and I have configurate environment than I will start runInstaller and I have a messege that my version of solaris is not 5.7 , 5.8 and 5,9 I have 5.10 Solaris version what I shoud do I have download most actuall Oracle databases. (4 Replies)
Discussion started by: Deux
4 Replies

2. Solaris

Oracle 10G installation on Solaris 9

Hi Guys, I need to install Oracle 10g on solaris 9, the server is not in cluster. The server is already running applications like OVO and Weblogic. Can you guys please tell me the steps to do this and what paramaters ( Kernal and otherwise) which need to be modified? There will be about 100... (2 Replies)
Discussion started by: nitinkgoud
2 Replies

3. UNIX for Advanced & Expert Users

problem connecting to oracle 10g after NCR node reboot

Hi All, I am facing a connection problem with Oracle 10g on Solaris 10 when my application (started by /etc/rc3.d at node reboot) tries to establish a session after reboot of the node where my application is running (NCR UNIX (MP RAS)). I find that my application (run as a deamon process)... (1 Reply)
Discussion started by: sowjanya
1 Replies

4. AIX

oracle 10g on AIX 5

hi can anyone help me by telling step by stem oracle10g installation in AIX 5 . Munir mondolsoft Bangladesh (3 Replies)
Discussion started by: dbamunir
3 Replies

5. Solaris

How can i install oracle 10g on x86

Please guide me to install oracle 10g in x86 machine running solaris10. I tried the method that is distributed with the Oracle cd, but i finds it to be too complicated for me to complete. Please help. (2 Replies)
Discussion started by: Sesha
2 Replies

6. AIX

Oracle 10g on AIX7

Hi, anyone know if Oracle Database 10g is AIX 7 certified??? thanks in advance. Regards. Mario (2 Replies)
Discussion started by: Zio Bill
2 Replies

7. Shell Programming and Scripting

Oracle/SQLPlus help - ksh Script calling .sql file not 'pausing' at ACCEPT, can't figure out why

Hi, I am trying to write a script that calls an Oracle SQL file who in turns call another SQL file. This same SQL file has to be run against the same database but using different username and password at each loop. The first SQL file is basically a connection test and it is supposed to sort... (2 Replies)
Discussion started by: newbie_01
2 Replies
replacekey(1)						      General Commands Manual						     replacekey(1)

NAME
replacekey - replace keywords in a FITS header SYNOPSIS
replacekey [options] <in> DESCRIPTION
replacekey is aimed at replacing keywords in a FITS file's header by new keywords provided by the user on the command-line. ALGORITHM
The user can provide a new_keyword, an old_keyword, a value and a comment. first searchs for old_keyword if provided. If it finds it, it replaces the associated card by the new one (new_keyword=value/comment). If old_keyword is either not found or not provided, associated card by the new one (new_keyword=value/comment). new_keyword has to be provided. Examples: You want to change the value of VALUE from 32 to 16 in myfile.fits: % replacekey -k "VALUE" -v "16" myfile.fits If you want to replace the card with the keyword OLD by "NEW = 3.14 / This is a usefull key" in myfile.fits: % replacekey -k "NEW" -v "3.14" -c "This is a usefull key" -K "OLD" myfile.fits If your do not care about the HISTORY cards you have in the header, and want to replace the first one by VALUE=32, you would do: % replacekey -k "VALUE" -v "32" -K "HISTORY" myfile.fits OPTIONS
-k or --key key To provide the new keyword. -K or --old key To provide the old keyword. -v or --val val To provide the new value. -c or --com com To provide the new comment. SEE ALSO
hierarch28 to convert HIERARCH ESO keywords to regular 8-char keywords. FILES
Files shall all comply with FITS format BUGS
Modifications are so far only possible in the main header, not in the extensions. 28 Oct 1999 replacekey(1)
All times are GMT -4. The time now is 05:11 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy