Posts by Jose Gustavo Lima • 39 points
8 posts
-
2
votes1
answer60
viewsQ: Return multiple keys using REGEXP_SUBSTR
I am trying to read occurrences of text records based on an occurrence. By breaking my head I got the following results: For example I want to take the second name, using as a basis the key Empr.:…
-
0
votes2
answers44
viewsA: Doubt group by oracle
Bruno Warmling, Thanks for the tips. I tried the solutions, using the two examples and was not very happy in the first using all columns of the table employed_no_post. Maybe I forgot some detail. In…
-
0
votes2
answers44
viewsQ: Doubt group by oracle
I want to do a group by between two tables by doing an Inner Join. The employee table and the table employed at the post. I want it to return to the most recent entry into a post of a given…
-
1
votes1
answer126
viewsQ: Insert com select - oracle error ORA 00904
I’m having trouble understanding why this mistake. I want to insert a field {descricao_posto} on the table TB_POSTOS_NO_CONTRATO, using a select from another: TB_POSTO. A 1a. table has a fk_post…
-
0
votes1
answer75
viewsA: Error while creating a PROCEDURE
At least in the Oracle Apex environment you should include the Insert columns, as in this example: INSERT INTO cliente (RAZAO_SOCIAL, CNPJ,SEGMERCADO,FATURAMENTO_PREVISTO,CATEGORIA) VALUES…
-
-1
votes1
answer74
viewsA: Error in APEX_APPLICATION.G_F01 - ORACLE APEX
From what I understand the Checkboxes will be filled in if the collaborator is the application user. Test this code in textfield, for example. You should simulate these situations in other contexts,…
-
1
votes0
answers195
viewsQ: View button after Ubmit from oracle page Apex
I have a test page on https://apex.oracle.com/pls/apex/f?p=43921:2 user test password test, which already working ok, in general. It migrates employees using a shuttle object, and using Collections…
-
0
votes2
answers265
viewsQ: No update of a Collection PL/SQL
I am trying to update a parameter in a table, based on previous values of a Collection, it will update the idAccept attribute of a particular document table id. I also created an Insert in a test…