05-28-2012
@scrutinizer: Thanks for pointing it out.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
I need to select one column from a table based upon the passed in parameter.
I tried this:
sqlplus -silent $MISP_USER << EOF
set feedback off;
set verify off;
set sqlprompt ""
SELECT mail_flag
FROM dailyjobs
WHERE job_name = '$1';
exit 0
EOF
exit... (1 Reply)
Discussion started by: ganga.dharan
1 Replies
2. UNIX for Dummies Questions & Answers
hi friends,
I would like to do the certification in Korn shell scripts { i am using HP UNIX machine }. is there any certification for UNIX shell script . If yes please tell me the details . i am junior level oracle plsql developer . i interseted in unix shell scripting . i need... (1 Reply)
Discussion started by: rdhaprakasam
1 Replies
3. HP-UX
Hi
I'm writing a shell script that connects to oracle database and fires query to check the availability of data in a table. In case of no data found then what will be the return code and how to handle in that in variable. Kindly provide with an example for better understanding... Thanks... (1 Reply)
Discussion started by: ksailesh
1 Replies
4. Shell Programming and Scripting
Hi,
Is it possible to delete oracle table datas using a UNIX script/Shell script?
how can we do this??
I have oracle Database and i have to delete millions of record everyday.. adn it is taking hours togather to execute this. Will the delete query triggered from UNIX be faster can we expect any... (1 Reply)
Discussion started by: Codesearcher
1 Replies
5. Shell Programming and Scripting
Hi,
How to fetch data from oracle database in unix shell scripting.
list=`sqlplus -s ds_user/dsuser@EMI <<EOF
set feedback off
set serveroutput on
set heading off
set pagesize 0
set tab off
select IP_ID from table
/
exit
EOF`
The output is not what i expected.I need output in... (4 Replies)
Discussion started by: Anusha_Reddy
4 Replies
6. Shell Programming and Scripting
Hi,
We need to access Oracle DB with shell/perl script in Unix.
Is Oracle client needed in Unix for this.
I have seen threads which tell abt using SQL plus to access Oracle tables.
Can we access DB without SQL PLus installation using scripts in UNix like we access DB using jar files in Java .... (1 Reply)
Discussion started by: justinacc
1 Replies
7. 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
8. UNIX for Advanced & Expert Users
Hi,
I have basic knowledge on how to write pl/sql code inside shell script.
I am looking for more advance thing. Is there any book for that which can just talk about how to write more advance plsql code inside shell script.
Please help
Thanks!!!!!! (1 Reply)
Discussion started by: diehard
1 Replies
9. 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
10. Shell Programming and Scripting
Hi,
I am new to UNIX and want to execute oracle script from unix script.
I have written below script but i am getting below error.
#!/bin/bash
file="/home/usr/control/control_file1"
while read line
do
#$line=@$line
#echo $line
sqlplus tiger/scott@DB
@$line
exit
#echo "$line"
done... (3 Replies)
Discussion started by: vipin kumar rai
3 Replies
LEARN ABOUT CENTOS
atkbdc
ATKBDC(4) BSD Kernel Interfaces Manual ATKBDC(4)
NAME
atkbdc -- the AT keyboard controller interface
SYNOPSIS
options KBD_RESETDELAY=N
options KBD_MAXWAIT=N
options KBDIO_DEBUG=N
device atkbdc
In /boot/device.hints:
hint.atkbdc.0.at="isa"
hint.atkbdc.0.port="0x060"
DESCRIPTION
The keyboard controller atkbdc provides I/O services for the AT keyboard and PS/2 mouse style pointing devices. This controller is required
for the keyboard driver atkbd and the PS/2 pointing device driver psm.
There can be only one atkbdc device configured in the system.
DRIVER CONFIGURATION
Kernel Configuration Options
The following kernel configuration options can be used to control the atkbdc driver. They may be set in the kernel configuration file (see
config(8)).
KBD_RESETDELAY=X, KBD_MAXWAIT=Y
The keyboard driver atkbd and the pointing device driver psm may ask the atkbdc driver to reset these devices during the boot process.
It sometimes takes a long time before these devices respond to the reset command. These options control how long the atkbdc driver
should wait before eventually giving up -- the driver will wait X * Y msecs at most. If the drivers seem unable to detect devices,
you may want to increase these values. The default values are 200 msec for X and 5 for Y.
KBDIO_DEBUG=N
Sets the debug level to N. The default value is zero, which suppresses all debugging output.
SEE ALSO
atkbd(4), psm(4), config(8)
HISTORY
The atkbdc driver first appeared in FreeBSD 3.1. It is based on the kbdio module in FreeBSD 2.2.
AUTHORS
The kbdio module, the atkbdc driver and this manual page were written by Kazutaka Yokota <yokota@FreeBSD.org>.
BSD
February 9, 1999 BSD