08-02-2010
If you are using Toad, then at the left extreme top of your results window, right click, choose Save as -> choose XLS as file format and "," as delimiter.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi, I am new in unix,
I just want to replace some values from text file according to column numbers. Like, I am having a table as given below:
val1 val2 val3 val4 val5
val6 val7 val8 val9
val10 val11 val12 val13
Now i want... (5 Replies)
Discussion started by: rish_max
5 Replies
2. Shell Programming and Scripting
Hello -
I have a below table and i want to extract the data into excel sheet and send to different location.
Here is the table structure...
SQL> desc t_i1_exportdocs
Name Null? Type
----------------------------------------- --------... (11 Replies)
Discussion started by: govindts
11 Replies
3. Shell Programming and Scripting
Hi Guys,
I have a file which has numbers in it separated by newlines as follows:
1.113
1.456
0.556
0.021
-0.541
-0.444
I am using the following code to store these in an array in bash:
FILE14=data.txt
ARRAY14=(`awk '{print}' $FILE14`) (6 Replies)
Discussion started by: npatwardhan
6 Replies
4. UNIX and Linux Applications
Hi
I'm using an oracle database... Lets call it databasename
My username and password are the same .... lets all that andrea/andrea
So I want to write a script to copy all the data from my table called tablename and store that data to a csv file called filename.
I cant seem to get... (2 Replies)
Discussion started by: ladyAnne
2 Replies
5. UNIX for Dummies Questions & Answers
Hi
I need to write a bash script to take the data stored in 3 oracle tables .. and filter them and store the results in a csv file.
It is an Oracle database
Thank you (1 Reply)
Discussion started by: ladyAnne
1 Replies
6. Shell Programming and Scripting
Hi Gurus,
I am trying for a scenario where in I want to read the contents of a file line by line and then store them in variables. Below is the script:
#!/bin/ksh
while read line
do
id=`echo $line | cut -f1 -d |`
name=`echo $line | cut -f2 -d |`
echo $id
... (11 Replies)
Discussion started by: svajhala
11 Replies
7. Shell Programming and Scripting
Hi there,
i have a file like that in attachment (PLEVA3_280711_SAP.txt), i would extract some basic information from it and report in a new file or table like this:
i try to use bash and i extract the single object in this way (see attach scriptino.sh), but i receive a strange... (5 Replies)
Discussion started by: alen192
5 Replies
8. Shell Programming and Scripting
Hi,
I am trying to place the contents of a .CSV file to an array, but not sure how to do that.
Here is my .CSV file content:
App,SLA,Job name,Avg start time,Avg run time,Frequency,Downstream apps
XYZ,,ABC14345,3:00 AM,00.04.00,Daily,STAMP
XYZ,9:00,ABC12345,3:15 AM,00.05.00,Daily,STAMP
... (4 Replies)
Discussion started by: ajayakunuri
4 Replies
9. Shell Programming and Scripting
i want to run update query for oracle which is in up.sql taking values from a.csv.
I have implemented shell script to do it.
extn="perl"
ls -1 | while read file
do
echo "$file,$extn" > a.csv
done
up.sql contains
update file_list set filename=$1 where extn=$2;
The code to update is... (2 Replies)
Discussion started by: millan
2 Replies
10. UNIX for Dummies Questions & Answers
Hi,
I'm attempting to write the entire contents of a file to a specific .csv cell. So far have only a nawk one liner that will write a value into a specific .csv cell. Trying to use man page but can't seem to get any farther. Any help would be appreciated. nawk -v r=2 -v c=3 -v val=5 -F,... (7 Replies)
Discussion started by: jimmyf
7 Replies
gtans(6) Games Manual gtans(6)
NAME
gtans - Tangram game for X
SYNOPSIS
gtans [no options]
DESCRIPTION
Gtans is a tangram game that runs in X. Tangram is a kind of puzzle game where the player has to arrange a set of pieces to match a given
shape.
OPTIONS
No command-line options
Use the graphical interface to customize the program. See below.
USAGE
move the pieces (known as tans) until they match the figure drawn on the right window. You must always use the seven tans and they should
not be laid on top of one another.
To move a tan, click and drag it with left mouse button, for rotation click AROUND it. You can flip the selected tan by right-clicking.
This is usefull for the parallelogram tan (all positions can not be reached by rotating only).
If you are a beginner to Tangram you should try the first 10 figures. The other ones are not sorted, some of them are very difficult (to
my taste).
When a figure has been solved the background color of the silhouette area changes. The solved figures are remembered by saving a status
file in the user's directory (~/.gtans/afile.figures.status for a figure file called afile.figures)
Show a tan This button shows the position of a tan. Each further click will display an other tan.
Show outline Draw the figure in the main area. This makes the game much easier.
Preferences Most of this menu's options allow you to change the colors used by the game. For the main area you may choose textures (pixmap
files) instead of colors. Some sample files are supplied (I can't remember where I found them) but as the complete pathname is saved in the
config file you can choose a file located anywhere (for example in /usr/share/pixmaps/). On a 8 bits display the colors may not be exactly
what you want (GTK tries to find the best matching color).
Preferences/Tans size/Increase Makes the tans 5 % bigger relatively to the game area. If you resize the window the tans size will be
scaled.
Preferences/Tans size/Decrease Makes the tans 4.76 % smaller
Preferences/Accuracy Changes the precision of the comparison between the tans position and the solution. A lower accuracy makes the game
more easy.
Preferences/Rotation Step by step allows only rotation by increment of 11.5 degrees. Continuous rotation makes the game more difficult and
you probably shouldn't use it unless you really dislike step by step rotation.
Preferences/Figures file Allows you to choose another figures file.
Preferences/Save config Save a config file in the user's home directory.
Misc/Clear figure status Set the current figure as unsolved.
Misc/Clear all figures status Set all the loaded figures (i.e. from the current figure file) as unsolved.
FILES
~/.gtans/.gtansrc Configuration options for gtans. All of these options can be set from the interface, there should be no
need to edit this file.
~/.gtans/somename.figures.status Status files (for each figures file the user played with) remenbering which figures where
solved.
SEE ALSO
The gtans homepage at <http://gtans.sourceforge.net/>. Additional information and documentation can also be found in
/usr/share/doc/gtans/ .
AUTHOR
The author of gtans is Philippe Banwarth <bwt@users.sourceforge.net>
February 2000 gtans(6)