03-11-2010
Please state what Operating System and version you have.
Please state what shell you use (e.g. sh, ksh, bash).
Please post what version of Oracle you have.
Please post the script.
Please post what you typed to execute the script.
Please post sample input data (blotting anything confidential).
Please post what you expected to happen.
Please post what actually happened (including any error messages).
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi all,
Iam facing a lot of problem while calling Oracle 10g SQLPLUS files from shell.
What is the standard procedures to be taken care.
Any help would be useful for me.
Thanks in advance,
Ganapati. (2 Replies)
Discussion started by: ganapati
2 Replies
2. UNIX and Linux Applications
Hi,
I want to use sqlplus from server1
sqlplus usr1/pass1@dns1
and I want to connect to an Oracle database from a server2.
Unfortunately the database was created on the server1 and on server2.
So when I use the command just like that...it connects to the database from the server2. ... (2 Replies)
Discussion started by: AngelMady
2 Replies
3. Shell Programming and Scripting
Hello,
This may not be the right place to ask for help for this problem but i might be because i'm using Java & SqlPlus in alot of Kshell scripts.
Just to give a high level picture, i'm basically using Java to control each SqlPlus execute command, by reading a flat file that contains the run... (2 Replies)
Discussion started by: bobk544
2 Replies
4. UNIX for Dummies Questions & Answers
Hi,
I am very new to shell scripting and trying to write a simple shell script in which i am trying to achieve the following:
1. Connect to oracle database hosted on a different server
2. fire a query on the oracle db
3. store the output in a variable
4. use this variable for further logic... (1 Reply)
Discussion started by: shrutihardas
1 Replies
5. Shell Programming and Scripting
Hi,
I am very new to shell scripting and trying to write a simple shell script in which i am trying to achieve the following:
1. Connect to oracle database hosted on a different server
2. fire a query on the oracle db
3. store the output in a variable
4. use this variable for further logic... (26 Replies)
Discussion started by: shrutihardas
26 Replies
6. Shell Programming and Scripting
So, I would like to run differen select queries on multiple databases..
I made a script wich I thought to be called something like..
./script.sh sql_file_name out.log
or to enter select statement in a command line..
(aix)
and I did created some shell script wich is not working..
it... (6 Replies)
Discussion started by: bongo
6 Replies
7. Shell Programming and Scripting
Hello everyone,
I have a RHEL 5 system and have been trying to get a batch of 3-4 scripts each in a separate variables and they are not working as expected.
I tried using following syntax which I saw a lot of people on this site use and should really work, though for some reason it doesn't... (3 Replies)
Discussion started by: rockf1bull
3 Replies
8. Shell Programming and Scripting
I have logged into oracle using SQLPLUS. When I type any kind of query, there is only 1 answer - '2'.
What is wrong with it? (1 Reply)
Discussion started by: Subhasis
1 Replies
9. UNIX and Linux Applications
On psql
select titolo,lingua from titolo where titolo ~* 'brivid';
titolo | lingua
------- + ------
Brivido | 1
On Sqlplus/gqsql
SQL> select titolo,genere,anno,lingua from titolo where titolo like '%rivid%';
TITOLO... (6 Replies)
Discussion started by: Linusolaradm1
6 Replies
10. Shell Programming and Scripting
Apologies if this is the incorrect forum.There is an issue in the function call I am facing while calling the same from a unix shell scripts.
Basically, I want the ref cursor to return values to a variable in sqlpus. The function call is currently saved in a ".txt" file
in a unix location. I want... (7 Replies)
Discussion started by: amvip
7 Replies
LEARN ABOUT DEBIAN
numm.one-bit-instrument
one-bit-instrument(7) Numm Tutorials one-bit-instrument(7)
NAME
one bit instrument - how to make a gnarly synth with numm-run
SYNOPSIS
numm-run FILE
DESCRIPTION
In this tutorial we will learn how to live-code a one-bit synthesizer controlled by mouse position. It is intended as a gentle introduc-
tion to development with numm-run.
To get started, create a text file with the following method stubs:
def audio_out(a):
pass
def video_out(a):
pass
Save the file as onebit.py, and then launch it with numm-run:
numm-run onebit.py
You should see a blank window appear. We will now make some sound and light by changing the value of a in the audio_out and video_out
functions:
def audio_out(a):
a[::100] = 2**15
def video_out(a):
a.flat[::100] = 255
Save the file, and you should see and hear the sketch update. This is using numpy's array-indexing to turn every hundredth audio sample
and pixel-color on. The audio sample rate is by default 44100Hz, so it produces a series of clicks that will be perceived as a 441Hz tone.
We can turn this into an instrument by connecting mouse motion to frequency:
period = 100
def audio_out(a):
a[::period] = 2**15
def video_out(a):
a.flat[::period] = 255
def mouse_in(type,px,py,button):
global period
period = px*1000
Finally, let's use the keyboard to record and jump to notes. The first time you press a key, it records the period, and subsequant depres-
sions play the saved period:
period = 100
record = {}
def audio_out(a):
a[::period] = 2**15
def video_out(a):
a.flat[::period] = 255
def mouse_in(type,px,py,button):
global period
period = px*1000
def keyboard_in(type,key):
global period
if record.has_key(key):
period = record[key]
elif record.has_key(key):
record[] = period
SEE ALSO
numm-run(1), numm.getting-started(7), numm.spectral-analysis(7)
numm February 2012 one-bit-instrument(7)