Oracle SQL Formatting -

-

consider below set of column date in oracle:

column_name na 110000 440000

i want achieve 2 things here

  1. numbers should in format 99999.90
  2. in output, word na/na should replaced blank or num field

select case when lower(col_name='na') ''              else to_number(col_name,99999.90)         end  table_name;

Comments

Post a Comment

Popular posts from this blog

javascript - Feed FileReader from server side files -

-
i´m starting customize/improve old audio editor project. can import audio tracks canvas via drag&drop computer. thing use audio tracks stored in server clicking on list of available tracks... instead of use <input type="file"> tags. how can read server side files filereader?ajax perhaps? in advance. this code file reader: player.prototype.loadfile = function(file, el) { //console.log(file); var reader = new filereader, filetypes = ['audio/mpeg', 'audio/mp3', 'audio/wave', 'audio/wav'], = this; if (filetypes.indexof(file.type) < 0) { throw('unsupported file format!'); } reader.onloadend = function(e) { if (e.target.readystate == filereader.done) { // done == 2 $('.progress').children().width('100%'); var onsuccess = function(audiobuffer) { $(el).trigger('audiee:fileloaded', [audiobuffer, file]); ...
Read more

c++ - What's the differece between of link to a dynamic file and as a input object? -

-
i use g++ link project (an executable mono_kitti) , project dependent on thirdparty library pangolin. when link action -lpangolin option: g++ -l../../lib -lorb_slam2 -lpangolin mono_kitti.o -o mono_kitti it returns: mono_kitti.o:(.data+0x0): undefined reference `vtable pangolin::handler' mono_kitti.o:(.data+0x8): undefined reference `vtable pangolin::handlerscroll' mono_kitti.o: in function `pangolin::handler::~handler()': mono_kitti.cc:(.text._zn8pangolin7handlerd2ev[_zn8pangolin7handlerd5ev]+0x13): undefined reference `vtable pangolin::handler' mono_kitti.o: in function `pangolin::handlerscroll::~handlerscroll()': mono_kitti.cc:(.text._zn8pangolin13handlerscrolld2ev[_zn8pangolin13handlerscrolld5ev]+0x13): undefined reference `vtable pangolin::handlerscroll' collect2: error: ld returned 1 exit status but when use command: g++ -l../../lib -lorb_slam2 mono_kitti.o /usr/local/lib/libpangolin.so -o mono_kitti it succeeded. but failed again when tr...
Read more

How to pass json object using PHP in Wepay API -

-
i have integrated wepay payment gateway . have facing problem pass json object wepay . shows incorrect json format. please @ below code. $forca_a = array( 'debit_opt_in'=>true ); $forca = json_encode($forca_a,json_force_object); $wepay_create_array = array( 'name' =>"xxxx", 'description' => "xxxxxxxxx xxxx", 'callback_uri' => "xxxxxxx", 'country' => "ca", 'currencies' => array('cad'), 'country_options' => $forca, 'rbits'=> array( array( 'receive_time'=>strtotime("now"), 'type' =>'website_uri', 'source' => 'partner_database', 'properties'=> array('uri'=>xxxxx) ) ) ); if won't pass country_options , seems working if pass parameter, giv...
Read more