error in passing a variable to sqlplus from a shell script Post: 302211182

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

passing parameters from a shell script to sqlplus

Hi , I want to pass parameters from a shell script to a sql script and use the parameter in the sql query ..and then I want to spool a particular select query on to my unix box... for 4 different locations by writing only one sql script Right now no file is generated on the unix box...it is a...

2. UNIX for Advanced & Expert Users

passing unix variable to sqlplus without a file name

Hi, I want to input unix variable to sqlplus.The following is working fine sqlplus username/password @dummy.sql param1 param2 << EOF create user $1 identified by $2; EOF But I dont want any file name to be passed,I just want to pass the parameter. Is there any way to that?? Thanks...

3. Shell Programming and Scripting

Passing the unix variable to sqlplus

Hi, I am writing a script which creates an external table using a shell script. My requirement is like this. Usage: . ./r.ksh <table_name> - this should create an external table. e.g . ./r.ksh abc - this should create an external table as abc_external. How do i achieve this? Please...

4. Shell Programming and Scripting

Passing Shell array to SQLPlus

Dears, Newbie here and tried to search this topic for 3 days now with results. I have a shell array and I want to use it in sqlplus with one connection. here is what I have for now #!/bin/ksh FileName=1000 FileName=2000 FileName=3000 FileName=4000 sqlplus /nolog <<EOF connect...

5. Shell Programming and Scripting

Passing shell variable to awk script

I want to pass a shell variable to awk script : # cat file PSAPSR3 3722000 91989.25 2 98 PSAPSR7 1562000 77000.1875 5 95 PSAPUNDO 92000 4087.5625 4 96 #...

6. Shell Programming and Scripting

Shell Script passing parameters to sqlplus code

Hello All, I am interested in finding out a way to pass parameters that are entered at the prompt from HP unix and passed to SQLPlus code with a Shell Script. Is this possible? Thanks

7. Shell Programming and Scripting

Passing a parameter from a shell script to sqlplus

Hi All, I'm new to Linux and scripting, apologies in advance for 'stupid' questions. Please help... Im writing a script that calls a sqlplus script but the sqlplus requires inputs and i cant seem to get this to work. here is my code. #!/bin/sh TERM=vt100 export TERM...

8. Shell Programming and Scripting

How to pass Variable from shell script to select query for SqlPlus?

echo "set echo off"; echo "set feedback off"; echo "set linesize 4000"; echo " set pagesize 0"; echo " set sqlprompt ''"; echo " set trimspool on"; Select statement is mentioned below echo "select res.ti_book_no from disney_ticket_history res where res.ti_status =${STATUS} and...

9. Shell Programming and Scripting

Shell Script (ksh) - SQLPlus query filter using a string variable

Using ksh, I am using SQLPlus to execute a query with a filter using a string variable. REPO_DB=DEV1 FOLDER_NM='U_nmalencia' FOLDER_CHECK=$(sqlplus -s /nolog <<EOF CONNECT user/pswd_select@${REPO_DB} set echo off heading off feedback off select subj_name from subject where...

10. Shell Programming and Scripting

Passing sqlplus output to shell variable

Hi , I am using below code : for i in `ps -ef|grep pmon|awk {' print $8 '}|cut -f3 -d'_'|grep -v '^grep'` do ORACLE_SID=$i export ORACLE_SID; dest=`sqlplus "/ as sysdba" <<EOF set heading off feedback on verify off select DESTINATION from v\\$archive_dest where target in...

LEARN ABOUT DEBIAN

gr_plot_fft

GR_PLOT_FFT(1)							   User Commands						    GR_PLOT_FFT(1)

NAME

       gr_plot_fft - Frequency domain GNU Radio plotting

SYNOPSIS

       gr_plot_fft: [options] input_filename

DESCRIPTION

       Takes  a  GNU Radio complex binary file and displays the I&Q data versus time as well as the frequency domain (FFT) plot. The y-axis values
       are plotted assuming volts as the amplitude of the I&Q streams and converted into dBm in the frequency domain (the 1/N power adjustment out
       of  the	FFT  is performed internally). The script plots a certain block of data at a time, specified on the command line as -B or --block.
       This value defaults to 1000. The start position in the file can be set by specifying -s or --start and defaults to  0  (the  start  of  the
       file).  By  default, the system assumes a sample rate of 1, so in time, each sample is plotted versus the sample number. To set a true time
       and frequency axis, set the sample rate (-R or --sample-rate) to the sample rate used when capturing the samples.

OPTIONS

       -h, --help
	      show this help message and exit

       -d DATA_TYPE, --data-type=DATA_TYPE
	      Specify the data type (complex64, float32, (u)int32, (u)int16, (u)int8) [default=complex64]

       -B BLOCK, --block=BLOCK
	      Specify the block size [default=1000]

       -s START, --start=START
	      Specify where to start in the file [default=0]

       -R SAMPLE_RATE, --sample-rate=SAMPLE_RATE
	      Set the sampler rate of the data [default=1.0]

SEE ALSO

       gr_plot_fft_c(1) gr_plot_fft_f(1)

gr_plot_fft 3.5 						   December 2011						    GR_PLOT_FFT(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

passing parameters from a shell script to sqlplus

Discussion started by: phani

2. UNIX for Advanced & Expert Users

passing unix variable to sqlplus without a file name

Discussion started by: sakthi.abdullah

3. Shell Programming and Scripting

Passing the unix variable to sqlplus

Discussion started by: Anaramkris

4. Shell Programming and Scripting

Passing Shell array to SQLPlus

Discussion started by: roby2411