Please see contains both files created for automating the data from oracle through shell.
1)a_p.ksh
2)spooled_A_P.log
Now,
#)in this log file i only want to have Count ie 155 and not any other information.
##)in the script file how to pull data from this log file so that it gets into the body of the mail along with the contains of MESSAGE file and also want to write some text ie, THE count from A_P table is <data from log file> and message file contains signature.
Dear friends,
please help me to solve following problem.
I'm running a frontend application from which i'll be invoking the shell script with arguments as given below
-driver -w -p "ABC XYZ" -S -ds con -dn "abc xyz"
i am getting
$1=-driver
$2=-w
$3=-p
$4="ABC
$5=XYZ"
$6=-S
$7=-ds... (3 Replies)
Hi guys,
I have searched all the forums and searched the net as much as possible, but I carn't find any tutorials about shell scripting with Oracle. Has anyone come across any?
Thanks for reading and in advance of posts,
B14... (2 Replies)
I have a file that has text in the format below
ABC
/ Some text /
ABC
/ Some text /
ABC
/ Some text /
ABC
/ Some text /
ABC
/ Some text /
How can I seperate the text between a pair of 'ABC' into seperate files ???
any information would be of great help. Thanks (8 Replies)
Dear All,
I have an input file like this
interface Serial10/0/7:11.1 point-to-point
description CLIENT:SA_INSTITUTO ANGLO MEXICANO Sitio Metepec 104452:0,165
bandwidth 64
ip vrf forwarding INSTITUTO-ANGLO
ip address 192.168.148.217 255.255.255.252
no ip directed-broadcast
frame-relay... (2 Replies)
Hi all,
i m new to Unix shell scripting(ksh)
i have a requirement, can anyone help me out in this..
spec:
i need to move all the files landing in "X" directory to "Y" directory automatically everyday at a particular time.. (5 Replies)
Hi All,
I need to split a flatfile based on it's first character, I am using the following script
awk '{print > "TEST_substr($0,1,1).txt"}' PROVIDER.txt
It is returning files
TEST_1 and
TEST_2
But I am not getting the .txt file extension.
I need the files like
TEST_1.txt and ... (1 Reply)
Can anyone please help me to create the output file based on the attached input files using ksh script.
I have 2 input files
1) inputfile1.txt
2) inputfile2.txt
The script should accept 2 parametes:
1. Inputfile2.txt with 1-10,000 values ( sample file contains only 4 records)
2. Script... (5 Replies)
Discussion started by: vinus
5 Replies
LEARN ABOUT DEBIAN
sql::reservedwords
SQL::ReservedWords(3pm) User Contributed Perl Documentation SQL::ReservedWords(3pm)NAME
SQL::ReservedWords - Reserved SQL words by ANSI/ISO
SYNOPSIS
if ( SQL::ReservedWords->is_reserved( $word ) ) {
print "$word is a reserved SQL word!";
}
DESCRIPTION
Determine if words are reserved by ANSI/ISO SQL standard.
METHODS
is_reserved( $word )
Returns a boolean indicating if $word is reserved by either "SQL:1992", "SQL:1999" or "SQL:2003".
is_reserved_by_sql1992( $word )
Returns a boolean indicating if $word is reserved by "SQL:1992".
is_reserved_by_sql1999( $word )
Returns a boolean indicating if $word is reserved by "SQL:1999".
is_reserved_by_sql2003( $word )
Returns a boolean indicating if $word is reserved by "SQL:2003".
reserved_by( $word )
Returns a list with SQL standards that reserves $word.
words
Returns a list with all reserved words.
EXPORTS
Nothing by default. Following subroutines can be exported:
is_reserved
is_reserved_by_sql1992
is_reserved_by_sql1999
is_reserved_by_sql2003
reserved_by
words
SEE ALSO
SQL::ReservedWords::DB2
SQL::ReservedWords::MySQL
SQL::ReservedWords::ODBC
SQL::ReservedWords::Oracle
SQL::ReservedWords::PostgreSQL
SQL::ReservedWords::SQLite
SQL::ReservedWords::SQLServer
ISO/IEC 9075:1992 Database languages -- SQL
ISO/IEC 9075-2:1999 Database languages -- SQL -- Part 2: Foundation (SQL/Foundation)
ISO/IEC 9075-2:2003 Database languages -- SQL -- Part 2: Foundation (SQL/Foundation)
AUTHOR
Christian Hansen "chansen@cpan.org"
COPYRIGHT
This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.8.8 2008-03-28 SQL::ReservedWords(3pm)