Search Results

One place I hang around as often as I do here is TEK-TIPS.com (https://www.tek-tips.com). I was most active there in the database parts there but it became very quite lately.
My reason to register...

Another important information is how the scripts are started.
Would it be possible to have a wrapper script to start those 3 scripts in background and use the wait command to wait for all of them to...

Your requirement is a bit confusing for me. That's why I'd like to take one step back to evaluate possible solutions.
You say you need the results of sqlscript1 in sqlscript2.
In order to offer...

The pipe feeding the loop does nothing useful because the filenames are picked by matching the pattern you give after in with the content of your current directory.
Arguments for commands and...

Your goal is to loop through all tables in schema HR, count the records and display the results? The reason your procedure shows the error is because tab_var and not the content of the variable with...

Basically there is no need to prefix the script with a shell - if you leave it out, your current shell will be used. But different shells use different syntax. So naming which shell to use ensures...

You prefix sh when you want a specific shell to be used to interpret the script and not the current shell of the current user, no matter if interactive or as crontab entry.

So now you're in the situation Robin (rbatte1) warned you about.
What have you tried so far to find the cause? Did you see any diagnostic message when you ran the script? What was the return code?...

You can tell the ls command to display one file per line.
cd /Applications
ListApps=$(ls -1)
echo "$ListApps" | mail -s "Application Check" myself@myemail.com

Hi,
you see the syntax error because there is a space missing: [$c = $a ] should be [ $c = $a ]. The else branch is never hit because $a either matches $b or it doesn't. Maybe you mixed up the OR...

Hi,
the effect you see is caused by the way you feed your loop. The pipe creates a subshell which has its own copies of the variables, the ones in the parent shell are not affected by actions in the...

am24, do you see a syntax error when you use the commands in your first post or what does "unable to do it" mean?
When you asign a value to a variable there are no spaces allowed around the equal...

Most of the undesired output will be surpressed when you call sqlplus with the -s option.
Setting feedback off will get rid of the no rows selected message - btw. your output shows you executed 2...

My man page tells me this:

The mysql-documentation (http://dev.mysql.com/doc/refman/5.7/en/update.html) tells you in detail how to formulate the statment. For you example, if you'd like to change Lacatus age to 58 it would...

Hi,
to connect to all 5 databases you have to put the sqlplus command inside the loop and have the variables ORACLE_SID and ORACLE_HOME assigned. Your script assigns ORACLE_SID 5 times, overwriting...

What is the data type of the columns involved? If it's LONG, CLOB, NCLOB or XMLType the default width is set by LONGCHUNKSIZE of LONG, whichever is smaller.
To ignore the default width use the...

There are different line terminators in the unix and the windows world. To add the line endings windows editors understand there are 2 ways:
Create the text with the needed endings:
printf "First...

Hi,

you feed notavail.txt to uuencode and then feed uuencodes output too mailx. You do not see any email body because only the encoded content of your textfile arrives at mailx. For a mail body...

There is a space missing after the opening curly brace and I'd put the output into quotes:
[ "`locate *asdfghjcluster_info*`" == "" ] && { echo "- ERROR : required cluster_info NIPE file used for...

Hello,

the wildcard for a single character is ?, so your ls-command would look like this:
$ touch FORM_9757_TYUIOP_1.DAT FORM_9840_OPRTOP_2.DAT FORM_9757_TIRTOP_3.DAT
$ touch XOPX.DAT
$ touch...

Hi,
one reason could be messed up terminal line settings.
This can often be fixed by:
stty sane

Give a format specifier that is wide enough to display the heading. Something like:
column STORE_NUM heading 'STORE_NUM DIVISION' format a18

Edit: I just saw you posted this in the wrong section...

Hi,

on Debian Linux + Bash:
type unset
unset is a shell builtin

What does didn't work mean? You get wrong results or a syntax error? It works for me:
select * from
(select decode(c.extent_management,'LOCAL','*',' ') || b.tablespace_name name,
...