Posts by Levy Santana • 13 points
4 posts
-
0
votes1
answer209
viewsA: Convert DATE in SQL (Oracle) from UTC to Brazilian time zone
First, program the data when performing operations that are date and time with time. Separate in column, after that perform the calculations. Try creating a view with the information in the format…
-
0
votes2
answers144
viewsA: CASE WHEN in Where clause and with THEN with more than 1 return value
Remember the logical operators, if using and (it will have to validate everything inside), if it is among some of the values use OR. Something like that between: where ( case when condicao1 then…
-
0
votes2
answers55
viewsA: Add several selects
Whenever you use a Union, make sure the columns have the same name. After using Union, you can create a view. And in another you group and account. Since I don’t have much experience I always use…
-
1
votes1
answer186
viewsQ: Sum PL SQL Lines
Galerinha, I created a code that organizes all the tasks of the company by sector. The objective of this code is to identify the percentage of delayed activities by sector. The result was expected.…