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

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

ios - how to query based on pfobject/pfuser associated with another pfobject in parse.com? -

-
i have parse class called friendrelation. class has 2 users, 1 friend other user. i want of messages posted of friends of user. attempting following query: pfquery *innerquery = [pfquery querywithclassname:@"friendrelation"]; [innerquery wherekey:@"user" equalto:currentuser]; pfquery *query = [pfquery querywithclassname:@"message"]; [query wherekey:@"usermessage" matchesquery:innerquery]; [query findobjectsinbackgroundwithblock:^(nsarray *comments, nserror *error) { }]; this query comes no results. i believe occurring because of line: [query wherekey:@"usermessage" matchesquery:innerquery]; the key needs friendrelation match. correct? how can make results of inner query user intern match matching query? thanks! you can try using - (void)wherekey:(nsstring *)key matcheskey:(nsstring *)otherkey inquery:(pfquery *)query something like: pfqu...
Read more