oracle - Return value from sql script to shell script -


i have shell script calls following sql script:

     insert semantic.count_statistics (...);      update semantic.count_statistics       set prnct_change = 1.1;     --want store result of bellow select statement in model_count variable        select prnct_change       semantic.count_statistics       model = '&my_model'       , new_date = (                       select max(new_date)                       semantic.count_statistics                       model = '&my_model'                      );

now, how return percentage_number variable shell script?

my shell script follows:

#!/bin/bash # # setup oracle, java, , d2rq environment . /etc/profile.d/oracle.sh . /etc/profile.d/java.sh . /etc/profile.d/d2rq.sh  cd /opt/d2rq  model_count=$(sqlplus user/pass @count.sql 'model')  if ["$model_count" > 0];    echo "percentage count positive" else    echo "its negative"

i last select statement result stored model_count variable in shell script.

anyone knows why not working?

a bash example use of bash-function (note! database os-authentication "/")

#!/bin/bash  get_count () {     sqlplus -s / <<!     set heading off     set feedback off     set pages 0     select count(*) all_objects object_type = '$1';  ! }  count=$(get_count $1)  echo $count  if [ "$count" -gt 0 ];     echo "is greater zero" else     echo "is less or equal zero" fi   ~/tmp/ $ ./count.sh index 2922 greater 0 ~/tmp/ $ ./count.sh table 1911 greater 0 ~/tmp/ $ ./count.sh function 226 greater 0 ~/tmp/ $ ./count.sh "superobject" 0 less or equal 0

Comments

Post a Comment

Popular posts from this blog

How to mention the localhost in android -

i trying call localhost in android application. unfortunately not possible used several methods emulator local host http://10.0.2.2/android/dbconnection.php and network ip address http://192.168.1.xx/android/dbconnection.php also http://localhost:8080/android/dbconnection.php but nothing connected localhost. purpose refer stackoverflow answers not working i facing same problem when worked on localhost. referred stackoverflow answer got solution create new emulator works fine in new emulator.
Read more

php - Calling a template part from a post -

i include iframe within post in wordpress. located inside content of post, meaning cannot in post template file, otherwise either before or after. i'd add facebook plugin within posts: <div id="socialwrap"><div class="fb-like" data-href="http://onlinearizonahomes.info" data-send="true" data-width="450" data-show-faces="true" data-font="arial"></div></div> i thinking of calling template part within post <?php get_template_part( 'social' ); ?> cannot use php within post without plugin (i'd avoid using plugin this). an alternative using javascript create html in post, seems unnecessary use of javascript. what best way add html within wordpress post? you can use shortcode. add functions.php function cudjex_fbshare( $atts, $content = null ) { global $post; $link = get_permalink($post->id); return '<div id="socialwrap...
Read more

c# - String.format() DateTime With Arabic culture -

check below code snippet, namespace testdateconvertion { class program { static void main(string[] args) { datetime testvalue = new datetime(2013, 12, 15, 15, 33, 44); cultureinfo culture = new cultureinfo("ar-sa"); string stringvalue = string.format(culture, "{0:d} {0:hh:mm:ss}", testvalue); console.writeline(stringvalue); console.readline(); } } } it gives output 22/02/35 15:33:44 i not getting how possible. whats 35 doing in output there that's 13/12/2015 in hijri, 35 means 1435 in hijri, default date format saudi arabia.
Read more