10-03-2016
Hello Jewel,
Could you please elaborate your requirement more here, seems you had edited your 1st post like you needed it in Oracle. Could you please let us know if this is a SQL query which you are doing for a field and there you need to do a check?
Thanks,
R. Singh
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
When I try to use the CLI mail, I get the following error. What's wrong?
Welcome to Darwin!
% mail root
Subject: test
test
.
EOT
% /etc/mail/sendmail.cf: line 81: fileclass: cannot open /etc/mail/local-host-names: Group writable directory
Do I just need to change the... (1 Reply)
Discussion started by: chenly
1 Replies
2. Shell Programming and Scripting
Hi,
I have the following small script. How can I just print out the string with missing message and send to hotmail.com? Also,
can i set the message a bit more beautiful such as "Dear All, the following list is missing in our system"?
#!/bin/sh
MSG=/log
cat list11.txt |
awk ' BEGIN { flag... (2 Replies)
Discussion started by: happyv
2 Replies
3. Solaris
Dear All,
Now I use solaris 10 and I try to forward mail from /var/mail/username to their external mail so what should I do?
thank u in advance (2 Replies)
Discussion started by: unitipon
2 Replies
4. Shell Programming and Scripting
Hi All,
Can any one solve this prob.
Im sending a textfile content as a mail body while sending a mail using shell script.
But, that textfile content is a unic command output.
So, in mail, im not getting the correct alignment as in textfile.
What may be the reason behind this.
Can... (1 Reply)
Discussion started by: suman_dba1
1 Replies
5. UNIX for Dummies Questions & Answers
Hi
The below script working when we are sending the html as attachment can u please guide how to send thesmae data in table form direct in the mail and not in mail attachment .
cat Employee.sql
SET VERIFY OFF
SET PAGESIZE 200
SET MARKUP HTML ON SPOOL ON PREFORMAT OFF ENTMAP ON -
HEAD... (0 Replies)
Discussion started by: mani_isha
0 Replies
6. UNIX for Advanced & Expert Users
i have sun machines having solaris 9 & 10 OS . Now i need to send mail from the machines to my outlook account . I have the ip adress of OUTLOOK mail server. Now what are the setting i need to do in solaris machines so that i can use mailx or sendmail.
actually i am trying to automate the high... (2 Replies)
Discussion started by: amitranjansahu
2 Replies
7. Shell Programming and Scripting
Hi Folks,
I have few mailids in a text file and need to check whether the mailid is in correct format or not.
If just to check whether the string is a mailid or not there is a perl module Email::Valid to do the business or we can implement our own logic.
But the mail_ids I am having is... (4 Replies)
Discussion started by: giridhar276
4 Replies
8. UNIX for Advanced & Expert Users
Hi expert
I use
mail -s "hello" bruce@sohu.com <kernel-img.conf
send mail, it display the sender is lyang001@lyang001-OptiPlex-9010.corp.ad..com
How can I change the sender to yanglei.fage@gmail.com to default ? (1 Reply)
Discussion started by: yanglei_fage
1 Replies
9. UNIX for Advanced & Expert Users
I am having trouble getting mail to work on a red hat server. At first I was getting this message.
Diagnostic-Code: X-Postfix; delivery temporarily suspended: connect to :25: Connection refused
Then added the port to my firewall. Then I temporarily turned off selinux. I then copied this file... (1 Reply)
Discussion started by: cokedude
1 Replies
LEARN ABOUT DEBIAN
jifty::dbi::handle::oracle
Jifty::DBI::Handle::Oracle(3pm) User Contributed Perl Documentation Jifty::DBI::Handle::Oracle(3pm)
NAME
Jifty::DBI::Handle::Oracle - An oracle specific Handle object
SYNOPSIS
DESCRIPTION
This module provides a subclass of Jifty::DBI::Handle that compensates for some of the idiosyncrasies of Oracle.
METHODS
connect PARAMHASH: Driver, Database, Host, User, Password
Takes a paramhash and connects to your DBI datasource.
database_version
Returns value of ORA_OCI constant, see "Constants" in DBD::Oracle.
insert
Takes a table name as the first argument and assumes that the rest of the arguments are an array of key-value pairs to be inserted.
build_dsn PARAMHASH
Takes a bunch of parameters:
Required: Driver, Database or Host/SID, Optional: Port and RequireSSL
Builds a dsn suitable for an Oracle DBI connection
blob_params column_NAME column_type
Returns a hash ref for the bind_param call to identify BLOB types used by the current database for a particular column type. The current
Oracle implementation only supports ORA_CLOB types(112).
apply_limits STATEMENTREF ROWS_PER_PAGE FIRST_ROW
takes an SQL SELECT statement and massages it to return ROWS_PER_PAGE starting with FIRST_ROW;
distinct_query STATEMENTREF
takes an incomplete SQL SELECT statement and massages it to return a DISTINCT result set.
AUTHOR
Jesse Vincent, jesse@fsck.com
SEE ALSO
Jifty::DBI, Jifty::DBI::Handle, DBD::Oracle
perl v5.14.2 2011-04-26 Jifty::DBI::Handle::Oracle(3pm)