I have a problem. I want to launch a different sql queries for different shell parameter values, something like this.
The problem is that the first sqlplus connection does not finish (with SQL string) and the rest of the code is considered "A" case, esac included. So case statment is bad defined.
Anyone can help me? I was looking inside this forum and I didnīt find something similar
Hi People,
I need some Help to write a unix script that asks for a sentence to be typed out then with the sentence. Counts the number of spaces within the sentence and then echo's out "The Number Of Spaces In The Sentence is 4" as a example
Thanks
Danielle (12 Replies)
echo "please enter ur choice..
1. Make a file.
2. Display contents
3. Copy the file
4. Rename the file
5. Delete the file
6. Exit"
read choice
case $choice in
1 ) echo enter the file name
read fname
if
then
echo... (2 Replies)
I have the following script:
For catching errors like:
But the regular expression ERROR*memory inside case doesn't seem to be working.
The output of bash -x scriptname is:
Please help (5 Replies)
I tried this:
for region in 'raj' 'kt' 'kol' 'krl' 'chn' 'dl' 'hr' 'bih' 'ap'
do
sqlplus -s huw$region/`echo $region`huw#321@huw$region<<!
set serveroutput on
begin
select count(*) from tcd_preferred_cust_201109
end;
/
exit;
done
but the error shows like:
Syntax error at line 4 :... (1 Reply)
Hi,
I have an SQL query that returns a substring of a field and I want to work a case statement on it, but either I get a syntax error or in it's current manifestation the case is ignored all together.
select distinct dbms_lob.substr(msg_body,1,4) as networkId,
A_STATUS, count(*) from... (1 Reply)
hi,
i have a requirement where i need to connect sqlplus from unix and i am able to do so by following command:
cust_count=`sqlplus -s $ORACLE_USER/$ORACLE_PASS@$ORACLE_SID << EOF
set pagesize 0
set feedback off
set verify off
... (1 Reply)
Hi ALL,
I am receving a "strange" error using a nested if within an sql operation inside:
./dom.ksh: syntax error at line 80 : `then' unmatched
This is all my script code: in bold the step receiving the error.
Any help would really aprrecieted ......!
**** I have tried all the... (2 Replies)
Hi,
facing an issue while calling sqlplus inside shell script. It for some reason goes to tmp file to write something and i get error as permission denied as i dont have access there.
ANy idea why sqlplus writes in /tmp and how to change or stop this ? (2 Replies)
Hi all,
I'm using below code
processId=`sqlplus -s ${sysuser}/${syspwd} <<CHK_PROCESS
whenever sqlerror exit sql.sqlcode;
set head off feedback off echo off pages 0
SELECT PROCESS_ID FROM LSHADMIN.DATA_DOMAIN WHERE DOMAIN_NAME = '${tabname}'
... (8 Replies)
Discussion started by: Pratiksha Mehra
8 Replies
LEARN ABOUT LINUX
stdlib
STDLIB(7) Erlang Application Definition STDLIB(7)NAME
STDLIB - The STDLIB Application
DESCRIPTION
The STDLIB is mandatory in the sense that the minimal system based on Erlang/OTP consists of Kernel and STDLIB. The STDLIB application con-
tains no services.
CONFIGURATION
The following configuration parameters are defined for the STDLIB application. See app(5) for more information about configuration parame-
ters.
shell_esc = icl | abort :
This parameter can be used to alter the behaviour of the Erlang shell when ^G is pressed.
restricted_shell = module() :
This parameter can be used to run the Erlang shell in restricted mode.
shell_catch_exception = bool() :
This parameter can be used to set the exception handling of the Erlang shell's evaluator process.
shell_history_length = integer() >= 0 :
This parameter can be used to determine how many commands are saved by the Erlang shell.
shell_prompt_func = {Mod, Func} | default :
where
* Mod = atom()
* Func = atom()
This parameter can be used to set a customized Erlang shell prompt function.
shell_saved_results = integer() >= 0 :
This parameter can be used to determine how many results are saved by the Erlang shell.
SEE ALSO app(5) , application(3erl) , shell(3erl) ,
Ericsson AB stdlib 1.17.3 STDLIB(7)