One way would be, store all the grep'd Account into a variable say account_no and do some simple edit to make the values inside a comma separated one. Then use the select statement's IN clause instead of = .
If you do not want to store the output in a variable (row_out) then you can also try like..
Hi to all,
I have a endday.sh file. And I execute this like "sh endday.sh" from command prompt. In endday.sh file it writes:
sqlplus temp/temp@data @run.sql&
echo $!>>pid.txt
However my aim is not to put the pid into pid.txt but I need to insert the pid into an oracle table using sqlplus.... (1 Reply)
Hi to all,
I have a endday.sh file. And I execute this like "sh endday.sh" from command prompt. In endday.sh file it writes:
sqlplus temp/temp@data @run.sql&
echo $!>>pid.txt
However my aim is not to put the pid into pid.txt but I need to insert the pid into an oracle table using sqlplus.... (1 Reply)
Hi to all,
I have a endday.sh file. And I execute this like "sh endday.sh" from command prompt. In endday.sh file it writes:
sqlplus temp/temp@data @run.sql&
echo $!>>pid.txt
However my aim is not to put the pid into pid.txt but I need to insert the pid into an oracle table using sqlplus.... (1 Reply)
Hi All,
I needed to get the result of two sqlplus queris into shell variables.
After days of looking for the ultimate solution to this problem.. i found this...
sqlplus -s USER/PASS@DB <<EOF | awk '{if(NR==1) printf("%s ", $1); if(NR==2) printf("%s ",
$1);}' | read VAR1 VAR2
set head off... (2 Replies)
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)
Hi,
I am using sqlplus query to get results in a csv format in unix. I am using ksh, and below is the query.
echo "select r.num|| ',' || p.path ||',"' || r.issue_description ||'",' ||p.timestamp from events r, messagepath p;">> $QUERY_FILE
sqlplus -s $LOGIN @ $QUERY_FILE>>$OUTFILE
... (2 Replies)
Hi!
I would like to do a single connection to sqlplus and execute some querys.
Actually I do for every query one connection to database
i.e
echo 'select STATUS from v$instance;
exit' > $SQL_FILE
sqlplus user/pass@sid @$SQL_FILE > $SELECT_RESULT
echo 'select VERSION from v$instance;... (6 Replies)
Hi,
Could someone tell me how to stop SQLPLUS command from printing the connection details in the console.
Below is the lines i get in console when executing the sqlplus...
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Mar 9 03:31:03 2011
Copyright (c) 1982, 2005, Oracle. All rights... (2 Replies)
I need to connect a databas eusing sqlplus and i need to store the results of each query in separate file.
is it possible to achieve this usng single sqlplus?
i dont want to connect each time for each query.
thanks (3 Replies)
Hello ,
Im calling every single file inside my script like 1.sql,2.sql so on it looks so tedious. I want to replace with for loop where every file gets executed. When i use for loop im getting errorUnexpected EOF] , can anyone please help me out in this..
How i can use for loop to invoke my... (6 Replies)
Discussion started by: preethi87
6 Replies
LEARN ABOUT FREEBSD
logins
LOGINS(1) BSD General Commands Manual LOGINS(1)NAME
logins -- display account information
SYNOPSIS
logins [-admopstux] [-g groups] [-l logins]
DESCRIPTION
The logins utility displays information about user and system accounts.
The following options are available:
-a Display information about the password change and account expiration times for each account.
-d Select accounts with duplicate UIDs.
-g groups Select accounts that are members of the specified groups. If multiple group names are specified, they must be separated with com-
mas.
-l logins Select accounts matching the specified login names. If multiple names are specified, they must be separated with commas.
-m Show information about secondary groups.
-o Display the information for each account on a single line of colon-separated fields.
-p Select accounts with no password.
-s Select system accounts. These are currently defined as accounts with UIDs below 1000, plus the ``nobody'' account (UID 65534).
-t Sort selected accounts by name rather than by UID.
-u Select user accounts. These are currently defined as accounts with UIDs above 1000, except the ``nobody'' account (UID 65534).
-x Display information about each account's home directory and shell.
If multiple selection options are specified, all accounts matching any of the selection criteria will be displayed.
If no selection options are specified, all accounts will be displayed.
SEE ALSO getgrent(3), getpwent(3), group(5), passwd(5), pw(8)HISTORY
The logins utility appeared in FreeBSD 4.10.
AUTHORS
The logins utility was written by Dag-Erling Smorgrav <des@FreeBSD.org> based on similar utilities in other operating systems.
BSD March 6, 2004 BSD