Posts by Ana Paula Freitas Paulino • 9 points
2 posts
-
-1
votes1
answer195
viewsQ: CLOB Filter - Number+text
I have a system whose all fields of a document are Clobs, including combo box with measly "Yes" and "No". I am building a query, I need to filter a Clob field and the values are '0||Yes' and…
-
1
votes0
answers587
viewsQ: How to calculate hours per shift
I have a table in oracle with start time and end of surgeries, I need to add the hours per shift (from 6 am to 11:59 am morning, 12pm to 17:59 pm is afternoon, 18h to 23:59 pm is night and 00 is…