Most voted "apex" questions
None
Learn more…13 questions
Sort by count of
-
1
votes1
answer116
viewsRemoving comma from the pl sql column
Good afternoon, I have a table that has names. In some lines the name is separated by comma. Ex: Alberto, Luiz I want to change these lines to stay Luiz Alberto DECLARE final VARCHAR(50); inicio…
-
1
votes1
answer126
viewsInsert 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
answer74
viewsError in APEX_APPLICATION.G_F01 - ORACLE APEX
I have a problem with this script below: I have a checkbox on my page ( not in report, on the same page, a page item) and I would like the same when clicking and pressing a Ubmit button to perform…
-
0
votes1
answer55
viewsSalesforce Query Returning Wrong Date
In Salesforce when I run the following query SELECT Data_de_Nascimento__c FROM Account WHERE id = '0013K00000ABC' he returns me 1999-05-29 In Java, after I set up the integration, I run this…
-
0
votes1
answer164
viewsApex: Different condition for Accountid
In the code below I used the variable AccountId to obtain the account with the name "Integration AWS", but I need the consultation to not take accounts that were changed by "Integration AWS". How…
apexasked 4 years ago Célio Xavier 19 -
0
votes0
answers37
viewsHow to limit to not being able to pass 3 units of a book in a PL/SQL ORACLE rental
I’m making a bookstore in APEX and I can’t allow the client to rent more than 3 books. But even putting the code the program does not bar. declare W_QUANTIDADE_EMPRESTIMOS number; W_STATUS…
-
0
votes0
answers16
viewsConvert Long Raw Data to BLOB ORACLE DB
My situation is as follows, I have 2 tables with different Owners, a stores the photos of the company’s employees in formed LONG RAW and on the other site I need to fetch these photos and present…
-
0
votes0
answers8
viewsPaging oracle Apex without updating query
Hello I’m with a problem, my company has a screen where we have a classic report which contains people’s permissions for screens and system functions, but we have a problem, we have a query that…
-
0
votes0
answers6
viewsOracle Apex upload data via csv file
I have a problem in my system, I have a demand where I need to implement a functionality to be possible preencher dados através de um arquivo csv, a company would create in Apex the records for the…
-
-1
votes2
answers62
viewsDatabase Register
My database has this structure. I would like to know how to create the record on PEOPLE and at the same time get the ID and save it on PESSOAS_FISICAS. I created this command for such, but it didn’t…
-
-1
votes0
answers10
viewsHow to send data to Oracle with jQuey
Hello! On an Apex page, a pdf is generated by clicking a button, this is done by Jquery. I would like that when that same button was pressed, a data was saved in a table field in the BD (Oracle).…
-
-2
votes2
answers1446
viewsHow to pick up array index?
I have the following APEX code List<integer> entrada = new List<integer>(); public static void generateStringArray(integer entrada){ List<String> ListaPrincipal = new…
-
-2
votes1
answer17
viewsStore as much data as I want in a tebela column in oracle Apex
I’m creating a page on Apex And I need to create a graph of the reasons that cause the most fines, but a fine can have several reasons. I’m not able to store these reasons so I can generate the…