As you have seen, it is possible to write highly functional web pages using only items, reports, and charts. But to implement anything more complex, you have to be able to perform calculations and interact with the database more generally. The notion of a process addresses both issues. This chapter examines some typical situations that require the use of processes, and introduces the basics of PL/SQL so that you can write your own code to implement these processes. It also examines the pitfalls you might encounter with writing PL/SQL code, such as the possibility of lost updates. Finally, the chapter discusses the built-in ...

Get Understanding Oracle APEX 5 Application Development, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.