I like to call a shell script from pl/sql proceduere and i have to use the shell script return value in that procedure. i am using oracle 9i and cygwin.
can any one suggest me how can i do this (0 Replies)
I would like to call the shell script from pl/sql and i need to uses the value returned by the shell script in pl/sql procedure.
can any one suggest me how can i do that? (3 Replies)
Hello,
I am doing a shell script which contain a pl/sql loop to search for 3 values, i would like to call another shell script inside this sql loop each time it find the values. so how can i call shell script from pl/sql using its variables, any idea?
Here is idea about the code:
my... (1 Reply)
Hi Experts,
I want to call script_name.ksh as many time as id in customer table and also pass it as a parameter to script.
someting Like below.
for i in select id from customer
do
./script_name.ksh $i &
done
I have figured out how to have ID from customer but now how to call... (3 Replies)
Hi i am not able to connect sqlplus
my script is as follows
$ORACLE_HOME/bin/sqlplus << ! > /tmp/extract/DM.txt
and output is
SQL*Plus: Release 11.1.0.7.0 - Production on Wed Jan 18 02:53:54 2012
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Enter user-name: t175481... (1 Reply)
Hi,
I need help in writing a shell script which can read data from a text file (Cancel_ID.txt) and then calls sqlplus session (Cancel.sql) with the first line parameter of the text file ("0322600453") till all rows are not completed.
... (4 Replies)
HI Experts,
I am pretty new to scripting and i need to create a perl or shell script which should fetch a file from local directory and insert the data into a table using sql loader. This will be later added to chron job to run daily and fetch all files and load them into
the table.
Also i... (1 Reply)
I have the below script triggered daily at 330am in the morning, since last 7 days job not writing anything to database.
below impala shell calling shell file which has sql , it is extracting data and loads to a flat file txt file. which is going wrong for last 1 week.
need help, echo... (2 Replies)
hi ,
the below script contains sql query and after executed it sends the output of the query (output.txt) to an email body with conditional subject line based on the output of all_counts_match.txt.
i want to make this script generic so that it can accept the sql file as parameter and can... (5 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 ULTRIX
shexp
shexp(1) General Commands Manual shexp(1)Name
shexp - display password expiration information for a user
Syntax
shexp [-q] [username]
Description
The command is used to display a user's password expiration information. The specified username, or logname if no username is supplied, is
converted to a UID by searching through the passwd file. The UID is then used to look up the user's entry in the Auth Data Base. The
password expiration information is then printed out in format.
% shexp
Expires Tue Dec 6 10:49:18 EST 1988
If the password has already expired the word Expires will be replaced with the word Expired. If password expiration is disabled for the
particular user in question the output of will be Never expires.
Options-q Instead of displaying the expiration date and time in format, outputs it as three decimal numbers: the minimum password lifetime, the
maximum password lifetime, and the password modification time. All three numbers are displayed as they are found in the database.
Restrictions
Only the super-user may obtain information about users with UIDs other than the real UID of the invoking process.
Diagnostics
User not found in passwd data base.
There is no entry in for the specified username.
Cannot stat auth file.
The database is missing (security features may not be enabled).
Insufficient privilege.
An insufficiently privileged user is asking for information about a username with a UID different then their current real-UID.
An exit value of 0 indicates a successful operation, any other exit status indicates an error.
FilesSee Alsopasswd(1), getauthuid(3), auth(5)
Security Guide for Users
shexp(1)