Sponsored Content
Full Discussion: Unix oracle script
Top Forums Shell Programming and Scripting Unix oracle script Post 302647601 by guruprasadpr on Monday 28th of May 2012 11:22:55 AM
Old 05-28-2012
@scrutinizer: Thanks for pointing it out.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Executing a Oracle SQL statement in a UNIX script

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

Unix shell script Certification for oracle developer.

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

return code from oracle to unix script

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

Delete oracle table from UNIX script

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

How to fetch data from oracle in unix shell script

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

Need to access Oracle DB with shell/perl script in Unix

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

PROBLEM WITH ORACLE QUERY IN UNIX SCRIPT

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

Use of Oracle pl/sql in UNIX shell script

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

How to pass Oracle sql script as argument to UNIX shell script?

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

Executing Oracle script from UNIX Script

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
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
All times are GMT -4. The time now is 10:34 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy