sql - How to catch null vales and display comment -


i have bascic query:

select col1, nvl(col1,to_number(null)) table1 colx = :new

update

baiscly, during upload i'm checking if :new inside table1.colx. if yes, want display col1, if not null value (i can't put zero).

nvl(col1,to_number(null)) return blank. can change this: nvl(col1,0).


-

Comments

Post a Comment

Popular posts from this blog

c++ - CPP, 'X' button listener -

i'm writing cpp program, , want execute function when 'x'(shut down) button pressed. for example, have infinite loop prints same thing everytime iterates, until 'x' button pressed, , want execute function before process ends. is there kind of listener matter? or other solution maybe (like delaying process shut down few seconds or something)? thanks! if want execute before process ends, can register std::atexit handler. function called before process exits.
Read more

Get Max value from table in hibernate -

i using below java(1.7) function max value hsql using hibernate 4.3: public int getmaxid() { session session = hibernateutil.getsessionfactory().opensession(); query q = session.createquery("select cast(s.id integer) student s order cast(s.id integer) desc"); list result = q.list(); return integer.parseint(result.get(0).tostring()); } but getting below error: error: unexpected token: ) required: in statement [select cast(student0_.idasinteger) col_0_0_ public.public.student student0_ order cast(student0_.id integer)desc] exception in thread "main" org.hibernate.exception.sqlgrammarexception: not prepare statement @ org.hibernate.exception.internal.sqlexceptiontypedelegate.convert(sqlexceptiontypedelegate.java:80) @ org.hibernate.exception.internal.standardsqlexceptionconverter.convert(standardsqlexceptionconverter.java:49) @ org.hibernate.engine.jdbc.spi.sqlexceptionhelper.convert(sqlexceptionhelper.java:12...
Read more

php - Alamofire request parameters empty -

i'm trying send post request alarmofire library, request doesn't send parameters properly. my code: let parameters : parameters = [ "email": tfloginemail.text! string, "password": tfloginpassword.text! string ] alamofire.request(url, method: .post, parameters: parameters, encoding: jsonencoding.default).responsejson{ response in //some code uses response } the parameters variable has count of 2 , both values present, response request error email and/or password being empty. edit: php: /** * account login * url - /login * method - post * params - email, password */ $app->post('/login', function() use ($app) { // check required params verifyrequiredparams(array('email', 'password')); // reading post params $email = $app->request()->post('email'); $password = $app->request()->post('password'); $response ...
Read more