If anyone can give me some ideas on this it would be great. What I'm trying to do is to have emails be sent to my unix account. Once they are emailed to the unix account, I want to use the text in the subject field to invoke a shell script, so basically I need to find a way that I can... (4 Replies)
I want to email where subject contains value of variable $ORACLE_SID.
When script is emailing, it is not taking value of $ORACLE_SID.
example -
I have variable ORACLE_SID=prd
I am sending email with below script.
tail -1 $LOG | mailx -s 'Export Completed for ${ORACLE_SID}'... (2 Replies)
Hi,
I need help in running a script that would pull info from an email subject line and run a script (foo.sh). I'm pretty sure after a bit of googling that this is possible in several ways. but none was pretty clear on how to accomplish it. The part that I really need help with is getting the... (5 Replies)
Hi,
Can anyone kindly provide some information about how to populate the subject field of the email while using the sendmail utility ? Itried the following command line argument :
echo -e "Body of the email" | /usr/lib/sendmail -f from@from.com -t to@to.com -s " Subject of the email"
... (4 Replies)
Help with script that will check log, then find a match is found, add that as the subject line.
1. The script will always run as a deamon.. and scan the event.log file
2. when a new 101 line is added to the event.log file, have the script check position 5,6 and 7 which is the job name, which... (2 Replies)
Hi all,
I am trying to automate a process in which at the end of the process the script should send an email to the user saying this process is completed.
I have done everything but the problem now is the subject line of the email...
the subject line looks like this..
where abc xyz is a... (4 Replies)
I am trying to insert subject for the mails sent through one of our sqr process using below code
Let $Email_Command = 'uuencode ' || $filename || ' ' || $filename || ' | sendmail -F''' ||$subject || ''' ' ||$mailid1 || ''' ' ||$mailid2
CALL SYSTEM USING $Email_Command #return_code WAIT
... (5 Replies)
hi ,
i have written below piece of code to meet the requirement but i am stuck in the logic here.
the requirement are:
1) to send the sql out put to email body with proper formatting.
2) if count_matching = Yes then mail should triggered with the subject line ... (10 Replies)
Hi
Newbie here with first post. I've got a shell script (ksh) whereby I run a SQL*Plus script and output the results to a file. I then check the output file in an if statement that looks like this:
if ]; then
export GAPNUM=`awk '{print $4}' $OUTFILE`
if ] then
mailx -s... (10 Replies)
Discussion started by: ltzwoman
10 Replies
LEARN ABOUT SUSE
alter_type
ALTER TYPE(7) SQL Commands ALTER TYPE(7)NAME
ALTER TYPE - change the definition of a type
SYNOPSIS
ALTER TYPE name RENAME TO new_name
ALTER TYPE name OWNER TO new_owner
ALTER TYPE name SET SCHEMA new_schema
DESCRIPTION
ALTER TYPE changes the definition of an existing type.
You must own the type to use ALTER TYPE. To change the schema of a type, you must also have CREATE privilege on the new schema. To alter
the owner, you must also be a direct or indirect member of the new owning role, and that role must have CREATE privilege on the type's
schema. (These restrictions enforce that altering the owner doesn't do anything you couldn't do by dropping and recreating the type. How-
ever, a superuser can alter ownership of any type anyway.)
PARAMETERS
name The name (possibly schema-qualified) of an existing type to alter.
new_name
The new name for the type.
new_owner
The user name of the new owner of the type.
new_schema
The new schema for the type.
EXAMPLES
To rename a data type:
ALTER TYPE electronic_mail RENAME TO email;
To change the owner of the type email to joe:
ALTER TYPE email OWNER TO joe;
To change the schema of the type email to customers:
ALTER TYPE email SET SCHEMA customers;
COMPATIBILITY
There is no ALTER TYPE statement in the SQL standard.
SQL - Language Statements 2010-05-14 ALTER TYPE(7)