Get Output from sqlplus prompt in bash script -


i have issue in writing bash script.

i trying output sqlplus prompt bash variable. tried many ways suggested in many forums.

t=$(./bin/sqlplus 'oracleuser/password@(description=(address=(protocol=tcp)(host=192.168.1.2)(port=1521))(connect_data=(sid=connectstring)))' << end select (1 - (sum(getmisses)/(sum(gets) + sum(getmisses)))) * 100 v\$rowcache;  exit; end )  echo $t

this trying exactly. in above, generating string

'oracleuser/password@(description=(address=(protocol=tcp)(host=192.168.1.2)(port=1521))(connect_data=(sid=connectstring)))'

dynamically. part works well, issue comes when passing command 

select (1 - (sum(getmisses)/(sum(gets) + sum(getmisses)))) * 100 v\$rowcache;

in sqlplus prompt. here happens like, $ symbol getting escaped, * symbol causes issues (like in sqlprompt lists files in directory runs!) when running command whole.

i have coded :-

connect="'oracleuser/password@(description=(address=(protocol=tcp)(host=192.168.1.2)(port=1521))(connect_data=(sid=connectstring)))'"  arr[1]="select (1 - (sum(getmisses)/(sum(gets) + sum(getmisses)))) * 100 v\$rowcache;"  exp=$(./bin/sqlplus $mconnect << end printf "${arr[1]}"; exit; end )  echo $exp

when running script, enters sqlplus, when running select command * causing issues, if entering commands manually works.

is there better way exists ? not bash geek :( .

i need real help!

thanks taking time @ issue.

best regards, bhuvanesh

how running query separate query1.sql file?

also, if want result (in case, of (1 - (sum(getmisses)/(sum(gets) + sum(getmisses)))) * 100) returned , no header info, use sqlplus -s. 

sqlplus -h

-s sets silent mode suppresses display of sql*plus banner, prompts, , echoing of commands.

bash.sh:

#/bin/bash     connect="'oracleuser/password@(description=(address=(protocol=tcp)(host=192.168.1.2)(port=1521))(connect_data=(sid=connectstring)))'"      exp=$(./bin/sqlplus -s $connect << end     @query1.sql     end     )  echo $exp

query1.sql:

set head off select count(*) all_users; exit

then run example..

./bash.sh 36

-

Comments

Post a Comment

Popular posts from this blog

unity3d - Rotate an object to face an opposite direction -

i have object , b. when click on object b, rotates object b (a faces b). b doesn't face a. need following : when faces b, need face opposite direction. have code rotating @ b. how rotate face opposite direction after that? vector3 targetdirection = target - transform.position; float step = speed * time.deltatime; vector3 newdirection = vector3.rotatetowards (turretdome.transform.forward, targetdirection, step, 0.0f); turretdome.transform.rotation = quaternion.lookrotation (newdirection); you object facing object b, want inverse direction of object after that? objecta.transform.rotation = quaternion.inverse(objecta.transform.rotation) but lets assume example turretdome object a, (negate direction): turretdome.transform.rotation = quaternion.lookrotation (-newdirection); naturally, both of these snippets not show how smoothen rotation, seem know how use time.deltatime. just incase unsure, quaternion.lerp this
Read more

angular - Is it possible to get native element for formControl? -

i've got angular2 reactive form . created formcontrol s , assigned input fields by [formcontrol]=... . understand creates nativeelement <-> formcontrol link. my question: possible nativeelement formcontrol ? wanna myformcontrol.nativeelement.focus() i can share 1 terrible solution works me. in reactive forms can use either 1) formcontroldirective ts mycontrol = new formcontrol('') template <input type="text" [formcontrol]="mycontrol"> or 2) formcontrolname ts myform: formgroup; constructor(private fb: formbuilder) {} ngoninit() { this.myform = this.fb.group({ foo: '' }); } template <form [formgroup]="myform"> <input type="text" formcontrolname="foo"> </form> so these directives write patch like 1) formcontroldirective const originformcontrolngonchanges = formcontroldirective.prototype.ngonchanges; formcontroldirective.proto
Read more

javascript - Why jQuery Select box change event is now working? -

i working on product filters user select select box according his/her preference not getting selected value user in jquery. html code:- <select name="product_filter" id="product_filter"> <option value="price_low_first">price : low high</option> <option value="price_high_first">price : high low</option> <option value="latest">latest</option> <option value="popular">most popular</option> </select> jquery code: $(function () { $("#product_filter").change(function () { alert("hi") var selectedtext = $(this).find("option:selected").text(); var selectedvalue = $(this).val(); alert("selected text: " + selectedtext + " value: " + selectedvalue); }); }); hi believe code perfect. once please check jquery.min.js
Read more