Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Using a variable in sqlplus
Top Forums Shell Programming and Scripting Using a variable in sqlplus Post 302090421 by MadHatter on Monday 25th of September 2006 02:28:38 PM
Old 09-25-2006
Quote:
Originally Posted by vgersh99
I am no sqlplus expert, but.... try removing the '< dev/null'
Just tried it, however same results...
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to pass variable to SQLPLUS in a ksh script?

Hi, I am writing a ksh script which will use sqlplus to run a sql and pass 2 variables as the SQL request. In the ksh script, I have 2 variables which are $min_snap and $max_snap holding 2 different numbers. Inside the same script, I am using SQLPLUS to run an Oracle SQL script,... (6 Replies)
Discussion started by: rwunwla
6 Replies

2. UNIX for Advanced & Expert Users

How to pass unix variable to SQLPLUS

hi fellows, can any body tell me how to pass unix variables to oracle code is... #! /bin/ksh echo ENTER DATE VALUE's read START_DATE END_DATE sqlplus xyx/abc@oracle select * from table1 where coloumn1 between $START_DATE and $END_DATE; is this is correct way........... Thanks in... (1 Reply)
Discussion started by: chiru
1 Replies

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... (5 Replies)
Discussion started by: Anaramkris
5 Replies

4. Shell Programming and Scripting

store sqlplus output in variable

hi how can i store sqlplus output to a variable in sh script (not bash) Thanks MM (1 Reply)
Discussion started by: murtymvvs
1 Replies

5. Shell Programming and Scripting

Sending sqlplus output to a shell variable

I am trying to import a sqlplus output into a shell variable but it doesnt seem to be working. set -x export DEPENDENT_CR_NO=`sqlplus -s /nolog <<EOF conn username/passwd set heading off select dependency from custom_patches where patch_name='PATCH.zip'; exit; EOF` echo $DEPENDENT_CR_NO ... (2 Replies)
Discussion started by: beginer314
2 Replies

6. Shell Programming and Scripting

awk with variable from sqlplus

Hi, I'm a it stuck on the below code where a variable is pulled from sqlplus and used in awk. It runs with no errors but still pulls back all records in the input file. It should pull the max reference from sql plus and then only print those records where the reference value in column 1 is... (4 Replies)
Discussion started by: jonathanb30
4 Replies

7. Shell Programming and Scripting

Scirpt to fetch the variable from sqlplus

Hi Gurus, I am stuck with the step where i need to fetch the location & sales from the below procedure by taking it from table field using the for loop. any idea how this can be done in unix. From one column both the location and sales are taken out. create or replace procedure newyork... (2 Replies)
Discussion started by: arun888
2 Replies

8. 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... (5 Replies)
Discussion started by: admin_db
5 Replies

9. UNIX for Beginners Questions & Answers

Sqlplus variable UNIX

hi guys i have a sqlplus : sqlplus -s username/password << EOF @mysql.sql EOF in mysql.sql there is a count of a table, i want to write in a variabile unix. how can i do? Thanks a lot Regards Francesco. (3 Replies)
Discussion started by: Francesco_IT
3 Replies

10. Shell Programming and Scripting

Pass a VARIABLE to sqlplus script

Hi Team, I am trying to run a sqlplus script against several databases via a FOR/LOOP and also passing the loop variable to a sqlplus script I am calling, as follows: #!/bin/bash export ORACLE_SID=plgc1 export ORACLE_HOME=/opt/oracle/product/11.2.0.2/db_1 export... (1 Reply)
Discussion started by: jonnyd
1 Replies

LEARN ABOUT HPUX

vxdestroy_lvmroot

vxdestroy_lvmroot(1M)													     vxdestroy_lvmroot(1M)

NAME

       vxdestroy_lvmroot - remove LVM root disk and associated LVM volume group

SYNOPSIS

       vxdestroy_lvmroot [-v] [-b] lvm_root_disk

DESCRIPTION

       The  vxdestroy_lvmroot  command	tears  down  and removes the LVM volume group associated with the specified physical disk. This is done by
       removing the volumes in the volume group and then removing the volume group.

OPTIONS

       -b	 Invokes the setboot command to change the primary boot disk to the VxVM root disk from which the system was booted (if  the  pri-
		 mary  boot  disk is not already set to this disk).  The alternate boot device remains unchanged.  If the -v option is also speci-
		 fied, the settings of the primary and alternate boot devices are displayed.

       -v	 Outputs verbose messages including a timestamp that indicates major operations being performed.

ARGUMENTS

       lvm_root_disk
	    Specifies the device name of the LVM root disk that is to be destroyed, along with its entire volume group.

EXAMPLES

       This example shows the vxdestroy_lvmroot command invoked in its simpliest form:

       /etc/vx/bin/vxdestroy_lvmroot c5t1d0

       # /etc/vx/bin/vxdestroy_lvmroot -v -b c3t0d0
       Are you sure about destroying c3t0d0 (imported on VG /dev/vg02) ? YES
       vxdestroy_lvmroot 06:02: Tearing down /dev/vg02 on device c3t0d0
       vxdestroy_lvmroot 06:02:
	 Unmounting and removing any volumes associated with /dev/vg02
       vxdestroy_lvmroot 06:02: removing logical volume /dev/vg02/lvol1
       vxdestroy_lvmroot 06:02: removing logical volume /dev/vg02/lvol2
       vxdestroy_lvmroot 06:02: removing logical volume /dev/vg02/lvol3
       vxdestroy_lvmroot 06:02: removing logical volume /dev/vg02/lvol4
       vxdestroy_lvmroot 06:02: removing logical volume /dev/vg02/lvol5
       vxdestroy_lvmroot 06:02: removing logical volume /dev/vg02/lvol6
       vxdestroy_lvmroot 06:02: removing logical volume /dev/vg02/lvol7
       vxdestroy_lvmroot 06:02: removing logical volume /dev/vg02/lvol8
       vxdestroy_lvmroot 06:02: Removing Volume Group /dev/vg02
       vxdestroy_lvmroot 06:02: Removing device files in /dev/vg02
       vxdestroy_lvmroot 06:02: Removing LVM Physical Volume c3t0d0
       vxdestroy_lvmroot 06:02: Removing LVM Physical Volume c1t1d3
       vxdestroy_lvmroot 06:02: Removing LVM Physical Volume c1t1d4
       vxdestroy_lvmroot 06:02: Removing LVM Physical Volume c1t1d5
       vxdestroy_lvmroot 06:03: Current setboot values:
       vxdestroy_lvmroot 06:03: Primary:       0/0/6/0/0.0.0
       vxdestroy_lvmroot 06:03: Alternate:     0/0/1/0/0.1.0
       vxdestroy_lvmroot 06:03:
	 Making disk c0t1d0 (0/0/1/0/0.1.0) the primary boot disk
       vxdestroy_lvmroot 06:03:
	 Removal of device c3t0d0, volume group /dev/vg02 was successful

SEE ALSO

       cpio(1), dd(1), fsck(1M), setboot(1M) vxbootsetup(1M) vxcp_lvmroot(1M) vxres_lvmroot(1M)

VxVM 5.0.31.1							    24 Mar 2008 					     vxdestroy_lvmroot(1M)
All times are GMT -4. The time now is 09:27 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy