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

java - How to create your own button and Use it with Scene Builder for javafx -

-
hello i've been curious know possible create own button, in example in photoshop. use "custom button" in place of default ones in scene builder. or there import function can use custom button? started using scene builder not familiar around can , cant do. thank you! being specific want mold imagine shape. use molded image button. not want use tradition button shape instead custom shape. im not sure if possible tips grateful! you can style button using css . if such styling insufficient purposes, can create custom button skin . if need additional properties button, can subclass button or buttonbase (this how javafx internally implements other button-like things additional properties such checkboxes, togglebuttons, radiobuttons, etc). either way scene builder doesn't care, there nothing special in scene builder , either option works scene builder. use scene builder place "normal" buttons in application's fxml files , set appropriate...
Read more

c++ - Drawing a circle in directx 9 -

-
i'm having hard time figuring out how draw circle in directx. i'm able draw triangle, imagined might able draw 1 rotating triangle in circle. however, i'm absolutely stumped. i've been scouring net hours no luck. can me out? here's code: main.cpp #include "engine.h" #include "box2d.h" #include "triangle2d.h" class myapp : public engine { public: box2d box2d; triangle2d triangle2d; void onstartup() override { box2d.new(10.0f, 10.0f, 100.0f, 100.0f, d3dcolor_argb(0xff, 0x00, 0x00, 0xff)); triangle2d.new(150.0f, 10.0f, 100.0f, 100.0f, d3dcolor_argb(0xff, 0xff, 0x00, 0x00)); } void onshutdown() override { box2d.delete(); triangle2d.delete(); } void ondraw() override { box2d.draw(); triangle2d.draw(); } void onmousedown(int x, int y) { debug("%d %d\n", x, y); } }; int winapi winmain(hinstance hinstance, hinstance hprevin...
Read more