06-15-2010
Does anybody know how to store my tables to a csv file?
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 any help for this, even by trying to look online
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am trying to transpose tables listed in the format into format. Any help would be greatly appreciated.
Input:
test_data_1
1 2 90%
4 3 91%
5 4 90%
6 5 90%
9 6 90%
test_data_2
3 5 92%
5 4 92%
7 3 93%
9 2 92%
1 1 92%
...
Output:... (7 Replies)
Discussion started by: justthisguy
7 Replies
2. Shell Programming and Scripting
I need to write a script to store the contents of a table in a csv file
I'm using Toad, it's a Oracle database. (5 Replies)
Discussion started by: ladyAnne
5 Replies
3. Shell Programming and Scripting
Hi,
I have a sybase stored procedure which takes two input parameters (start_date and end_date) and when it get executed, it gives few records as an output.
I want to write a unix script (ksh) which login to the sybase database, then execute this stored procedure (takes the input parameter as... (8 Replies)
Discussion started by: amit.mathur08
8 Replies
4. Shell Programming and Scripting
Hi ,
I have a query like
select err_qty,drop_qty,unbld_qty,orig_qty from usage_data;
I need to store the values of these fetched fields in variables,
Need to edit them and update the new values into the table.
Can anyone please help me in writing this piece of code:( (1 Reply)
Discussion started by: Rajesh Putnala
1 Replies
5. Shell Programming and Scripting
Dear All,
I am using the command to find the value from path
DYMV_STD_NAME=$( echo $file | sed 's#.*/*_\(*\).*#\1#' )
file = RRK11234_RKY5807_SRY000_HOME_20071010.zip
It give me value DYMV_STD_NAME = RKY5807
Now i have flat as below
The contect of the file would be as below.
... (1 Reply)
Discussion started by: yadavricky
1 Replies
6. Shell Programming and Scripting
I want to write a unix shellScript should store the csv files. into a paticular folder (2 Replies)
Discussion started by: RaghavendraT
2 Replies
7. Shell Programming and Scripting
Hi, I am newbie in shell script.
I need your help to solve my problem.
Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file.
File1:
SourceFile,DateTimeOriginal
/home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
Discussion started by: refrain
8 Replies
8. Shell Programming and Scripting
I have the data in csv in 3 tables. how can I output the same into 3 tables in html.also how can I set the width. tried multiple options . attached is the format.
#!/bin/ksh
awk 'BEGIN{
FS=","
print "<HTML><BODY><TABLE border = '1' cellpadding=10 width=100>"
print... (7 Replies)
Discussion started by: archana25
7 Replies
9. Shell Programming and Scripting
I have a CSV file with hdfs directories, hive tables and hbase tables.
1. first column - hdfs directories
2. second column - hive tables
3. third column - hbase tables
I have to check the csv file and look for the first column and delete the hdfs directory from the hdfs path, now... (2 Replies)
Discussion started by: shivamayam
2 Replies
10. UNIX for Beginners Questions & Answers
Hello All,
just wanted to export multiple tables from oracle sql using unix shell script to csv file and the below code is exporting only the first table.
Can you please suggest why? or any better idea?
export FILE="/abc/autom/file/geo_JOB.csv"
Export= `sqlplus -s dev01/password@dEV3... (16 Replies)
Discussion started by: Hope
16 Replies
LEARN ABOUT SUSE
gen-index
gen-index(8) GNATS Administration Utilities gen-index(8)
NAME
gen-index - generate new GNATS database index
SYNOPSIS
gen-index
[ -n | --numeric ] [ -h | --help ]
[ -o outfile | --outfile=outfile ]
[ -i | --import ] [ -e | --export ]
[ -d databasename | --database=databasename ]
[ -V | --version ]
DESCRIPTION
Builds an index for the specified GNATS database. The index is printed to standard output by default.
OPTIONS
-n, --numeric
Sorts index entries numerically rather than by their order in the categories list.
-d databasename, --database=databasename
Specifies the database to be indexed. If no database is specified, the database named default is assumed. This option overrides the
database specified in the GNATSDB environment variable.
-o outfile, --outfile=outfile
Prints the index to outfile rather than to the standard output.
-i, --import
Import the existing index file instead of re-indexing the database.
-e, --export
Force plaintext output
-h, --help
Prints usage for gen-index.
-V, --version
Prints the version number of gen-index.
ENVIRONMENT VARIABLES
The GNATSDB environment variable is used to determine which database to use. For a local database, it contains the name of the database to
access.
For network access via gnatsd, it contains a colon-separated list of strings that describe the remote database, in the form
server:port:databasename:username:password
Any of the fields may be omitted, but at least one colon must appear; otherwise, the value is assumed to be the name of a local database.
If GNATSDB is not set, it is assumed that the database is local and that its name is default.
SEE ALSO
Keeping Track: Managing Messages With GNATS (also installed as the GNU Info file gnats.info) and Reporting Problems Using send-pr (also in-
stalled as the GNU Info file send-pr.info).
databases(5), dbconfig(5), delete-pr(8), edit-pr(1) file-pr(8), gen-index(8), gnats(7), gnatsd(8), mkcat(8), mkdb(8), pr-edit(8), query-
pr(1), queue-pr(8), send-pr(1).
COPYING
Copyright (c) 1993 Free Software Foundation, Inc.
Permission is granted to make and distribute verbatim copies of this manual provided the copyright notice and this permission notice are
preserved on all copies.
Permission is granted to copy and distribute modified versions of this manual under the conditions for verbatim copying, provided that the
entire resulting derived work is distributed under the terms of a permission notice identical to this one.
Permission is granted to copy and distribute translations of this manual into another language, under the above conditions for modified
versions, except that this permission notice may be included in translations approved by the Free Software Foundation instead of in the
original English.
GNATS
August 2003 gen-index(8)