The First Project

Let’s start with the strawberry on the cake—because that’s how we do it, right? We begin with a project. And not just any project… we’re going to build a Pokédex in Oracle APEX.

Now, if you're just starting with Oracle APEX, don’t worry—I’ll also be creating a series called Oracle APEX Basics, where I’ll explain everything step by step. You’ll be able to follow both projects side by side!

So, why a Pokédex, you may ask?

At first glance, it might look like a simple project—but that’s actually not true. We’ll need to explore a lot of different features: consuming APIs, creating cards, building search and filter functionality, and even creating a region that displays Pokémon types and images.

Do I know how I’m going to do all of that yet? Not really. 😅
But hey—I never said I’m a perfectly organized professional. This is going to be an adventure, and I hope you’ll join me for the ride!

Let’s make a roadmap

🗺️ Roadmap (aka “My Master Plan That Will Probably Change”)

1. Create basics tables and populate them using PokéAPI;

2. Build the application and design cards showing each Pokémon's name and image;

3. Add a toggle to switch between normal and shiny Pokémon;

4. Add basic filters to search by Pokémon name;

5. Find a way to show Pokémon type images and names—and use them as filters;

6. Struggle with it, get lost, go back to the drawing board, and repeat steps 5–6 forever;

7. Ask for help and apply the solution as if it were mine (credits somewhere, maybe 😅);

8. Make the cards clickable to show detailed Pokémon info;

9. Adventure with css to make the page more “pokedex-like”.

Time to punch out and let the code rest.