Search Results

Search: Posts Made By: cero
Forum: What is on Your Mind? 08-28-2018
2,717
Posted By cero
One place I hang around as often as I do here is...
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...
787
Posted By cero
Another important information is how the scripts...
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...
1,168
Posted By cero
Your requirement is a bit confusing for me....
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...
733
Posted By cero
The pipe feeding the loop does nothing useful...
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...
Forum: UNIX and Linux Applications 07-20-2017
2,248
Posted By cero
Your goal is to loop through all tables in schema...
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...
787
Posted By cero
You prefix sh when you want a specific shell to...
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.
787
Posted By cero
Basically there is no need to prefix the script...
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...
Forum: HP-UX 01-20-2017
4,948
Posted By cero
So now you're in the situation Robin (rbatte1)...
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?...
563
Posted By cero
You can tell the ls command to display one file...
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
1,329
Posted By cero
Hi, you see the syntax error because there is a...
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...
4,770
Posted By cero
Hi, the effect you see is caused by the way you...
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...
1,346
Posted By cero
am24, do you see a syntax error when you use 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...
3,612
Posted By cero
Most of the undesired output will be surpressed...
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...
1,748
Posted By cero
My man page tells me this:
My man page tells me this:
Forum: UNIX and Linux Applications 02-18-2016
1,708
Posted By cero
The mysql-documentation...
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...
4,424
Posted By cero
Hi, to connect to all 5 databases you have to...
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...
Forum: UNIX and Linux Applications 10-30-2015
5,060
Posted By cero
What is the data type of the columns involved? If...
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...
977
Posted By cero
There are different line terminators in the unix...
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...
977
Posted By cero
Hi, you feed notavail.txt to uuencode and...
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...
1,349
Posted By cero
There is a space missing after the opening curly...
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...
3,048
Posted By cero
Hello, the wildcard for a single character...
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...
2,709
Posted By cero
Hi, one reason could be messed up terminal line...
Hi,
one reason could be messed up terminal line settings.
This can often be fixed by:
stty sane
1,628
Posted By cero
Give a format specifier that is wide enough to...
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...
1,914
Posted By cero
Hi, on Debian Linux + Bash: type unset ...
Hi,

on Debian Linux + Bash:
type unset
unset is a shell builtin
Forum: Programming 02-13-2015
3,020
Posted By cero
What does didn't work mean? You get wrong results...
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,
...
Showing results 1 to 25 of 93

 

Featured Tech Videos

All times are GMT -4. The time now is 03:58 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy