The only SQL statements you should write in the Application Builder (the Oracle Application Express UI for building applications) are queries for populating reports and tables. Even then, you should simplify those queries as much as possible by using views and, for some complex scenarios, table functions.