1. Regarding the fields not coming below the column title, the default linesize in sqlplus is 80. Looks your output line is more than 80 bytes. Set the linesize to a bigger value say 100. I mean, after the pagesize setting line, add the below line and check:
2. Regarding the date formatting, I do not think you can format it like you do for a varchar or a number field. You need to change the NLS_DATE_FORMAT. To change NLS_DATE_FORMAT, you can google and see, you will find lots
Guru.
This User Gave Thanks to guruprasadpr For This Post:
Hi All,
I am having an excel sheet with pre-defined format which our business team specified, what i need to do is i have to write a script which need to pick values from database and update specified cells in excel sheet..
can any one please help me in this regard..
I am able to pull the... (3 Replies)
Hi,
I have an excel sheet which has 100000 records. All these records are having 3 columns each with the last column as "Y" or "N". I would like to filter those records which has the value "Y". Can you please let me know how to proceed with that?
Thanks in advance.
-Sri
----------... (8 Replies)
Hi All,
I'm finding it difficult to format the query output that was returned in a shell script.
Actually i have one shell script which does some DB stuff and depending on the result it will do some more tasks. My question here is to format the query output returned by mysql.
Intitally my... (5 Replies)
Hi,
I need to connect to the database and retrieve two variables from the database and store them in a variable,out of these two variables I need to get lastdigit appended to the variable 1 retrieved and variable 2 with out any modification
in short
select var,data from usage;
o/p=... (1 Reply)
I am facing a problem formatting the output of my shell script in excel.
We are directing the output of the script to an excel sheet and need long integer type data printed in Excel as it is (i.e. not in the default scientific notation).
Also, leading zeroes(if any) in the output are getting... (4 Replies)
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)
I want to run sql query in shell script and output data save as delimited text (delimited text would be comma)
Code:
SPOOL_FILE=/pgedw/dan.txt
SQL=/pgedw/dan.sql
sqlplus -s username/password@myhost:port/servicename <<EOF
set head on
set COLSEP ,
set linesize 32767
SET TRIMSPOOL ON
SET... (8 Replies)
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)
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
LEARN ABOUT NETBSD
lastlogin
LASTLOGIN(8) BSD System Manager's Manual LASTLOGIN(8)NAME
lastlogin -- indicate last login time of users
SYNOPSIS
lastlogin [-nrt] [-f filename] [-H hostsize] [-L linesize] [-N namesize] [user ...]
DESCRIPTION
lastlogin will list the last login session of specified users, or for all users by default. Each line of output contains the user name, the
tty from which the session was conducted, any hostname, and the start time for the session.
If multiple users are given, the session information for each user is printed in the order given on the command line. Otherwise, information
for all users is printed, sorted by uid.
lastlogin differs from last(1) in that it only prints information regarding the very last login session. The last login database is never
turned over or deleted in standard usage.
The following options are available:
-f filename
Process input from filename. If the file ends with an ``x'', then it is assumed that it is a lastlogx(5) file, else it is assumed to
be a lastlog(5) file.
-H hostlen
Set the field width for host output to hostlen characters.
-L linelen
Set the field width for line output to linelen characters.
-N namelen
Set the field width for name output to namelen characters.
-n Attempt to print numeric host addresses. This option is only supported with lastlogx(5) format files.
-r Reverse the order of the sort.
-t Sort by last login time (most recent first.)
FILES
/var/log/lastlogx default last login database
/var/log/lastlog compatibility last login database
EXAMPLES
lastlogin looks by default to the /var/log/lastlogx database, where some old programs that are not utmpx(5) aware might only write to
/var/log/lastlog. To look at the old database one can use:
lastlogin -f /var/log/lastlog
SEE ALSO last(1), lastlog(5), lastlogx(5), ac(8)AUTHORS
John M. Vinopal wrote this program in January 1996 and contributed it to the NetBSD project.
BSD March 4, 2005 BSD