Not sure if that would work, but ain't it better (in terms of readability and simplicity) to invert the whole thing and use RavinderSingh13's regex E.g.
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)
Hi,
I wrote a simple shell script which accepts the input value yearmonth in the format YYYYMM and displays the date as YYYY-MM-DD.Day will be 01 always.Please find the code below
#!/bin/ksh
export yearmonth_date=$1
print_usage() {
echo "usage: ${0##*/} <yearmonth_date> \n" \
... (1 Reply)
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)
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)
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)
Hi Experts,
I have a data with multiple entry , I want to filter PKG= & the last column "00060110" or "00088150" in the output
file:
###############################################################################################
PKG= P8SDB :: VGS = vgP8SOra vgP8SDB1 vgP8S001... (5 Replies)
Using ksh, I am using SQLPlus to execute a query with a filter using a string variable.
REPO_DB=DEV1
FOLDER_NM='U_nmalencia'
FOLDER_CHECK=$(sqlplus -s /nolog <<EOF
CONNECT user/pswd_select@${REPO_DB}
set echo off heading off feedback off
select subj_name
from subject
where... (5 Replies)
Hii,
I am reading data from files by defining path as *.log etc,
Files names are like app1a_test2_heep.log , cdc2a_test3_heep.log etc
How to configure logstash so that the part of string that is string before underscore (app1a, cdc2a..) should be grepped and added to host field and... (7 Replies)
Discussion started by: Ravi Kishore
7 Replies
LEARN ABOUT DEBIAN
bp_einfo
BP_EINFO(1p) User Contributed Perl Documentation BP_EINFO(1p)NAME
einfo.pl - query einfo to find all available databases or information about a
specific database (field information or links to other NCBI
databases)
SYNOPSIS
einfo [-d database] [-f Field Code] [-l Link Name] [-o outfile]
DESCRIPTION
Command line options:
-e/--email
Valid email (required by NCBI policy)
-d/--db/--database
NCBI database to query
(default = none, which shows available databases)
-f/--field
print out information about a specific field code
(default = none)
-l/--link
print out information about a specific link name
(default = none)
-o/--out
outfile
(default = STDOUT)
-h/--help
show this documentation
As per NCBI's policy regarding eutils access, a valid email is required. This is not enforced here (if one is provided you will get a
standard warning), but don't be surprised if this doesn't work after June 1, 2010 unless one is supplied.
If -d is not specified, field and link arguments are ignored and all available databases are printed instead.
If either link names or field codes (or both) are specified, nothing else is printed out (only the info requested). You can specify as
many fields and/or links as you want by using multiple -f/-l <ARG> on the command line.
AUTHOR - Chris Fields
Chris Fields cjfields at bioperl dot org
perl v5.14.2 2012-03-02 BP_EINFO(1p)