Posts by Bruno Cunha • 68 points
8 posts
-
1
votes1
answer126
viewsA: Insert com select - oracle error ORA 00904
There are some problems there, the ID or FK_POSTO are being referenced in the Insert and since they are not null fields, they must exist. To start would create a quence to fill the id of table…
-
0
votes1
answer57
viewsA: VB Visual Studio Cells error
The correct formatted code is: Module Module1 Dim excel As Microsoft.Office.Interop.Excel.Application Dim wb As Microsoft.Office.Interop.Excel.Workbook Dim ws As…
-
1
votes1
answer36
viewsA: How can I run a Rigger that automatically updates a table when an attribute is updated?
The problem may be that Trigger is disabled. First check that Trigger is enabled using: SELECT STATUS FROM USER_TRIGGERS WHERE TRIGGER_NAME = 'filme_log'; If disabled, enable using: ALTER TRIGGER…
-
1
votes2
answers65
viewsA: Search multiple tables at the same time Mysql
As the tables are described, they are not formatted in a normalized form. I think the ideal was to make a table of relationship, that linked Professor to Matter and another linking the class to…
-
1
votes2
answers116
viewsA: Show smaller, average and larger until an empty line is typed
I made some changes to the code and put some blocks try/except because in the question code there was no validation and when a different value was passed than expected the code gave error. However,…
-
0
votes1
answer725
viewsA: Logic SELECT CASE WHEN
I don’t know if that’s exactly what you want but the query below reaches the result expected by you: SELECT ( CASE WHEN (A.de_inf is not null or A.de_inf != '') AND A.de_inf != ',' AND EXISTS…
-
0
votes2
answers78
viewsA: Make teams combination in SQL without repetition
Use the distinct, the sql would look like this: "SELECT Distinct a1.time_name, a2.time_name FROM times a1, times a2 WHERE a1.time_name < a2.time_name;"
-
1
votes1
answer689
viewsA: Long to Varchar data conversion
O select: "SELECT DS_EVOLUCAO INTO VAR1 FROM PRE_MED WHERE HR_PRE_MED = '01/08/2019';" Must be returned more than one result, try to use: "SELECT DS_EVOLUCAO INTO VAR1 FROM PRE_MED WHERE HR_PRE_MED…