|
|
Sponsored Content
Top Forums
UNIX for Dummies Questions & Answers
SQLPlus spool file
Post 302260618 by vbe on Friday 21st of November 2008 08:29:59 AM
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi All
This may not be entirely Unix related but I'll just have to try my luck and see if you know how to do this:
I need to spool the results of my SQL query into a file but as there are too many fields in the query the resultant spool file put the last few fields on the next line.
May I... (2 Replies)
Discussion started by: handynas
2 Replies
2. Shell Programming and Scripting
I have a sqlplus report and inside that report I have the following piece of code to mail the report output to the email id.
My requirement is, instead of emailing the output I want to FTP that script to a different unix server (say ip as 10.10.1.1). How to modify this code to FTP the spool file... (0 Replies)
Discussion started by: vprevin
0 Replies
3. Shell Programming and Scripting
hi,
can anyone help me by saying how can i spool a unix file.. do we need to specify the pathname as such to spool the file ..
right now, i tried giving like spool filename in the sql prompt.. but its not giving me the required output even if i can see that the command is being executed..
... (2 Replies)
Discussion started by: kripssmart
2 Replies
4. AIX
Dear Gurus,
Tried searching for some clues in this forum but dont seem to be able to find my answer. :confused:
Anyway i have a quick question:
Today I have produced a messages generated from a application and placed them on the print queue. Before this I had stopped the printer queue, so... (2 Replies)
Discussion started by: lweegp
2 Replies
5. Shell Programming and Scripting
Hi,
Iam a newbie. When I give the below query at SQL prompt.
SQL> select col1||'`ß`'||col2 from tablename where rownum<2;
1-J7WGX`ß`1-7OKC-23
Iam getting ß within appostropies...... If I remove appostropies and give the query it is throwing an error.
If I give the same query in spool as... (1 Reply)
Discussion started by: kknayak
1 Replies
6. Shell Programming and Scripting
hi all,
am trying to write a ksh script which will take a username, password, db instance as input arguments and login to the database using sqlplus and select some data via sql and spool to a file.
problem is that i am using "sqlplus -s" in order to hide the username/password and it doesnt... (8 Replies)
Discussion started by: cesarNZ
8 Replies
7. Shell Programming and Scripting
I'm calling an embedded sql from my shell script file. This sql does simple task of spooling out the contents of the table (see below my sample code) into a spool file that I specify. So far so good, but the problem is that the output is also displayed on screen which I do NOT want.
How can I... (3 Replies)
Discussion started by: MxC
3 Replies
8. Shell Programming and Scripting
Hello,
I am trying to spool data from database into a file on solaris through ksh.
Data is getting fetched but the problem is record is getting split in to multiple lines.
excerpt from sql is
whenever sqlerror exit 1;
set define on
set echo off
set feed off
set head off
set... (1 Reply)
Discussion started by: abhi1988sri
1 Replies
9. Shell Programming and Scripting
i am using bash shell
Whenever i declare an array, and then using sqlplus, i am getting sqlplus error and return code 127.
IFS=","
declare -a Arr=($Variable1);
SQLPLUS=sqlplus -s "${DBUSER}"/"${DBPASS}"@"${DBASE}
echo "set head off ; " > ${SQLCMD}
echo "set PAGESIZE 0 ;" >> ${SQLCMD}... (6 Replies)
Discussion started by: arghadeep adity
6 Replies
10. Shell Programming and Scripting
Hi,
I have a requirement of
Connecting to sqlplus from unix
Execute the package. The output of package is stored in a table
Need to query the table and move to txt file.
The problem iam facing is, when I try to spool the file. I get the sql query also along with the output.... (6 Replies)
Discussion started by: Shanmugapriya D
6 Replies
LEARN ABOUT DEBIAN
billard-gl
BILLARD-GL(6) Games Manual BILLARD-GL(6) NAME
billard-gl - OpenGL billiards game SYNOPSIS
billard-gl [options] DESCRIPTION
This manual page documents the billard-gl program. This manual page was written for Debian because the original program does not have a manual page. billard-gl implements a game of 8- or 9-ball billiards, which you can play against the computer or a friend. The general idea of billiards is to hit the coloured balls with the cue ball in such a way that these balls fall in one of the six pockets of the table. OPTIONS
-f -fullscreen switches to fullscreen mode (can currently not be changed from inside billard-gl itself) -f -windowed switches to windowed mode (default; can currently not be changed from inside billard-gl itself) -t VALUE texture size for the balls. Valid values are 1 for full size textures, 2 for half size textures, 4 for quarter size textures, and 8 for eighth size textures. -tt VALUE texture size for the table. Valid values are 1 for full size textures, 2 for half size textures, 4 for quarter size textures, 8 for eighth size textures, and 0 for no textures. -at VALUE texture size for the display. Valid values are 1 for full size textures and 2 for halfsized textures. -g VALUE ball geometry; odd numbers >= 3. Higher values create more complex geometry. To run billard-gl with minimum settings, try billard-gl -t 8 -tt 0 -at 2 -g 3 or for maximum settings, try billard-gl -t 1 -tt 1 -at 1 -g 11 All of the options are configurable from within billard-gl itself, unless stated otherwise. AUTHOR
billard-gl was written by Stefan Disch, Tobias Nopper and Martina Welte. This manual page was written by Jamie Wilkinson <jaq@debian.org> and updated by Thierry Reding <thierry@doppeltgemoppelt.de> for Debian (but may be used by others). January 22, 2005 BILLARD-GL(6)