02-03-2011
That could work.
But the output of the statement is
1
----------------------
1
so when I do a grep on the 1 it will also write to the logfile when the date in that file is the date and time are 10:11:00
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
This query is For HP-UX 11i server.
I have certain oracle process that are running on my system as below :-
rotmgr 3986 1 0 07:49:33 ? 0:00 oracleedjlive (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
rotmgr 26356 1 0 08:14:32 ? 0:00 oracleedjlive... (4 Replies)
Discussion started by: kpatel786
4 Replies
2. Shell Programming and Scripting
Hi,
I have a requirement as below which needs to be done viz UNIX shell script
(1) I have to connect to an Oracle database
(2) Exexute "SELECT field_status from table 1" query on one of the tables.
(3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)
Discussion started by: balaeswari
6 Replies
3. Shell Programming and Scripting
Hello,
Can someone please advise me how to put the db2 query reult into an array?
For example, the query reults are:
string A
string B
string C
Then how do I put them into array=string A
array=string B
... (2 Replies)
Discussion started by: hanul
2 Replies
4. Programming
How can i modify the below to search for the things i'm looking for during a certain time frame?
select Node, NodeAlias, Summary, Tally, AlertKey, AlertGroup, Manager, Agent from mrtg_alerts where LastOccurrence > '5-Dec-2010' order by Manager desc;
In this particular case, this query is... (3 Replies)
Discussion started by: SkySmart
3 Replies
5. Shell Programming and Scripting
Guys can anyone just tell me whether i can pass a value(from UNIX SCRIPT) as an ARGUMENT in Oracle Query?
e.g.
echo "enter value"
read value
insert into tablename where col=$value /*something like this*/ (1 Reply)
Discussion started by: subodh.thakar
1 Replies
6. Shell Programming and Scripting
hi Guys,
i have a problem with oracle query in my unix script..
I'm getting the following error while executing..
./logtab.sh: sqlplus -s "pmutv/pmutv1" << EOFSQL^Jset head off^Jinsert into... (2 Replies)
Discussion started by: apple2685
2 Replies
7. Shell Programming and Scripting
Hi,
I am new to perl.How to query oracle database with perl???
Thanks (1 Reply)
Discussion started by: tdev457
1 Replies
8. Shell Programming and Scripting
Hi,
I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database.
For instance:
USER CITY
--------- ----------
A CITY_A
B CITY_B
C ... (2 Replies)
Discussion started by: DevendraG
2 Replies
9. Programming
Dear community,
I have to make a query from a database and apply the following filter:
select filed1,field2,field3
from database
where (field1 contains only alphanumeric chars and NOT only numbers)
Let me explain better what I Need:
21test ==> OK
test ==> OK
test21 ==> OK
te21st ==>... (6 Replies)
Discussion started by: Lord Spectre
6 Replies
10. IP Networking
We tried to use to connect to DB using jdbc:Oracle:Oci8:@<SERVICE-A>. Connection fail / refuse with one DB .But its working with other databases.
But through toad, jdbc thin client were able to connect. But this has happen suddenly and were able to connect previously. How to navigate this... (0 Replies)
Discussion started by: udara
0 Replies
LEARN ABOUT SUSE
grep-changelog
grep-changelog(1) General Commands Manual grep-changelog(1)
NAME
grep-changelog - print ChangeLog entries matching criteria
SYNOPSIS
grep-changelog [options] [CHANGELOG...]
DESCRIPTION
grep-changelog searches the named CHANGELOGs (by default files matching the regular expressions ChangeLog and ChangeLog.[0-9]+) for
entries matching the specified criteria. At least one option or file must be specified. This program is distributed with GNU Emacs.
OPTIONS
The program accepts unambiguous abbreviations for option names.
--author=AUTHOR
Print entries whose author matches regular expression AUTHOR.
--text=TEXT
Print entries whose text matches regular expression TEXT.
--exclude=TEXT
Exclude entries matching regular expression TEXT.
--from-date=YYYY-MM-DD
Only consider entries made on or after the given date. ChangeLog date entries not in the "YYYY-MM-DD" format are never matched.
--to-date=YYYY-MM-DD
Only consider entries made on or before the given date.
--rcs-log
Print output in a format suitable for RCS log entries. This format removes author lines, leading spaces, and file names.
--with-date
In RCS log format, print short dates.
--reverse
Show matches in reverse order.
--version
Display version information.
--help Display basic usage information.
COPYING
Copyright (C) 2008, 2009 Free Software Foundation, Inc.
Permission is granted to make and distribute verbatim copies of this document provided the copyright notice and this permission notice are
preserved on all copies.
Permission is granted to copy and distribute modified versions of this document under the conditions for verbatim copying, provided that
the entire resulting derived work is distributed under the terms of a permission notice identical to this one.
Permission is granted to copy and distribute translations of this document into another language, under the above conditions for modified
versions, except that this permission notice may be stated in a translation approved by the Free Software Foundation.
grep-changelog(1)