Search Results

Search: Posts Made By: Zelp
7,034
Posted By Zelp
take a look at this little script I wrote to...
take a look at this little script I wrote to parse your basic sqlplus login string

input should be in the format user/pass@inst

#!/usr/bin/ksh

######################
## login string parser...
9,402
Posted By Zelp
wow, I guess these 10 hour days are getting me, I...
wow, I guess these 10 hour days are getting me, I missed the simple use of a while loop.

thanks so much porter

while test $RUN = 1
...
"Exit") RUN=0
clear
...
9,402
Posted By Zelp
This does display my options again for me, but...
This does display my options again for me, but how do I get out of the big loop now?

previously my lastcase choice was
"Exit") break;;
but now that too kicks me right back into my select options
6,829
Posted By Zelp
do you have sample files? Are you sure i...
do you have sample files?

Are you sure i and j are numbers?
9,402
Posted By Zelp
i guess the PS3 prompt is waiting. ...
i guess the PS3 prompt is waiting.

PS3="Select the item number:"

because in a select command it just sits and wait for you to choose, so i want it to automatically hit <enter> right when it...
9,402
Posted By Zelp
well nothing is actually waiting for it. I...
well nothing is actually waiting for it.

I have a huge "select do case" statement. and each time after chossing one of the options, I want to clear the screen and automatically hit <enter>...
9,402
Posted By Zelp
Make my script press buttons
I am having some problems trying to come up with way that my script can press <enter> for me.

I am surrounded by people who are not UNIX friendly, and I want my script to push Enter for me,...
3,816
Posted By Zelp
Thanks again, you are really on the ball!
Thanks again, you are really on the ball!
3,816
Posted By Zelp
WOW, you did it! Thanks a ton. now I...
WOW, you did it!

Thanks a ton.

now I can just awk that into a file, then grep the resulting file per each table_name and save that to individual SQLs per table.
3,816
Posted By Zelp
yes the select statements come out great, but not...
yes the select statements come out great, but not the connections

you see I have 25 DB's and I want to compare them each to each other, and I figure the best way is like this

1-2
2-1
2-3
3-2...
3,816
Posted By Zelp
I guess there is more explanation needed. We...
I guess there is more explanation needed.
We have 25 DB's that have identical schema (the same table exists in all of them) but the data is different.

we are hoping to combine all of them into 1...
3,816
Posted By Zelp
okay that gets the output I need, but I am not...
okay that gets the output I need, but I am not sure how to use it the way I need to.

I have a template file I created that contains the sql statements and placeholders for columns_names and...
3,816
Posted By Zelp
looping and awk/sed help
I am pretty new to this, but imagine what I am trying to do is possible

iI am trying to make an automated DB comparison tool that selects all columns in all tables and compares them to the same...
1,576
Posted By Zelp
Thanks vgersh99 that gets parts of what I...
Thanks vgersh99

that gets parts of what I want, and I browsed through the FAQ and tried a few diff things, but can't seem to find what I want.

You see I want to write my variables to a file.
...
1,576
Posted By Zelp
script help
i have a script i am wiriting for my team, and I want it to send an email with attachment when it is done to whoever ran the script.

i already caught the user name and email with
whoami | read...
3,764
Posted By Zelp
yeah, it was that darn quote after 'DISABLED'; ...
yeah, it was that darn quote after 'DISABLED';

and BTW, you can leave the (minus) in the <<-EOSQL4

by adding the minus it removes any un-wanted TAB characters in the SQL.

Thanks so much...
3,764
Posted By Zelp
i tried that and now I get Checking that all...
i tried that and now I get

Checking that all constraints are Enabled
...
Check[12]: ORA-01740:: unknown test operator

All Constraints are enabled

anymore help?
3,764
Posted By Zelp
what am I missing?
I have the following portion of a script

Check()
{
echo "\n\nChecking that all constraints are Enabled"
echo "..."
sleep 2
CHECK_COUNT='sqlplus -s $1 <<-EOSQL4
set feed off pause off pages 0...
7,536
Posted By Zelp
I think if you simply add a - (minus) after the...
I think if you simply add a - (minus) after the << it should ignore any tabs and whitespace it finds.

<<-SQPLUS
...
SQLPLUS
Showing results 1 to 19 of 19

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