Does anybody know how to store my tables to a csv file? Post: 302429612

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:...

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.

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...

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:(

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. ...

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

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. 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...

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...

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...

LEARN ABOUT DEBIAN

restore-trash

RESTORE-TRASH(1)					      General Commands Manual						  RESTORE-TRASH(1)

NAME

       restore-trash - Restore for Command line trash utility.

SYNOPSIS

       restore-trash

DESCRIPTION

       Use  for  restore  a  trashed file or directory, in the original path.  This command is a part of trash-cli package that provides a command
       line interface trashcan utility compliant with the FreeDesktop.org Trash Specification.	It remembers the  name,  original  path,  deletion
       date, and permissions of each trashed file.

EXAMPLES

       $ restore-trash
       0 2007-08-30 12:36:00 /home/andrea/foo
       1 2007-08-30 12:39:41 /home/andrea/bar
       2 2007-08-30 12:39:41 /home/andrea/bar2
       3 2007-08-30 12:39:41 /home/andrea/foo2
       4 2007-08-30 12:39:41 /home/andrea/foo
       What file to restore [0..4]: 4
       $ ls foo
       foo

BUGS

       Report bugs to http://code.google.com/p/trash-cli/issues

AUTHORS

       Trash  was  written by Andrea Francia <andreafrancia@users.sourceforge.net> and Einar Orn Olason <eoo@hi.is>.  This manual page was written
       by Steve Stalcup <vorian@ubuntu.com>.  Changes made by Massimo Cavalleri <submax@tiscalinet.it>.

SEE ALSO

       trash-put(1), trash-list(1), trash-empty(1), and the FreeDesktop.org Trash Specification at http://www.ramendik.ru/docs/trashspec.html.

       Both are released under the GNU General Public License, version 2 or later.

																  RESTORE-TRASH(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Converting tables of row data into columns of tables

Discussion started by: justthisguy

2. Shell Programming and Scripting

Store table contents in csv file

Discussion started by: ladyAnne

3. Shell Programming and Scripting

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

Discussion started by: amit.mathur08

4. Shell Programming and Scripting

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

Discussion started by: Rajesh Putnala