11-29-2011
Thanks guys...
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Dear All
I have file a.sql, let's say the content is:
_________________________________
select * from dual;
exit;
_________________________________
and I have shell script a.sh, the content is:
_________________________________
ORACLE_SID=testing; export ORACLE_SID... (0 Replies)
Discussion started by: Aditya Purwanto
0 Replies
2. HP-UX
HI ALL,
I have been trying to install a particular software using remote linux server.
some thing like this:
rsh <host ID> /usr/sbin/swinstall -x autoreboot=true -s /tmp/<software> <Product name>.
The problem is whenever I try to install the product through a shell script the installation... (1 Reply)
Discussion started by: barun agarwal
1 Replies
3. Shell Programming and Scripting
Hi Friends,
Do someone know how to capture value in a shell variable from oracle sql?
Requirement : In a table we want to count the number of records and want to pass this value to a shell variable where it can be manipulated later. In ksh shell we open oracle connection from sqlplus.
For... (1 Reply)
Discussion started by: sourabhsharma
1 Replies
4. UNIX for Dummies Questions & Answers
hi,
i am a new user in unix..and we have unix db2. i want to capture the no. of rows updated by a update db2 sql statement and redirect into a log file.
I've seen db2 -m...but not sure how the syntax should be. The update sql that I'm going to run is from a file...
Can you please share... (1 Reply)
Discussion started by: j_rymbei
1 Replies
5. Shell Programming and Scripting
Hi all,
I have a script file that has numerous linking commands (ln -s) and currently there is no checking to see if the linking is successful or not and I need to implement something that checks if any of the linking failed and report a failure.
The method I can think of is a small function... (3 Replies)
Discussion started by: zmfcat1
3 Replies
6. UNIX for Dummies Questions & Answers
Hi
I am trying to fetch the data from Oracle Table
More my_query.sql | sqlplus -s 'scott/tiger@OrcaleSID ' | sed 's///g;s///g' > sample_file
Now if the table passed in the my_query.sql is wrong or there is some other error insied SQL how i can caputure that
i tried
More... (1 Reply)
Discussion started by: max_hammer
1 Replies
7. Shell Programming and Scripting
Hi Gurus,
I am very new in Unix,
I have 1 script, in which I am truncating the table , then BCP the data in Sybase table, and then loading the data from sybase table to sybase table.
every thing is working fine, but the problem is with Error.
I made some hanges in my insert statement so... (1 Reply)
Discussion started by: aksar
1 Replies
8. Shell Programming and Scripting
Hi,
This may not be the right forum but i am hoping someone knows an answer to this.
I have to capture rows for a column that was deleted. How can i do that without having to write a select query?
delete from myschema.mytable where currentdatetimestamp > columnDate
this should delete 5... (4 Replies)
Discussion started by: jakSun8
4 Replies
9. Solaris
Attempting to update an 11.0 server with many non-global zones installed. pkg publisher is pkg.oracle.com/solaris/support.
FMRI = pkg://solaris/entire@0.5.11,5.11-0.175.1.15.0.4.0:20131230T203500Z
When we run pkg update --accept the server contacts oracle, checks packages, finds about 700... (4 Replies)
Discussion started by: CptCarrot
4 Replies
10. Shell Programming and Scripting
Greetings Experts,
I am on AIX using ksh. Created a unix script which generates the CREATE OR REPLACE VIEW ... and GRANT .. statements, which are placed in a single .txt file. Now I need to execute the contents in the file (there are around 300 view creation and grant statements) in Oracle and... (4 Replies)
Discussion started by: chill3chee
4 Replies
LEARN ABOUT DEBIAN
text::lorem
Text::Lorem(3pm) User Contributed Perl Documentation Text::Lorem(3pm)
NAME
Text::Lorem - Generate random Latin looking text
SYNOPSIS
use Text::Lorem;
my $text = Text::Lorem->new();
# Generate a string of text with 5 words
$words = $text->words(5);
# Generate a string of text with 2 sentences
$sentences = $text->sentences(2);
# Generate 3 paragraphs
$paragraphs = $text->paragraphs(3);
DESCRIPTION
Often when developing a website or other application it's important to have placeholders for content. This module generates prescribed
amounts of fake Latin text.
CONSTRUCTOR
"new()"
The default constructor, "new()" takes no arguments and returns a Text::Lorem object.
METHODS
"words( INTEGER )"
Returns INTEGER fake Latin words.
"sentences( INTEGER )"
Returns INTEGER sentences in fake Latin.
"paragraphs( INTEGER )"
Returns INTEGER paragraphs of fake Latin text.
THANKS
Thanks to the guys who pushed me off the cliff called comfort and into the scary world of Perl: James Duncan, Leon Brocard.
AUTHOR
Adeola Awoyemi (adeola@fotango.com)
SEE ALSO
L<WWW::Lipsum> and L<http://lipsum.com/>
COPYRIGHT
Copyright 2003 Fotango Ltd. All rights reserved. <http://opensource.fotango.com/> This software is released under the same license as Perl
itself.
perl v5.10.1 2011-01-05 Text::Lorem(3pm)