I am running a query with contains blank spaces in between in the output. But when I open and read the file in UNIX i am not able to cursor the balnk spaces instead it is moving like tabs. Please help
suppose my query -
Code:
Select ' '||text from tab1;
the cursor should move to 1st and 2nd blank space but it is directly moving to text field trating the blank space as tabs.
Last edited by zaxxon; 12-18-2009 at 05:53 AM..
Reason: use code tags please
Hi all,
I would want to spool file for a database query, however by using crontab, the file is not spooled. Below shows my script:
ORACLE_HOME="/u01/oraprod/perpdb/10.1.0/db_1"
OUTFILE="/tmp/invalid.out"
FILE="$HOME/admin/scripts"
$ORACLE_HOME/bin/sqlplus -s "/as sysdba"... (0 Replies)
i'm used a sql query in a unix script to get the information from table. but unable to extract the output which i need. Any help with logic will be greatly appreciated.
my sql query provide output some thing like this -
col1 col2 count
---- ---- ------
A B 10
c D 6
e... (8 Replies)
Hi,
I'm new to mysql, I've installed MYSQL on our unix server and started MYSQL on this server.
I've now downloaded MYSQL Query Browser, when I try to connect to MYSQL server, I get the following error "could not connect to the specified instance" - MySQL Error Number 1130.
From the... (3 Replies)
I would like to use the result of a query in another query. How do I redirect/add the output to another variable?
$result = odbc_exec($connect, $query);
while ($row = odbc_fetch_array($result)) {
echo $row,"\n";
}
odbc_close($connect);
?>
This will output hostnames:
host1... (0 Replies)
Hi Everyone,
When i issue command like
ls -l | awk '/udtts/ {print $9}'
===============================
I am getting output as
udttsGEHLNAR.6864
udttsGEHLNAR.7921
udttsNARALAX.15415
udttsNARALAX.18016
But I want output after dot i.e like
6864
7921
15415
18016 (3 Replies)
I want to print the output of a db2 query, on to an unix file in a manner that the columns are separated by 'commas'. Please help me out..thanx in advance (1 Reply)
I was performing the wc -l operation in one data file the result is less when i was giving -nu on the view of the file.
while giving wc -l the count is 5023
after setting line numbers in view of file is giving 5024.
Can anyone help on this.... (5 Replies)
Hi,
I never did this before... what I want to do is execute a SQL query from a unix script and redirect sql query's output to a flat file (comma separated one) without the header info (no column names). I would also want not to print the query's output to the screen.
snapshot of my script:... (13 Replies)
Following is the output of a command ran inside the script:
2015-01-29-05-38-02 5 2015-01-29-05-38-02 5 2015-01-29-05-38-02 5 2015-01-29-05-38-02 5 2015-01-29-05-38-02 5 2015-01-29-05-38-03 5 2015-01-29-05-38-03 5 2015-01-29-05-38-03 5 2015-01-29-05-38-03 5 2015-01-29-05-38-03 5... (8 Replies)
EXPAND(1) User Commands EXPAND(1)NAME
expand - convert tabs to spaces
SYNOPSIS
expand [OPTION]... [FILE]...
DESCRIPTION
Convert tabs in each FILE to spaces, writing to standard output. With no FILE, or when FILE is -, read standard input.
Mandatory arguments to long options are mandatory for short options too.
-i, --initial
do not convert tabs after non blanks
-t, --tabs=NUMBER
have tabs NUMBER characters apart, not 8
-t, --tabs=LIST
use comma separated list of explicit tab positions
--help display this help and exit
--version
output version information and exit
GNU coreutils online help: <http://www.gnu.org/software/coreutils/> Report expand translation bugs to <http://translationproject.org/team/>
AUTHOR
Written by David MacKenzie.
COPYRIGHT
Copyright (C) 2013 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>.
This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law.
SEE ALSO unexpand(1)
The full documentation for expand is maintained as a Texinfo manual. If the info and expand programs are properly installed at your site,
the command
info coreutils 'expand invocation'
should give you access to the complete manual.
GNU coreutils 8.22 June 2014 EXPAND(1)