One of your problems is that the shell is expanding the $VERSION of V$VERSION.
Either escape the $ (V\$VERSION), or stop the shell expanding anything between the "EOFs" by using <<"EOF".
I get this output from the select:
Code:
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for Linux: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production
That makes your awk a problem too. Nothing starts with "a=", and there is no = in the output, so the -F= serves no purpose.
Code:
DB_VERSION=$(sqlplus -s /nolog <<EOF | awk '/^Oracle Database/ { print $7 }'
conn / as sysdba
set head off pagesize 0 feedback off linesize 200
whenever sqlerror exit 1
conn / as sysdba
SELECT * FROM V\$VERSION;
EOF)
:D could any one answer my previous question...
just looked through logg and found no such question that I had asked.. please any input would help \..
:confused: (2 Replies)
linux fedora core2
:) i am trying to write a script to clear, date, pwd and tty a linux termnal or konsole.. when I test the tty against $0 i am, getting a premission denied on the terminal that I am trying to printf to.. I tried using an awk command, test condition, an if then fi clause, but... (6 Replies)
Hi All
Plz guide me in setting ssh on local machine so that password will not be asked.
I have written a script abc.ksh on machineA to execute a script sampletest.ksh available on machineB
Conent of abc.ksh is as follows
ssh -q bali@machineB sh ClaimGenFeed/claim/sampletest.ksh... (1 Reply)
Dear All
i am working on windows plattform and i am interested in Aix so i have done IBM Aix certification, can you please suggest Aix filed is good for my carrier,currently i am working as Desktop admin
edit by bakunin: please understand that the question you raised has nothing to do with the... (1 Reply)
Hi,
Whenever I open my unix box,after providing username and password I get the following message.
Are you authorised to use this computer as detailed above? (Y)es/(N)o : y
Export: Release 10.2.0.2.0 - Production on Mon May 16 16:00:15 2011
Copyright (c) 1982, 2005, Oracle. All rights... (5 Replies)
i have tried to use a sudo command from a user level . but instead of asking for user password it asked for root password . how should i go about it .
james@opensuse:/etc> sudo ifconfig
root's password:
And i wish to ask how should i allow a list of command to be allowed to used for a... (4 Replies)
Hi,
I have an unexpected reboot happening on a Debian 9.9 server.
Yesterday 2019-12-01 at 8:30:34 a reboot happened without me or my team being aware:
/var/log/syslog:Dec 1 08:30:34 xxxx shutdown: shutting down for system reboot
/var/log/syslog:Dec 1 08:30:34 xxxx init: Switching to... (4 Replies)
Discussion started by: chebarbudo
4 Replies
LEARN ABOUT CENTOS
perl::critic::policy::modules::requireversionvar
Perl::Critic::Policy::Modules::RequireVersionVar(3) User Contributed Perl Documentation Perl::Critic::Policy::Modules::RequireVersionVar(3)NAME
Perl::Critic::Policy::Modules::RequireVersionVar - Give every module a "$VERSION" number.
AFFILIATION
This Policy is part of the core Perl::Critic distribution.
DESCRIPTION
Every Perl file (modules, libraries, and programs) should have a package-scoped $VERSION variable. The $VERSION allows clients to insist
on a particular revision of your file like this:
use SomeModule 2.4; #Only loads version 2.4
This Policy scans your file for any package variable named $VERSION. I'm assuming that you are using "strict", so you'll have to declare
it like one of these:
our $VERSION = 1.0611;
$MyPackage::VERSION = 1.061;
use vars qw($VERSION);
use version; our $VERSION = qv(1.0611);
Perl's version system does not recognize lexical variables such as
my $VERSION = 1.0611;
so they are not accepted by this policy.
A common practice is to use the "$Revision: 4126 $" keyword to automatically define the $VERSION variable like this:
our ($VERSION) = '$Revision: 4126 $' =~ m{ $Revision: s+ (S+) }x;
CONFIGURATION
This Policy is not configurable except for the standard options.
NOTES
Conway recommends using the "version" pragma instead of raw numbers or 'v-strings.' However, this Policy only insists that the $VERSION be
defined somehow. I may try to extend this in the future.
TO DO
Add check that $VERSION is independently evaluatable. In particular, prohibit this:
our $VERSION = $Other::Module::VERSION;
This doesn't work because PAUSE and other tools literally copy your version declaration out of your module and evaluates it in isolation,
at which point there's nothing in "Other::Module", and so the $VERSION is undefined.
AUTHOR
Jeffrey Ryan Thalhammer <jeff@imaginative-software.com>
COPYRIGHT
Copyright (c) 2005-2011 Imaginative Software Systems. All rights reserved.
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. The full text of this license
can be found in the LICENSE file included with this module.
perl v5.16.3 2014-06-09 Perl::Critic::Policy::Modules::RequireVersionVar(3)