Posts by Rodrigo Macaúbas • 19 points
5 posts
-
-1
votes1
answer64
viewsQ: Only get snippets between brackets
In third-party software, a log record is generated with separate information through words that comes within a bracket. Example: [informação1] [informação2] [informação3] The problem is that the…
-
0
votes1
answer35
viewsA: PLSQL shows error: PLS-00103 in function when using an Exception
figured out the problem. I was creating two CASES. AT THE LINE WHERE IT IS WRITTEN: CASE WHEN P_TIP = 2 THEN CORRECT WOULD BE ONLY: WHEN P_TIP = 2 THEN
-
0
votes1
answer35
viewsQ: PLSQL shows error: PLS-00103 in function when using an Exception
PLSQL is reporting error PLS-00103 when I try to compile this function. Note: If I try to run only with the first option of this case "P_TIP = 1" it runs normally. If I try to add the case "P_TIP =…
-
0
votes0
answers124
viewsQ: Division by zero in PLSQL
Hello. The Code below sometimes does not run because it is presented the error: You cannot divide by zero. I tried to do with a case, but my code is too big and the case would leave the structure…
-
1
votes1
answer66
viewsQ: How to join the select of these 3 tables that have no connection at all?
The image below shows 3 tables, united by Excel. The first is called customer, the second representative and the third is called channel. But I would like to join them in a single select in sql, and…