10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
cat a1
scott
robert
tom
test
script :
#!/usr/bin/ksh
for NAME in `cat a1`
do
VALUE=`sqlplus -silent "nobody/bobody01@testq" <<END
set pagesize 0 feedback off verify off heading off echo off
select username from dba_users where username=upper('$NAME');
END`
if ; then
echo... (3 Replies)
Discussion started by: jhonnyrip
3 Replies
2. Programming
Hi,
I am trying to get the oracle variables and pass the values in sql placed in procedure.
VARIABLE
vstat='ASDS,FGDS,VCGD,VCXC'
Query :
select distinct dept from College
where section in ('C','D')
AND CODES =''
AND NAMES IN ('RAJ','SAM');
I want CODES values to be taken from vstat... (1 Reply)
Discussion started by: Perlbaby
1 Replies
3. Shell Programming and Scripting
Please help me how to pass some unix vairable to oracle. I have used below , but not displaying passed (inval) value.
calling()
{
sqlplus -s $1/$2@$3 <<EOF
begin
exec call_sql($4);
end;
exit
EOF
}
calling user pwd inst value1... (17 Replies)
Discussion started by: Jairaj
17 Replies
4. UNIX for Dummies Questions & Answers
I have an Oracle concurrent program that I'm passing a parameter to a unix shell script. An example value of the Oracle parameter is PO_TOP. The Oracle parameter represents the unix env var PO_TOP, meaning, on the unix side there is env var called PO_TOP (ex value: /oradev/apps/po/11.0.3/). My... (7 Replies)
Discussion started by: Mark_Wright
7 Replies
5. Shell Programming and Scripting
using the script below I want to pass a parameters thorugh my sql
call(@/unixsxxx/xxxx/helpenv.sql emptab ) as input into an oracle procedure xxxx_package.proc1(%1,emptab); . I tried %1 but it does not work. Any suggestions.
#!bin/ksh
set -x
#
export... (0 Replies)
Discussion started by: TimHortons
0 Replies
6. Shell Programming and Scripting
Hi,
I have a function that hold 3 arrayies.
I need to pass them to another function as an input, for further use
Could you please explain how to do that.
Thanks (5 Replies)
Discussion started by: yoavbe
5 Replies
7. Shell Programming and Scripting
Hi,
I have screen which was desined in PL/SQL Catridges in apps. In that screen some enterable fields these values r the passing parameters to create value sets, functions, menus etc in apps by using front end screens. Now in that screen i have a button. when i click that button it have to... (0 Replies)
Discussion started by: rajasekharamy
0 Replies
8. Shell Programming and Scripting
Hi All,
Does anyone have any solutions for passing back multiple variables back to the SHELL from a call to an ORACLE procedure:
eg
#username='scott'
#password='tiger'
#database='orcl'
username='ITGCD03D03'
password='tC5epIew'
database='ITGCD03D'
sqlplus -s... (4 Replies)
Discussion started by: satnamx
4 Replies
9. Shell Programming and Scripting
Hi all...
Im looking to pass the contents of a simple file to Oracle so that it can be stored in a database table.
The best way i can think of to avoid overhead is to loop through the contents of the file and store the data in a bash array. then the array can be passed to SQL Plus where... (4 Replies)
Discussion started by: satnamx
4 Replies
10. Shell Programming and Scripting
Is it possible to pass unix shell arrays in Oracle stored procedure?
Is yes, how?
Thanks (6 Replies)
Discussion started by: superprogrammer
6 Replies
omega(6) Games Manual omega(6)
NAME
omega - a hack-style game with quests.
SYNOPSIS
omega [save file]
DESCRIPTION
omega is a complex rogue-style game of dungeon exploration. Unlike other such games, there are a number of ways to "win", depending on
various actions taken during play. The ways you can get your name on the hiscore board include becoming the highest ranked head of a guild,
sect, college, etc., as well as gaining the most points figured from possessions and experience. The game (via the oracle) may impose some
structure on your exploration, but you need not follow all of the oracle's advice. There *is* a "total winner" status, by the way.
If the save file is not specified, omega gives the player the choice of generating a random character, or playing themselves, doing a short
quiz to determine an approximation of their abilities. If the save file is given, omega will restore that save file, and if successful,
the save file is deleted. Note that some installations of omega compress the save file, using either compress(1) or gzip(1) - if this is
the case, and you have a save file that is uncompressed (such files are generated by omega if it receives a signal during play, for exam-
ple), you can compress it (with compress(1) or gzip(1)) and remove the .Z or .gz extension. Alternatively, you may simply run with the
uncompressed save file - this will not affect the game in any way, but takes more disk space between games.
omega offers a richness of playing detail that goes beyond a simple game like rogue. However, the majority of gameplay is very similar to
rogue, hack, ultrarogue, larn, and other such games. The player is represented by the highlighted "@" symbol, objects and terrain features
are represented by non-alphabetic symbols, monsters are represented by the various upper and lower case letters, and other humans are rep-
resented by a non-highlighted "@".
omega currently consists of a countryside in which are sited a city, various villages, several dungeons, and some "special" sites, such as
the temples of the various priesthoods. The game starts in the city of Rampart, where all the guilds have headquarters. As a dungeon is
explored, all generated levels are saved in memory. However, only one dungeon is "remembered" at a time, so if you enter two dungeons, the
first will be forgotten (it will be regenerated should you wish to enter it again). However, if a dungeon is "completed", this fact will be
remembered, basically meaning that the unique monster at the bottom will not be regenerated if you've killed it already.
SEE ALSO
compress(1), gzip(1), nethack(6)
AUTHOR
Laurence Brothers
omega(6)