read thing doesnt work cero as i do have spaces in the values itself as in one column has a value arun mishra.. read will treat it as two fields instead of 1.
can i assign evrything to arrayvariable and fetch 1 by 1:
Code:
arrayvar=`sqlplus -s ${WMD_DM_CONNECT} <<-EOF
set wrap off
set linesize 30000
set feedback off
set pagesize 0
set verify off
select file_id, file_desc, file_freq_cd, load_tbl_nm, load_stored_procd_nm, load_proc_typ_nm, err_rec_cnt_thrsld_nbr, file_expc_rec_cnt,grth_pct,rec_trminator_txt
from wmd_file_lkup where file_shrt_nm='CGENSITE';
exit
EOF`
export FIA_ID=aarrayvar[0]
export FIA_DESC=aarrayvar[1]..
....
.....
and so on..
let me know if i make some sense.. and kindly suggest on the same.
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)
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)
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)
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)
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)
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)
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)
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)
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)
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 MOJAVE
mpscnnlocalcontrastnormalizationgradientnode
MPSCNNLocalContrastNormalizationGradientNode(3) MetalPerformanceShaders.framework MPSCNNLocalContrastNormalizationGradientNode(3)NAME
MPSCNNLocalContrastNormalizationGradientNode
SYNOPSIS
#import <MPSNNGraphNodes.h>
Inherits MPSNNGradientFilterNode.
Instance Methods
(nonnull instancetype) - initWithSourceGradient:sourceImage:gradientState:kernelWidth:kernelHeight:
Class Methods
(nonnull instancetype) + nodeWithSourceGradient:sourceImage:gradientState:kernelWidth:kernelHeight:
Properties
float alpha
float beta
float delta
float p0
float pm
float ps
NSUInteger kernelWidth
NSUInteger kernelHeight
Method Documentation
- (nonnull instancetype) initWithSourceGradient: (MPSNNImageNode *__nonnull) sourceGradient(MPSNNImageNode *__nonnull)
sourceImage(MPSNNGradientStateNode *__nonnull) gradientState(NSUInteger) kernelWidth(NSUInteger) kernelHeight
+ (nonnull instancetype) nodeWithSourceGradient: (MPSNNImageNode *__nonnull) sourceGradient(MPSNNImageNode *__nonnull)
sourceImage(MPSNNGradientStateNode *__nonnull) gradientState(NSUInteger) kernelWidth(NSUInteger) kernelHeight
Property Documentation
- alpha [read], [write], [nonatomic], [assign]
The value of alpha. Default is 0.0 The default value 0.0 is not recommended and is preserved for backwards compatibility. With alpha 0, it
performs a local mean subtraction. The MPSCNNLocalContrastNormalizationNode used with the MPSNNGraph uses 1.0 as a default.
- beta [read], [write], [nonatomic], [assign]
The value of beta. Default is 0.5
- delta [read], [write], [nonatomic], [assign]
The value of delta. Default is 1/1024
- (NSUInteger) kernelHeight [read], [nonatomic], [assign]
- (NSUInteger) kernelWidth [read], [nonatomic], [assign]
- p0 [read], [write], [nonatomic], [assign]
The value of p0. Default is 1.0
- pm [read], [write], [nonatomic], [assign]
The value of pm. Default is 0.0
- ps [read], [write], [nonatomic], [assign]
The value of ps. Default is 1.0
Author
Generated automatically by Doxygen for MetalPerformanceShaders.framework from the source code.
Version MetalPerformanceShaders-100 Thu Feb 8 2018 MPSCNNLocalContrastNormalizationGradientNode(3)