10-01-2010
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi
I need to execute a select statement in a solaris environment with oracle database. The select statement returns number of rows of data.
I need the data to be inserted into a CSV file with proper format. For that we normally use "You have to select all your columns as one big string,... (2 Replies)
Discussion started by: rdhanek
2 Replies
2. UNIX Desktop Questions & Answers
Hi
I am trying to write a script to extract information from a database and save that info to a csv file.
I am using sql, an oracle database
I have no idea how to even begin this.
Can somebody please help. (8 Replies)
Discussion started by: ladyAnne
8 Replies
3. 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
4. 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
5. 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
6. Shell Programming and Scripting
Gents,
Can you please help me to create a pivot table from a csv file. ( I have zip the csv file)
Using the file attached, columns 1,28 and 21 i would like to get something like this output
JD Val 1 2 3 4 5 6 7 8 9 10 11 12 Total... (4 Replies)
Discussion started by: jiam912
4 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. Linux
Hi all,
Is there any out there have a brilliant idea on how to export html table data as .csv or write to txt file with separated comma and also get the filename of link from every table and put one line per rows each table.
Please see the attached html and PNG of what it looks like.
... (7 Replies)
Discussion started by: lxdorney
7 Replies
9. Programming
I have a MYSQL table with demographic data. The addresses contained in the table were entered manually before the advent of online postcode lookup software and, hence, there are a lot of errors when using automated online mailing checking software. I plan to export the data as csv file for a 3rd... (1 Reply)
Discussion started by: barrydocks
1 Replies
10. UNIX for Beginners Questions & Answers
I have this code with me but the condition is If any of the mandatory columns are null then entire file will be rejected.
LOAD DATA
infile ' ' #specifies the name of a datafile containing data that you want to load
BADFILE ' ' #specifies the name of... (1 Reply)
Discussion started by: raka123
1 Replies
LEARN ABOUT DEBIAN
dpkg-www
DPKG-WWW(1) General Commands Manual DPKG-WWW(1)
NAME
dpkg-www - program to remotely open a WWW Debian package browser
SYNOPSIS
dpkg-www [-s|--stdout] [-h|--host host] [query]
DESCRIPTION
dpkg-www is used to remotely control a WEB browser and open a dpkg URL on the local host from an interactive shell or script.
If the command is invoked while running under X-window the script will try to find an installed X browser to open the specified URL. If
not running under X it will try to use a text browser instead.
If Netscape is found and a Netscape instance is already running it will be asked to open the dpkg URL on localhost with the optional query
supplied on the command line. If there is no browser running, it will start automatically a new one.
The functionality provided by this program is identical to running a web browser with the -remote openURL(http://localhost/cgi-bin/dpkg)
argument or opening the same URL from within the browser.
dpkg-www-installer is an helper application which can configured in the WWW browser for web installation. It should never be invoked
directly by the user.
OPTIONS
-s, --stdout
Redirect output to stdout. Requires one of the text browsers (lynx, lynx-ssl or links) installed.
-h, --host host
Send the query to a remote host, where dpkg-www must be installed.
query Specifies an optional package name, an absolute pathname or a query argument which is passed to the dpkg cgi-bin. See dpkg-www(8)
for more information about the use of the cgi.
FILES
/etc/dpkg-www.conf
~/.dpkg-www
Configuration files for dpkg-www. It is not necessary for these files to exist, there are sensible defaults for everything, but you
can specify your preferred www browser with the DPKG_WWW_BROWSER variable, for example: DPKG_WWW_BROWSER=mozilla
EXAMPLES
dpkg-www
This would open a dpkg URL on localhost listing all the installed packages.
dpkg-www bash
This would open a dpkg URL asking info on the bash package.
dpkg-www -h pisolo bash
This would open a dpkg URL asking info on the bash package on host pisolo.
dpkg-www 'dpkg*'
This would open a dpkg URL listing all packages matching dpkg*.
dpkg-www /bin/bash
This would open a dpkg URL asking info on the package(s) owning the file /bin/bash .
dpkg-www depends=svgalib
This would open a dpkg URL listing all packages depending on svgalib.
dpkg-www --stdout depends=awk | grep ^ii
This would list on stdout all packages depending on awk and grep all lines of installed packages.
SEE ALSO
dpkg(8), dpkg-www(8)
AUTHOR
Massimo Dal Zotto <dz@debian.org>.
Bugs should be reported via the normal Debian bug reporting system.
LICENCE
dpkg-www is licensed under the GNU General Public License version 2.
September 1, 2004 DPKG-WWW(1)