|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Sqlplus
Post 302088702 by mukundranjan on Thursday 14th of September 2006 12:34:10 AM
09-14-2006
Hi,
see cursor only require when you have to traverse in between the records fetched from Table using select command. yeaa obviously cursor only be defined using select command only because it is something like a pointer in memry location where jump on evry row. yeaa it is a common practice to open a cursor to run a loop.
see commit will be used to fix your changes. you can commt later also it does n't have an business with your procedure and loop, but it certainly ensure security.
Thanks
Mukund Ranjan.
see cursor only require when you have to traverse in between the records fetched from Table using select command. yeaa obviously cursor only be defined using select command only because it is something like a pointer in memry location where jump on evry row. yeaa it is a common practice to open a cursor to run a loop.
see commit will be used to fix your changes. you can commt later also it does n't have an business with your procedure and loop, but it certainly ensure security.
Thanks
Mukund Ranjan.
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello,
I'm trying to write a script that will loop a sql statement through an external list. Basically, the script enters a loop and runs the sql statement for each entry in the list file. Currently, the script will stop at a cursor where I can then manually enter the SQL statment. This is... (11 Replies)
Discussion started by: MadHatter
11 Replies
2. Shell Programming and Scripting
I am looking to loop round a load of files and execute each in sqlplus, I have looked at the forum to see what was posted in the past, but most of the examples seem to use the sql being passed in through the script, which is not really what I am looking for, can someone tell me if the code below is... (9 Replies)
Discussion started by: LiquidChild
9 Replies
3. HP-UX
i am new working with hp-ux but i had to because of my job.
so i want to execute some sql scripts but
when i call sqlplus to run them it responds
/sbin/sh: sqlplus not found.
i have oracle 8.1.7 installed.
what should i do
sorry if this sounds too easy but i am now learning.
The same... (13 Replies)
Discussion started by: theodore
13 Replies
4. Shell Programming and Scripting
I am running a script that invokes SQLPLUS. During the execution I get the following:
SQL*Plus: Release 9.2.0.8.0 - Production on Mon Jun 11 16:12:50 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 -... (3 Replies)
Discussion started by: ssmith001
3 Replies
5. Shell Programming and Scripting
Hi All,
I am facing a strange problem on one of my unix servers.
When i try to login using the standard method:
it fails with below message
>sqlplus REF1SSTDBO1/REF1SSTDBO1@TKS3N10G
> TKS3N10G
ksh: TKS3N10G: not found
But it works perfectly when i escape with ;\
>sqlplus... (3 Replies)
Discussion started by: kunwar
3 Replies
6. AIX
Hi guys,
Here is the error i get by running a "sqlplus -v" after installing an oracle client 10.2.0.5 on an AIX 5.3.9 server.
Could not load program sqlplus:
Symbol resolution failed for sqlplus because:
Symbol __pthread (number 307) is not exported from dependent
... (3 Replies)
Discussion started by: Chapel
3 Replies
7. Shell Programming and Scripting
Hi,
This is the content in my .profile on a unix server,
MAIL=/usr/mail/${LOGNAME:?}
umask 027 #added by enRole Agent
PATH=${PATH}:/opt/app/p1crm1c3/informatica/oracle/product/10.2.0
export PATH
PATH=$PATH:/opt/app/p1crm1c3/informatica/oracle/product/10.2.0/network/admin/sqlnet.ora;export... (2 Replies)
Discussion started by: yohasini
2 Replies
8. Shell Programming and Scripting
When i run the following script am getiing the output correct but i want to get it in the form of a table, could any one help me please. the script is a s follows
count=`sqlplus -s $ORACLE_ACCOUNT << EOF
set heading off
set wrap on
set feedback off
column ChangeNumber format a12
column... (9 Replies)
Discussion started by: jhon1257
9 Replies
9. Shell Programming and Scripting
i am using bash shell
Whenever i declare an array, and then using sqlplus, i am getting sqlplus error and return code 127.
IFS=","
declare -a Arr=($Variable1);
SQLPLUS=sqlplus -s "${DBUSER}"/"${DBPASS}"@"${DBASE}
echo "set head off ; " > ${SQLCMD}
echo "set PAGESIZE 0 ;" >> ${SQLCMD}... (6 Replies)
Discussion started by: arghadeep adity
6 Replies
10. UNIX and Linux Applications
Hi all,
i face an error related to my server ""it's running server"" when i use sqlplus command
$ sqlplus
bash: sqlplus: command not found
the data base is up and running i just need to access the sqlplus to import the dump file as a daily backup.
i already check the directory... (4 Replies)
Discussion started by: clerck
4 Replies
LEARN ABOUT DEBIAN
keynav
KEYNAV(1) General Commands Manual KEYNAV(1) NAME
keynav - a keyboard-driven mouse cursor mover SYNOPSIS
keynav DESCRIPTION
Keynav makes your keyboard a fast mouse cursor mover. You can move the cursor to any point on the screen with a few key strokes. It also simulates mouse click. You can do everything mouse can do with a keyboard. HOW TO USE
Run keynav, and activate it by pressing Ctrl+; (semicolon). You should see a thin frame on the screen with a cross in it. Default configuration: * h : select the left half of the region * j : select the bottom half of the region * k : select the top half of the region * l : select the right half of the region * Shift+h : move the region left * Shift+j : move the region down * Shift+k : move the region up * Shift+l : move the region right * Semicolon: move the cursor to the center of the selected region * Spacebar : move the cursor and left-click * Escape : cancel the move CONFIGURATION
You can configure your own key setting. There is an example in /usr/share/doc/keynav/keynavrc. Copy it to $HOME/.keynavrc and edit it as you like. CONFFILE COMMANDS
* start : activate keynav * end : deactivate keynav * cut-left : select the left half of the region * cut-right : select the right half of the region * cut-up : select the top half of the region * cut-down : select the bottom half of the region * move-left : move the region left * move-right : move the region right * move-up : move the region up * move-down : move the region down * warp : move the cursor to the center of the selected region * click 1 : left-click * click 2 : middle-click * click 3 : right-click * doubleclick 1: left-click twice quickly * doubleclick 2: middle-click twice quickly * doubleclick 3: right-click twice quickly * drag <button> [keyseq]: toggle dragging mode for the given button Example: "drag 1 alt" to do a alt+click-drag * grid <rows>x<columns> : change the grid layout of the selection Example: "grid 2x3" to cut screen to 6 cells * cell-select <row>x<column>: select a specific cell in the grid * cell-select <cell> : select a specific cell in the grid AUTHOR
keynav was written by Jordan Sissel <jls@semicomplete.com>. This manual page was written by Wen-Yen Chuang <caleb@calno.com>, for the Debian project (but may be used by others). KEYNAV(1)