04-06-2020
Tom Kite wrote owa_sylk which writes to .xls format files. It is an Oracle package, scrape it from here:
Ask TOM "Owa_sylk utility"
10 More Discussions You Might Find Interesting
1. Programming
Is there anyway to spool my select statement into spool files of max 10000 records each?
eg I have a select statement that will return 45000 records.
A normal spool command will output the 45000 into just one spool file.
How can I make sqlplus do this?
00001 - 10000 records --- spool... (3 Replies)
Discussion started by: Leion
3 Replies
2. Shell Programming and Scripting
Hi Guys..
Need your help to format the output of my shell script.
I am using spool command to take out put in csv file.
below is my code. (for example)
col USERNAME for a15
col EMAIL for a30
col FULL_NAME for a20
col LAST_LOGIN for a40
col DATE_CREATED for a40
SPOOL 120.csv... (3 Replies)
Discussion started by: Agupte
3 Replies
3. Shell Programming and Scripting
hi,
i have a text file that looks like this!
i want to generate an excel sheet out of it, removing all the junk data except the addresses
that look like
. Arrow Electrical Services
Rotating Machinery, Electrical Contracting & Mining Specialists
Onsite maintenance, breakdown... (8 Replies)
Discussion started by: vemkiran
8 Replies
4. Shell Programming and Scripting
Hi All,
#!/bin/ksh
call_sql ()
{
sql=$1
sqlplus -s $sqlparam_sieb <<EOF
SET ECHO OFF;
SET NEWPAGE NONE;
SET SQLBL OFF;
SET VERIFY OFF;
SET LINESIZE 2000;
SET... (2 Replies)
Discussion started by: Kevin Tivoli
2 Replies
5. Shell Programming and Scripting
Hi,
I want to write a program to copy a log file to Excel sheet. Excel sheet has four columns MethodName , Code , Description, Details and Time.
I want to pick these info from text file and put it in excel sheet.
here is how the text file looks -
04.17.2014 08:06:12,697... (1 Reply)
Discussion started by: hershey
1 Replies
6. Shell Programming and Scripting
Hi ,
i am generating some data by firing sql query with connecting to the database by my solaris box.
The below one should be the header line of my excel ,here its coming in separate row.
TO_CHAR(C. CURR_EMP_NO
---------- ---------------
LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies
7. Shell Programming and Scripting
SQL*Plus version : 11.2.0.4
OS : Oracle Linux 6.5
SQL*Plus is a client application to connect to oracle database. The log file for this tool is generated via spool command as shown below.
I am trying to append date ( $dateString ) to spool file as shown below.
$ cat test2.sh
#!/bin/bash... (4 Replies)
Discussion started by: kraljic
4 Replies
8. Shell Programming and Scripting
I am writing the following script to create the file v_out.txt.
sqlplus -s /nolog << EOF
CONNECT scott/tiger@orcl;
whenever sqlerror exit sql.sqlcode;
set newpage 0;
SET PAGESIZE 0;
SET ECHO OFF;
SET FEEDBACK OFF;
SET HEADING OFF;
SET VERIFY OFF;
SET LINESIZE 100;
set tab off;
set... (7 Replies)
Discussion started by: itzkashi
7 Replies
9. UNIX for Beginners Questions & Answers
I am trying to write SQL query output into a .csv file. But in the output columns are displaying in different lines instead of coming in one line.
Main Code shell script:
this is my code:
#!/bin/bash
file="db_detail.txt"
. $file
rm /batch/corpplan/bin/dan.csv... (6 Replies)
Discussion started by: sandeepgoli53
6 Replies
10. UNIX for Beginners Questions & Answers
I am not finding a way to store output of unix shell script to a new spreadsheet in an existing excel file.
Also the shell script that I have written should be called from a macro in excel . The shell script that I have written is as follow :
git ls-files | grep '\.java$' | xargs wc -l | awk '... (1 Reply)
Discussion started by: Harshith
1 Replies
ND(1) General Commands Manual ND(1)
NAME
nd - Tiny little command line WebDAV interface
SYNOPSIS
nd [options] url
DESCRIPTION
nd provides a simple command line interface to the RFC 2518 (WebDAV) server. If no option is specified, HTTP GET command is issued and
writes response data to the standard output.
The options are as follows:
-c dest_url
COPY url to the dest_url. Use lock token if -t is specified.
-f Force override the content even when the MOVE or COPY target already exits.
-v View property information of url by PROPFIND. With -g option, only the specified property is displayed.
-p file PUT file content to the url. Use lock token if -t is specified.
-g name Specify the property name for -v option.
-e name=value
Edit the property with name to value using PROPPATCH .
-N namespace-url
Specify the property namespace URL for -e or -g option.
-P file POST file content to the url. -T is used for the Content-Type.
-T content_type
Use content_type as a Content-Type field value of the POST request. Default is `application/x-www-form-urlencoded'.
-d DELETE url. Use lock token if -t is specified.
-l LOCK url. Use -o as owner, -s as scope, -i as timeout.
-o owner
Specify lock owner. Default is USER environment variable.
-s scope
Specify lock scope (`exclusive' or `shared'). Default is `exclusive'.
-i timeout
Specify lock timeout interval. Default is `Infinite'.
-u UNLOCK url. -t option is required.
-t token
Specify the lock token.
-r Set command execution `Depth' as `Infinity'.
-a realm
Specify authentication realm.
-A realm
Specify proxy authentication realm.
-k MKCOL url
-m dest_url
MOVE url to the dest_url. Use lock token if -t is specified.
-S Print output using s-expression.
ENVIRONMENT VARIABLES
http_proxy, HTTP_PROXY
Specify HTTP proxy.
USER When manipulating a lock without an explicit owner option, the value of USER is used to set the owner of the file lock.
BUGS
A maintainer of the Debian package has implemented Digest authentication on top of the original software. However, the upstream source uses
the nanoHTTP code from libxml2 to implement the HTTP transport. Due to properties inherent in that code for detecting and following redi-
rected target sites, there is no way to pull out the new address in order to insert it into the hashes necessary for the Digest method. Nd
will therefore incorrectly answer with 'Bad request' to any method call aimed at such sites. Using the correct logical name for the target
will, however, produce a correct response from Nd.
AUTHORS
Yuuichi Teranishi (teranisi@gohome.org).
SEE ALSO
libxml(4).
February 25, 2002 ND(1)