Bootstrap Progress Bar
1. --CSS INLINE .progress-bar { display: -ms-flexbox; display: flex; -ms-flex-direction: column; flex-direction: column; -ms-flex-pack: center; justify-content: center; color: #fff; text-align: center; white-space: nowrap; background-color: #007bff; transition: width .6s ease; } .progress { display: -ms-flexbox; display: flex; height: 1rem; overflow: hidden; font-size: .75rem; background-color: #cfdae4; border-radius: .25rem; } -- COLUMN HTML EXPRESSION 2. <span> <div class="progress" style="height:20px;"> <div class="progress-bar" style="width:#Colum_Name#%">#Colum_Name#% </div> </div> </span> --COLUMN CALL BY FUNCTION 3. create or replace function progress_bar(p_value in number) return varchar2 IS l_height number:=20; begin return '<span> <div class="progress" style="height:'||l_height||'px;"> <div class="progress-bar" style="width:'||p_value||'%">'||p_value||'% </div> </div> </span>'; end ; -- CALL FUNCTION FROM REPORT QUERY 4. SELECT progress_bar(Colum_Name) FROM table;
No comments:
Post a Comment