Monday, March 31, 2014

Query decode oracle query

<select name="status" id="status" onChange="getStatusDetails(this);">
      <option value="S">Stop user</option>
      <option value="N">New user</option>
      <option value="R">Replace user</option>
    </select>


It is insert into database


Now retrieve ::
select  *from (select rownum sl_no,process_id,req_by_id,user_id,area_exec_id,area_id,user_new_replacement_status,decode(user_new_replacement_status,'S','Stop user','N','New user','Replace user') userStatusLevel,start_from_dt,stop_from_dt,instruction_by,instruction_by_name,designation,instruction_date_time from ms_system_user_process order by entry_time desc) where sl_no<11 order by 1


   executiveInfo.setUser_new_replacement_status(rs.getString("user_new_replacement_status"));
                       executiveInfo.setUserStatusLevel(rs.getString("userStatusLevel"));   


Jsp page ::
<td><div style="float:left;width:50px;height:auto;display:none;"><s:property value='user_new_replacement_status'/></div>
         <div style="float:left;width:120px;height:auto;"><s:property value='userStatusLevel'/></div>
     </td>



DB ::

No comments:

Post a Comment