01-28-2011
Hi,
I would've thought that sqlplus's return value will be set according to system events, not internal SQL parsing?
Is it entirely non-functional presently?
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 DEBIAN
make-jpkg
MAKE-JPKG(1) General Commands Manual MAKE-JPKG(1)
NAME
make-jpkg - builds Debian packages from Java binary distributions
SYNOPSIS
make-jpkg [OPTION]... [FILE]
DESCRIPTION
make-jpkg builds a Debian package from the given Java distribution FILE.
Supported java binary distributions currently include:
* Oracle (http://www.oracle.com/technetwork/java/javase/downloads) :
- The J2SE Development Kit (JDK), version 6 (update >= 10), 7
- The J2SE Runtime Environment (JRE), version 6 (update >= 10), 7
- The J2SE API Javadoc, version 6 (update >= 10), 7
(Choose tar.gz archives or self-extracting archives, do _not_ choose the RPM!)
The following options are recognized:
--full-name NAME
full name used in the maintainer field of the package
--email EMAIL
email address used in the maintainer field of the package
--changes
create a .changes file
--revision
add debian revision
--help display help text and exit
--version
output version information and exit
Download a supported Java RE or SDK or API tar.gz or self-extracting archive from http://www.oracle.com/technetwork/java/javase/downloads
and execute make-jpkg file with the downloaded file. The program asks the user for additional information and builds a Debian binary pack-
age in the current directory.
The program requires about 200 MB free disk space in a temporary directory. The temporary directory defaults to /tmp but you can specify an
alternate directory by setting the environment variable TMPDIR.
EXAMPLE
To install Oracle(TM) 7 Standard Edition JDK, download a release - 64 bits version of update 2 from http://www.oracle.com/technet-
work/java/javase/downloads/jdk-7u2-download-1377129.html in this example - and invoke make-jpkg:
make-jpkg <path_to_download_directory>/jdk-7u2-linux-x64.tar.gz
This generate a Debian package in the current directory, that can be installed using dpkg:
dpkg -i oracle-j2sdk1.7_1.7.0+update2_amd64.deb
When you're done, you can delete initial download as well as generated package:
rm <path_to_download_directory>/jdk-7u2-linux-x64.tar.gz oracle-j2sdk1.7_1.7.0+update2_amd64.deb
ENVIRONMENT
TMPDIR base directory used for temporary files (defaults to /tmp)
J2SE_PACKAGE_FULL_NAME
full name used in the maintainer field of the package; if none is supplied then the default of "Debian Java Maintainers" is used.
J2SE_PACKAGE_EMAIL
email address used in the maintainer field of the package; if none is supplied the default of "pkg-java-maintain-
ers@lists.alioth.debian.org" is used.
SEE ALSO
update-java-alternatives(1)
AUTHOR
This manual page was written by Hubert Schmid <j2se-package@z42.de>.
It is now maintained by the Debian Java Maintainers <pkg-java-maintainers@lists.alioth.debian.org>.
January 22, 2012 MAKE-JPKG(1)