06-12-2006
Please search the forum. This one question has been answered at least five different times in the past week.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I am calling an oracle function that returns a number (either 0 or 2), how do I pass that pass to the wrapping shell script as I would like to do other things based on the value returned by the oracle function.
Your help will be appreciated.
--------------------------
sqlplus / <<... (3 Replies)
Discussion started by: Jtrinh
3 Replies
2. UNIX for Dummies Questions & Answers
how to pass values from oracle sql plus to unix shell script (2 Replies)
Discussion started by: trichyselva
2 Replies
3. UNIX for Advanced & Expert Users
hi fellows,
can any body tell me how to pass unix variables to oracle
code is...
#! /bin/ksh
echo ENTER DATE VALUE's
read START_DATE END_DATE
sqlplus xyx/abc@oracle
select * from table1 where coloumn1 between $START_DATE and $END_DATE;
is this is correct way...........
Thanks in... (1 Reply)
Discussion started by: chiru
1 Replies
4. UNIX for Advanced & Expert Users
I am having a file which has the following data
123424
2354235
142424
43423
1434
.
.
.
.
etc
i want to pass these values to oracle at a time by using a file.. can someone suggest me a answer...
waiting...... (1 Reply)
Discussion started by: vidyadhar85
1 Replies
5. Shell Programming and Scripting
Hi
i am calling a stored procedure from unix shell like this call
test_proc('0002','20100218');
the stored procedure was giving output
like this dbms_output.put_line(' processed earlier');
i want to see the output in the unix shell where i called.
Thanks
barani (6 Replies)
Discussion started by: barani75
6 Replies
6. 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
7. UNIX for Dummies Questions & Answers
i had this unix korn shell code that connects to oracle database and execute the oracle procedure. i need to add a variable that indicates the oracle procedure failed. basically the variable is to check if the oracle procedure failed it will assign 1 and when the variable is equal to 1 it will not... (4 Replies)
Discussion started by: wtolentino
4 Replies
8. Shell Programming and Scripting
Hello All,
I need to export various variables in UNIX. But the values of those variables will come from Oracle.
Say i have Oracle query:
Select
file_id, file_desc, file_freq_cd, load_table_nm, load_stored_procd_nm, load_proc_typ_nm, err_rec_cnt_thrsld_nbr, file_expc_rec_cnt From Table1... (7 Replies)
Discussion started by: Arun Mishra
7 Replies
9. Shell Programming and Scripting
Hello,
I am trying to execute an SQL query from shell script.
A part of script is something like this:
fromDate=`echo $(date +"%F%T") | sed "s/-//g" | sed "s/://g"`
$ORACLE_HOME/sqlplus -s /nolog <<EOD1
connect $COSDBUID/$COSDBPWD@$COSDBSID
spool... (4 Replies)
Discussion started by: sanketpatel.86
4 Replies
10. Shell Programming and Scripting
Hi all,
$ echo $SHELL
/bin/bash
Requirement - How to pass oracle sql script as argument to unix shell script?
$ ./output.sh users.sql
Below are the shell scripts and the oracle sql file in the same folder.
Shell Script
$ cat output.sh
#!/bin/bash
.... (7 Replies)
Discussion started by: a1_win
7 Replies
LEARN ABOUT DEBIAN
omega-rpg
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)