11-16-2009
If you want to fetch data, then you need to include
m=`sqlplus -s username/password@tnsname <<EOF
set head off
set feed off
set verify off
select count(1) from x_table;
exit;
EOF`
This will provide you the output of count(1) in variable.
-s will take you into silent mode .. you can choose to include or exclude it accordingly ..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi everybody...
can anyone help me in executing the .sql file with shell scripting....
thanx in advance (2 Replies)
Discussion started by: abuanas
2 Replies
2. Shell Programming and Scripting
Hi people, i need youre help on this.
I need to create an Shell SCript to list in a directory some sql files and then execute them one by one .
Also i need to have Logs from the executed Sql's to send to our costummers.
Can anyone help me on this
Regards,
osramos (2 Replies)
Discussion started by: osramos
2 Replies
3. Shell Programming and Scripting
Hi,
I know in oracle a .sql file is called by @ <path> /<filename>.
But how to call in sql 2005, I am opening the sql sessionwith sqsh, is there any command to execute there a .sql file (query in sql 2005) in K shell script. (0 Replies)
Discussion started by: n2ekhil
0 Replies
4. Shell Programming and Scripting
Hi All,
Please help me to write a shell script to execute the below sql query.
select c.account_no,b.bill_no,a.pay_type,(b.total_due + b.recvd + b.adjusted + b.disputed + b.transferred) as amt_not_billed,d.cash_on_delivery,
(select j.bill_no from
billinfo_T y,
bill_t j
where... (1 Reply)
Discussion started by: girish.raos
1 Replies
5. Shell Programming and Scripting
hi all,
how to execute shell script in another server that contain sql script. i tried using "ssh -l" option.. but i am unable to load the environment variable of the remote host.
please suggest how execute the shell script contain sql part inside it. (2 Replies)
Discussion started by: sandeep909
2 Replies
6. Shell Programming and Scripting
I am using HP-UX:
I have written a ksh script where I need to connect to sqlplus and execute few sql scripts. Part of this code is -
sqlplus user/temp1234 <<!
set serverout on
set feedback off
set pages 1000
set colsep ,
set echo off
spool /home/supp1/pks/output.csv... (8 Replies)
Discussion started by: Sriranga
8 Replies
7. Shell Programming and Scripting
hello forum ,
I am new to shell scripting. as part of my assignment i have to execute a sql querry from the shell script. please help me.
example.
sql queerry:db2 "select emp_id from tsble emp".
i have to execute the above querry from the script.
advance thanks to forum
Siva ranganath (1 Reply)
Discussion started by: workforsiva
1 Replies
8. Shell Programming and Scripting
Hi All,
I want some help in writing a shell script which will be in the below form:
A logical representation of shell scripts:
->Shell scripts start
->Connect to database
->Execute a sql and store the output in a cursor(need to know is there any concept of cursor in unix)
->Using a loop... (2 Replies)
Discussion started by: Chitragupta
2 Replies
9. Shell Programming and Scripting
Hi Experts,
Need your support.
Not able to use sql query alias in shell script.
Could you please help me in finding right way to use alias with sql query in shell script.
Below is the code i am using.
#!/bin/bash
sqlplus -s abc/abc@abc << EOF> bcd.csv
set trimspool on
select zone_id... (4 Replies)
Discussion started by: as7951
4 Replies
10. Shell Programming and Scripting
I am new to shell scripting and i want to know how to execute the *.sql files from a folder through sqlplus in shell script and files should be execute in sequentially one by one while execution if any ORA error it has to exit from sqlplus session
1) scripts from external folder
2) logs has... (1 Reply)
Discussion started by: sreekanth Reddy
1 Replies
LEARN ABOUT DEBIAN
eurephiadm-users
eurephiadm users(7) eurephiadm users(7)
NAME
eurephiadm-users - User management module
SYNOPSIS
eurephiadm users --list|-l [-S|--sort <sort keys>]
eurephiadm users --show|-s [-i|--uid <user id>] [-u|--username <user name>] [-l|-|-lastlog] [-L|--lastlog-details] [-a|--attempts]
[-b|--blacklist]
eurephiadm users --activate|-a [-i|--uid <user id>] [-u|--username <user name>]
eurephiadm users --deactivate|-d [-i|--uid <user id>] [-u|--username <user name>]
eurephiadm users --add|-A [-u|--username <user name>] [-P|--password <plain text password>] [-C|--certid <certificate ID>] [-D|--digest
<certificate SHA1 digest>] [-c|--certfile <certificate file>] [-2|--pkcs12]
eurephiadm users --delete|-D [-i|--uid <user id>] [-u|--username <user name>]
eurephiadm users --password|-p [-i|--uid <user id>] [-u|--username <user name>]
eurephiadm users [-h|--help [<mode>]]
DESCRIPTION
eurephiadm users manages eurephia user accounts. It provides an interface for listing, creating new, modify and delete user accounts.
MODES
Available modes:
-l | --list
[-S|--sort <sort keys>]
List all user accounts. Providing -S|--sort and a sort key will define the sort order of the list. Valid sort keys are:
uid - user ID
username - User name belonging to the user account
activated - When the user account was activated
deactivated - When the user account was deactivated
lastaccess - When the user account was last used
-s | --show
[-i|--uid <user id>] [-u|--username <user name>] [-l|--lastlog] [-L|--lastlog-details] [-a|--attempts] [-b|--blacklist]
Show user account details. --uid or --username are required. The other arguments only defined which kind of information to show.
-a | --activate
[-i|--uid <user id>] [-u|--username <user name>]
Activate a user account. --uid or --username is required.
-d | --deactivate
[-i|--uid <user id>] [-u|--username <user name>]
Deactivate a user account. --uid or --username is required.
-A | --add
[-u|--username <user name>] [-P|--password <plain text password>] [-C|--certid <certificate ID>] [-D|--digest <certificate SHA1
digest>] [-c|--certfile <certificate file>] [-2|--pkcs12]
Add a new user account. --username is required. If you want to assign a password for the new user account via the command line,
provide the password with --password.
To associate this user account against an already regstistered certificate, it can be done by either refering to the certificate ID
in eurephia using --certid or providing the certificate SHA1 digest/fingerprint to --digest.
A brand new certificate can be registered and linked to the user account directly if you have access to the certificate file. The
file can be in either PEM/DER format or PKCS#12. Use --certfile to indicate the certificate file to extract the information from
and --pkcs12 if it is a PKCS#12 file.
-D | --delete
[-i|--uid <user id>] [-u|--username <user name>]
Delete a user account. --uid or --username is required.
-p | --password
[-i|--uid <user id>] [-u|--username <user name>]
Change password on a user account. --uid or --username is required.
-h | --help
[<mode>]
Show a help screen. Without any arguments, all modes are listed. Providing a mode will show more information about the chosen
mode.
SEE ALSO
eurephiadm(7), eurephiadm-certs(7)
AUTHOR
Copyright (C) 2008-2010 David Sommerseth <dazo@users.sourceforge.net>
David Sommerseth July 2010 eurephiadm users(7)