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.
In the previous post I talked about scalable vector images. In this post we will integrate Font Awesome in our APEX app, but the steps for the same if you would pick another library.
Step 1: we need to make the library available in our APEX application.
The easiest way to make the library available in your entire application is to add the following line in your Page Template: