I am not sure how many times it has happened to me that I can't use my login for this site. Today, it is not possible to login into that application - again. I was trying to reset my password several times for both accounts I have there. I received the emails with a token, entered that token and after changing the password, nothing happens. I didn't even receive a message that the login isn't possible or wasn't successful. Simply nothing shows up. Maybe I am just not getting it and there is a step I am missing...
Did you know you can recognise an Oracle APEX application through the url?
Here's the syntax:
Let me give some examples:
We all know the regular expression syntax is fast and you can do amazing things with little code snippets. But we do know as well that whenever you need it then you have no idea how to write it down. To be able to find a solution for your problem you use the WWW.
So here you have another example you may need one day. :)
I had to check a string for special characters and numbers. In those cases the rows should be highlighted.
Here is a simple example how to do it:
val as txt,
A couple of day ago a had a task to combine a list with itself. The result should be a two column report of each possible combination.
What should note be part of the result:
- same element combination should be excluded
- duplicate rows (even if the sides are switched)
Because I was just not able to solve it myself *actually it's awful after I now know how to do it* I had to create a forum entry:
Oracle SQL and PL/SQL forum: Generate some kind of cartesian list
Oracle is gearing up to release APEX 5.0... the final early adopter release (EA3) will be released soon. Over 6000 people participated in APEX EA2...
In the previous post I showed some options how you can represent a many-to-many table relationship in a report using the LISTAGG Oracle function.
In this post we will edit a record and see how we can represent the data in a Form and save the data back to the different tables.
First I create a Form on the main table (customers) by just following the wizards.
Consider my case: I've a customer table and a products table. Customers can select multiple products they want to have. The diagram look like this: Customers on the left, Products on the right and a table in between that says which customers like which products. Customers might have multiple products and products might be linked to multiple customers - so a many-to-many relationship.