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 need help urgently for following issue. Pls help me to resolve this issue.
I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql)
I given... (6 Replies)
Hi,
I am executing sql files in my unix shell script. Now i want to find whether its a success or a failure record and redirect the success or failure to the respective files. meaning.
success records to success.log file
failure record to failure.log file.
As of now i am doing like... (1 Reply)
Hi ,
I used the below script to get the sql data into csv file using unix scripting.
I m getting the output into an output file but the output file is not displayed in a separe columns .
#!/bin/ksh
export FILE_PATH=/maav/home/xyz/abc/
rm $FILE_PATH/sample.csv
sqlplus -s... (2 Replies)
Hello Guys,
This message is somewhat relates with last thread. But I need to re-write thing. I start over a little. I am stuck now and need your help.
Here is my script-
#! /bin/ksh
export ORACLE_HOME=/opt/oracle/app/oracle/product/9.2
/opt/oracle/app/oracle/product/9.2/bin/sqlplus -s... (5 Replies)
Hi
I want ot save SQL query result in one txt file. for that i have written one code line
sqlplus -s $dbstring @/usr/local/bin/sched/nightly_Cronjob/exec_123.sql >> /usr/local/bin/sched/nightly_Cronjob/result.txt
but it is not working .
database : Oracle
so please advice me how can i... (7 Replies)
Hi all,
I have a flat file as below;
470423495|1||TSA-A000073800||1|||1
471423495|1||TSA-A000073800||5|||5
472423495|1||TSA-A000073800||2|||7
473423495|1||TSA-A000073800||3|||3
I like to create a Unix script.
The script have to valuate the last two columns, if the values are... (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 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
last
LAST(1) BSD General Commands Manual LAST(1)NAME
last -- indicate last logins of users and ttys
SYNOPSIS
last [-n] [-nTx] [-f file] [-H hostsize] [-h host] [-L linesize] [-N namesize] [-t tty] [user ...]
DESCRIPTION
last will list the sessions of specified users, ttys, and hosts, in reverse time order. Each line of output contains the user name, the tty
from which the session was conducted, any hostname, the start and stop times for the session, and the duration of the session. If the ses-
sion is still continuing or was cut short by a crash or shutdown, last will so indicate.
The following options are available:
-n Limits the report to n lines.
-f file last reads the file file instead of the default, /var/log/wtmpx or /var/log/wtmp. If the file ends with 'x', it is treated as
a utmpx(5) format file, else it is treated as a utmp(5) format file. If the file is ``-'', standard input is used.
-H hostsize Use the provided hostsize as the width to format the host name field.
-h host Host names may be names or internet numbers.
-L linesize Use the provided linesize as the width to format the tty field.
-N namesize Use the provided namesize as the width to format the login name field.
-n Print host addresses numerically. This option works only on wtmpx(5) entries, and prints nothing on wtmp(5) entries.
-T Display better time information, including the year and seconds.
-t tty Specify the tty. Tty names may be given fully or abbreviated, for example, ``last -t 03'' is equivalent to ``last -t tty03''.
-x Assume that the file given is in wtmpx(5) format, even if the filename does not end with an 'x'. Also useful when reading
such format from standard input.
If multiple arguments are given, the information which applies to any of the arguments is printed, e.g., ``last root -t console'' would list
all of ``root's'' sessions as well as all sessions on the console terminal. If no users, hostnames, or terminals are specified, last prints
a record of all logins and logouts.
The pseudo-user reboot logs in at reboots of the system, thus ``last reboot'' will give an indication of mean time between reboot.
If last is interrupted, it indicates to what date the search has progressed. If interrupted with a quit signal last indicates how far the
search has progressed and then continues.
FILES
/var/log/wtmp login data base
/var/log/wtmpx login data base
SEE ALSO lastcomm(1), utmp(5), utmpx(5), ac(8), lastlogin(8)HISTORY
last appeared in 3.0BSD.
BSD October 18, 2011 BSD