Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to get Oracle variable in UNIX?
Top Forums Shell Programming and Scripting How to get Oracle variable in UNIX? Post 302772889 by Jotne on Wednesday 27th of February 2013 03:50:06 AM
Old 02-27-2013
Its not easy to understand what you like.

If output is like this: 34,23,645,82,110,412,8,65 you can try this:

Code:
echo "34,23,645,82,110,412,8,65" | awk -F, '
{ print "export FILE_ID="$1}
{ print "export FILE_DESC="$2}
{ print "export FILE_FREQ_CD_ID="$3}
{ print "export LOAD_TBL_NM="$4}
{ print "export LOAD_STORED_PROCD_NM="$5}
{ print "export LOAD_PROCD_TYP_NM="$6}
{ print "export LOWER_SHORT_NM="}
{ print "export ERR_REC_CNT_THRSLD_NBR="$7}
{ print "export FILE_EXPC_REC_CNT="$8}'


export FILE_ID=34
export FILE_DESC=23
export FILE_FREQ_CD_ID=645
export LOAD_TBL_NM=82
export LOAD_STORED_PROCD_NM=110
export LOAD_PROCD_TYP_NM=412
export LOWER_SHORT_NM=
export ERR_REC_CNT_THRSLD_NBR=8
export FILE_EXPC_REC_CNT=65

Your SQL example do miss input for LOWER_SHORT_NM
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Get Oracle fuction return value in a variable

Hi All, :confused: I have the following code. var=' ' sqlplus user/pass@DB <<EOF whenever sqlerror exit 1 select package.func() into $var from dual; EOF echo $var But, this code does not work to display the value returned by the oracle function. Do we have to bind variables before... (3 Replies)
Discussion started by: rahulrathod
3 Replies

2. UNIX for Dummies Questions & Answers

How to pass unix variable to oracle

hi , how to pass unix variable to oracle code is ............. #! /bin/ksh echo enter date vale read date1 sqlplus x/y@oracle select * from emp where statrt_date= $date1 is this is correct way... (1 Reply)
Discussion started by: chiru
1 Replies

3. Shell Programming and Scripting

To get value from oracle & assign it in UNIX variable

Hi Team, I need to get data from oracle table & need to assign that value to unix variable. I have serched the same in other threads. I found the following code. I have tried code to get the value from oracle. but it is not working. The error shows invalid identifier "NAM" & then list all... (5 Replies)
Discussion started by: Amit.Sagpariya
5 Replies

4. Shell Programming and Scripting

passing variable to oracle procedure

using the script below I want to pass a parameters thorugh my sql call(@/unixsxxx/xxxx/helpenv.sql emptab ) as input into an oracle procedure xxxx_package.proc1(%1,emptab); . I tried %1 but it does not work. Any suggestions. #!bin/ksh set -x # export... (0 Replies)
Discussion started by: TimHortons
0 Replies

5. Shell Programming and Scripting

Passing unix variable to oracle parameters

Please help me how to pass some unix vairable to oracle. I have used below , but not displaying passed (inval) value. calling() { sqlplus -s $1/$2@$3 <<EOF begin exec call_sql($4); end; exit EOF } calling user pwd inst value1... (17 Replies)
Discussion started by: Jairaj
17 Replies

6. Shell Programming and Scripting

set oracle variable in function

Hi, I have a function that is suposed to generate a AWR report: #-----------------------# gen_awr() #-----------------------# { sqlplus -s admin/admin@OCEAN11<<ENDOFSQL define num_days = '' define report_type = "html" define begin_snap =$snap1 define end_snap =%snap2 define... (1 Reply)
Discussion started by: amitlib
1 Replies

7. Programming

Oracle Variable Passing Test

Hi, I am trying to get the oracle variables and pass the values in sql placed in procedure. VARIABLE vstat='ASDS,FGDS,VCGD,VCXC' Query : select distinct dept from College where section in ('C','D') AND CODES ='' AND NAMES IN ('RAJ','SAM'); I want CODES values to be taken from vstat... (1 Reply)
Discussion started by: Perlbaby
1 Replies

8. Shell Programming and Scripting

How to get a numeric value from Oracle to UNIX variable without spaces?

Hi, I am using the below code to get a numeric value from oracle to unix variable: BD_RC_CNT=`sqlplus -s ${WMD_DM_CONNECT} <<EOF set heading off set pagesize 0 Select count(*) from wmd_bad_data where proc_id = ${PROC_ID} and file_id = ${FILE_ID} and file_dt =... (7 Replies)
Discussion started by: Arun Mishra
7 Replies

9. UNIX and Linux Applications

Identify a specific environment Oracle variable to connect a remote Oracle database ?

Good evening I nned your help pls, In an unix server i want to connect to a remote oracle databse server by sqlplus. I tried to find out the user/passwd and service name by env variable and all Ive got is this: ORACLE_SID_REPCOL=SCL_REPCOL ORACLE_SID=xmeta ORACLE_SID_TOL=SCL_PROTOLCOL... (2 Replies)
Discussion started by: alexcol
2 Replies

10. Shell Programming and Scripting

Passing variable from file to Oracle

cat a1 scott robert tom test script : #!/usr/bin/ksh for NAME in `cat a1` do VALUE=`sqlplus -silent "nobody/bobody01@testq" <<END set pagesize 0 feedback off verify off heading off echo off select username from dba_users where username=upper('$NAME'); END` if ; then echo... (3 Replies)
Discussion started by: jhonnyrip
3 Replies

LEARN ABOUT SUNOS

unshare_nfs

unshare_nfs(1M) 					  System Administration Commands					   unshare_nfs(1M)

NAME

       unshare_nfs - make local NFS file systems unavailable for mounting by remote systems

SYNOPSIS

       unshare [ -F nfs] pathname

DESCRIPTION

       The  unshare  command makes local file systems unavailable for mounting by remote systems. The shared file system must correspond to a line
       with NFS as the FSType in the file /etc/dfs/sharetab.

OPTIONS

       The following options are supported:

       -F	This option may be omitted if NFS is the first file system type listed in the file /etc/dfs/fstypes.

FILES

       /etc/dfs/fstypes

       /etc/dfs/sharetab

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWnfssu 		   |
       +-----------------------------+-----------------------------+

SEE ALSO

       nfsd(1M), share(1M), attributes(5)

NOTES

       If the file system being unshared is a symbolic link to a valid pathname, the canonical path (the path which  the  symbolic  link  follows)
       will be unshared.

       For  example,  if  /export/foo is a symbolic link to /export/bar (/export/foo -> /export/bar), the following unshare command will result in
       /export/bar as the unshared pathname (and not /export/foo):

       example#  unshare -F nfs /export/foo

       For file systems that are accessed by NFS Version 4 clients, once the unshare is complete, all NFS Version 4 state  (open  files  and  file
       locks)  are  released and unrecoverable by the clients. If the intent is to share the file system after some administrative action, the NFS
       daemon (nfsd) should first be stopped and then the file system unshared. After the administrative action is complete, the file system would
       then be shared and the NFS daemon restarted. See nfsd(1M)

SunOS 5.10							    6 May 2003							   unshare_nfs(1M)
All times are GMT -4. The time now is 11:15 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy