Problems with SQLPLUS in shellscript

9 More Discussions You Might Find Interesting

1. 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...

2. 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...

3. 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}...

4. 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. 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...

6. 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...

7. 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...

8. 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

9. 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...

LEARN ABOUT DEBIAN

alzabo::sqlmaker::postgresql

Alzabo::SQLMaker::PostgreSQL(3pm)			User Contributed Perl Documentation			 Alzabo::SQLMaker::PostgreSQL(3pm)

NAME

       Alzabo::SQLMaker::PostgreSQL - Alzabo SQL making class for PostgreSQL

SYNOPSIS

	 use Alzabo::SQLMaker;

	 my $sql = Alzabo::SQLMaker->new( sql => 'PostgreSQL' );

DESCRIPTION

       PostgreSQL-specific SQL creation.

METHODS

       Almost all of the functionality inherited from "Alzabo::SQLMaker" as is.  The only overridden methods are "limit()" and "get_limit()", as
       PostgreSQL does allow for a "LIMIT" clause in its SQL.

EXPORTED SQL FUNCTIONS

       SQL may be imported by name or by tags.	They take arguments as documented in the PostgreSQL documentation (version 3.23.39).  The func-
       tions (organized by tag) are:

       :math

	PI
	RANDOM
	ABD
	CEIL
	DEGREES
	FLOOR
	FACTORIAL
	SQRT
	CBRT
	EXP
	LN
	RADIANS
	ACOS
	ASIN
	ATAN
	ATAN2
	COS
	COT
	SIN
	TAN
	ROUND
	TRUNC
	LOG
	POW
	MOD
	TO_CHAR

       :string

	LENGTH
	CHAR_LENGTH
	CHARACTER_LENGTh
	OCTET_LENGTH
	TIRM
	UPPER
	LOWER
	INITCAP
	ASCII
	TO_ASCII
	STRPOS
	POSITION
	TO_NUMBER
	TO_DATE
	TO_TIMESTAMP
	REPEAT
	RPAD
	LPAD
	SUBSTR

       :datetime

	NOW
	CURRENT_DATE
	CURRENT_TIME
	CURRENT_TIMESTAMP
	TIMEOFDAY
	ISFINIT
	TIMESTAMP
	TO_CHAR
	DATE_PART
	DATE_TRUNC
	EXTRACT
	OVERLAPS

       :network

	BROADCAST
	HOST
	NETMASK
	MASKLEN
	NETWORK
	TEXT
	ABBREV

       :aggregate

       These are functions which operate on an aggregate set of values all at once.

	COUNT
	AVG
	MIN
	MAX
	SUM
	STDDEV
	VARIANCE

       :system

       These are functions which return information about the Postgres server.

	CURRENT_USER
	SYSTEM_USER
	USER

       :control

       These are flow control functions:

	NULLIF
	COALESCE

       :misc

       These are functions which don't fit into any other categories.

	ENCRYPT
	ENCODE
	DECODE
	FORMAT
	INET_NTOA
	INET_ATON
	BIT_OR
	BIT_AND
	PASSWORD
	MD5
	LOAD_FILE

       :common

       These are functions from other groups that are most commonly used.

	NOW
	COUNT
	AVG
	MIN
	MAX
	SUM
	DISTINCT

AUTHOR

       Dave Rolsky, <dave@urth.org>

perl v5.8.8							    2007-12-23					 Alzabo::SQLMaker::PostgreSQL(3pm)

Shell Programming and Scripting