Sponsored Content
Special Forums UNIX and Linux Applications Does anybody know how to store my tables to a csv file? Post 302429612 by ladyAnne on Tuesday 15th of June 2010 03:21:45 AM
Old 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

Converting tables of row data into columns of tables

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

Store table contents in csv file

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

Execute stored procedure through script in sybase database and store the output in a .csv file

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

need to store query output fields in variables edit them and update the same in tables.

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

Search and store value from .csv

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

Script to store the csv files into a particular folder

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

Compare 2 files of csv file and match column data and create a new csv file of them

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

Splitting csv into 3 tables in html file

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

Read CSV file and delete hdfs, hive and hbase tables

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

Export Oracle multiple tables to multiple csv files using UNIX shell scripting

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
file-pr(8)						     GNATS Internal Utilities							file-pr(8)

NAME
file-pr - files incoming problem reports in GNATS database SYNOPSIS
file-pr [ -f file | --file=file ] [ -h | --help ] [ -V | --version ] [ -H host | --host=host ] [ -P port | --port=port ] [ -v user | --user=user ] [ -w password | --passwd=password ] [ -d databasename | --database=databasename ] DESCRIPTION
file-pr files incoming Problem Reports in the GNATS database, sends acknowledgments to approriate parties and logs database activity. file-pr assigns the Problem Report an identification number and then files it in the GNATS database either under the category specified in the Category field of the PR, or under the default category if the Category field is nonexistent or contains an invalid category name. For the default GNATS configuration, the person responsible for that category and the person responsible for the submitter site where the PR originated receive a copy of the PR in its entirety. Optionally, the originator of the PR receives an acknowledgment that the PR ar- rived and was filed OPTIONS
-f file, --filename=file Accept file as input; if this option is not present, standard input is used. -h, --help Display usage summary for file-pr. -V, --version Display version number for file-pr. -d, --database Specifies the database to which the PR is to be submitted. If no database is specified, the database named default is assumed. This option overrides the database specified in the GNATSDB environment variable. GNATS network options: -H, --host Hostname of the GNATS server. -P, --port The port that the GNATS server runs on. -v, --username Username used to log into the GNATS server. -w, --passwd Password used to log into the GNATS server. 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) 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, 1999, 2003, 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 file-pr(8)
All times are GMT -4. The time now is 08:51 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy