09-23-2008
Search for sqlplus on this forum, there are a lot of threads regarding this topic here.
Regards
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am new to UNIX.
I got the file from Oracle, with
two columns (Table Name and Column Name). I need to create the shell script where the result suppose to include
plain text, <table_name>, <Column_name> from the file.
Plain text will be the statements to create index in Oracle.
something like... (1 Reply)
Discussion started by: newuser100
1 Replies
2. UNIX for Advanced & Expert Users
Can I do something like this from a shellscript ?:
ftp 12.34.56.78 <<!
username
password
put a.c
bye
!
It does not go through as the login fails.
Is there any alternative to do the above requirement?
Thanks in advance.
Gowrish (3 Replies)
Discussion started by: ggowrish
3 Replies
3. Shell Programming and Scripting
Hello. I am a novince at writing shell scripts but here is the question. I have to write a shell script that does the following:
Once executed via crontab, the script should do the following:
a. get date/time stamp in for format 10-MAR-05 and
b. execute shell script my_script.sh (which... (2 Replies)
Discussion started by: jigarlakhani
2 Replies
4. Shell Programming and Scripting
Hello everyone,
I have a RHEL 5 system and have been trying to get a batch of 3-4 scripts each in a separate variables and they are not working as expected.
I tried using following syntax which I saw a lot of people on this site use and should really work, though for some reason it doesn't... (3 Replies)
Discussion started by: rockf1bull
3 Replies
5. Shell Programming and Scripting
hi all,
i need the shell script for he below requirement
i had the input file as
a_20121217_035120( frmat is a_date_hhmmss)
a_20121217_035128
a_20121217_035456
a_20121217_035767
a_20121217_035178
a_20121217_035189
a_20121217_035220
my output should be
a_20121217_035456... (0 Replies)
Discussion started by: hemanthsaikumar
0 Replies
6. Shell Programming and Scripting
I am new in shell script i want to convert .txt file
in the format axsjdijdjjdk to
a
x
s
j
d
i
j
d
j
j
d
k (5 Replies)
Discussion started by: sreejithalokkan
5 Replies
7. Shell Programming and Scripting
i am using bash shell
Whenever i declare an array, and then using sqlplus, i am getting sqlplus error and return code 127.
IFS=","
declare -a Arr=($Variable1);
SQLPLUS=sqlplus -s "${DBUSER}"/"${DBPASS}"@"${DBASE}
echo "set head off ; " > ${SQLCMD}
echo "set PAGESIZE 0 ;" >> ${SQLCMD}... (6 Replies)
Discussion started by: arghadeep adity
6 Replies
8. Shell Programming and Scripting
cat << EOF | telnet alt1.aspmx.l.google.com 25
HELO verify-email.org
MAIL FROM: <check@verify-email.org>
RCPT TO: <test@gmail.com>
quit
EOF
Hello, I'm trying to get the result of that execution, and can not see the result or bring it to a txt ... the direct command in ssh running the result... (5 Replies)
Discussion started by: c0i0t3
5 Replies
9. Shell Programming and Scripting
Hi All,
we have requirement, i am created a shell script , inside i am connecting sqlplus and execute the query. below my code for your reference.
get_sqlid ()
{
sqlid=$(
sqlplus -s $PBDW_USERID/$PBDW_PW@$PBDW_SID <<EOF
DEFINE TBLNAME=$1
set feedback off
set serverout on size... (4 Replies)
Discussion started by: KK230689
4 Replies
LEARN ABOUT DEBIAN
swiss::ccs
SWISS::CCs(3pm) User Contributed Perl Documentation SWISS::CCs(3pm)
Name
SWISS::CCs
Description
SWISS::CCs represents the CC lines within a Swiss-Prot or TrEMBL entry as specified in the user manual
http://www.expasy.org/sprot/userman.html . The CCs object is a container object which holds a list comprised of object of the type
SWISS::CC or derived classes (see below).
Code example
local $/="
//
";
while (<>) {
my $entry = SWISS::Entry-> fromText($_);
my @CCs = $entry -> CCs -> elements();
for my $CC (@CCs) {
if ($CC -> topic eq 'ALTERNATIVE PRODUCTS') {
# now can call methods of CCalt_prod
} elsif ($CC -> topic eq 'Copyright') {
# now can call methods of CCcopyright
} else {
# now can call methods of CC
}
}
}
Inherits from
SWISS::ListBase.pm
Attributes
"list"
Each list element is an object of one of the following classes, depending of the type of comment:
topic object
-------------------- --------------------
ALTERNATIVE PRODUCTS SWISS::CCalt_prod
RNA EDITING SWISS::CCrna_editing
BIOPHYSICOCHEMICAL PROPERTIES SWISS::CCbpc_properties
INTERACTION SWISS::CCinteraction
Copyright SWISS::CCcopyright
(all other topics) SWISS::CC
Methods
Standard methods
new
fromText
sort
Sort the CC block according to the order given in Swiss-Prot annotation note ANN017.
toText
update
Reading/Writing methods
ccTopic ($topic)
Returns true if entry contains a comment block with the specified topic.
copyright
Returns a string representation of the copyright text.
del (@patternList)
Deletes all comment elements whose topic matches the first element of the pattern list. The second element is the used to specify a
requirement for the comment to match as well.
get (@patternList)
An array is returned consisting of all comment elements elements whose topic matches any elements of the pattern list.
getObject (@patternList)
Same as get, but returns the results wrapped in a new ListBase object.
toString
Returns a string representation of the CCs object.
perl v5.10.1 2008-07-16 SWISS::CCs(3pm)