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

database - How many Observations in SAS Sample Data Output -

-
i have sample sas output , need find out how many observations , compute t-statistic beta1. can me started on how go doing this? sample sas output to number of obs in dataset can run code. data _null_; put nobs=; stop; set sashelp.class nobs=nobs; run; a proc reg give summary statistics need, namely, t-value, beta1 , beta null, intercepts of regression equation. here simple easy follow example http://support.sas.com/documentation/cdl/en/statug/63962/html/default/viewer.htm#statug_reg_sect003.htm
Read more

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

emulation - Android map show my location didn't work -

-
i have been struggle current location in google map, tried official map demo, not working also. shows getmylocation button on upper right, didn't show blue dot on map current location. here code , i'm using emulator target api 23, guess may emulator's problem since code download directly github. advice appreciated. [screenshot][1] package com.example.mapdemo; import com.google.android.gms.maps.googlemap; import com.google.android.gms.maps.googlemap.onmylocationbuttonclicklistener; import com.google.android.gms.maps.onmapreadycallback; import com.google.android.gms.maps.supportmapfragment; import android.manifest; import android.content.pm.packagemanager; import android.os.bundle; import android.support.annotation.nonnull; import android.support.v4.app.activitycompat; import android.support.v4.content.contextcompat; import android.support.v7.app.appcompatactivity; import android.widget.toast; /** * demo ...
Read more