Sponsored Content
Top Forums Shell Programming and Scripting Problems with SQLPLUS in shellscript Post 302239325 by Franklin52 on Tuesday 23rd of September 2008 10:12:19 AM
Old 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

Create Shellscript

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

ftp in Shellscript

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

Need help with shellscript

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

Problems with storing oracle sqlplus query output shell script

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

Needed shellscript for the following

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

Help with shellscript

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

Sqlplus error - sqlplus -s <login/password@dbname> : No such file or directory

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

Telnet shellscript

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

Avoid $ symbol while calling sqlplus in shellscript.

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
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)
All times are GMT -4. The time now is 06:51 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy