Oracle APEX 4.2.4 Tutorial (04 of 22) - Create triggers and insert data into tables

This video show how to upload SQL scripts in SQL Workshop, a tool without APEX, and run these scripts to create triggers and insert data in tables. (The tables were created in the previous video.) This video also show an example of updating a to-do item in the Team Development tool in APEX.

---

Closed Caption:

oracle apex is a developer tool that
enables us to create working
applications on a database in oracle and
to do that very quickly so in this video
series for rapid application development
we will be using apex 424 if you want to
work along with the videos there are
scripts available that will be run in
the first few videos that create tables
and populate the tables with data now
that we have tables in place i'm going
to go back to SQL scripts and i'm going
to upload a script that would create
triggers so I'm looking for the file
name that says triggers and i will
upload that and i will select that
script and i will say run now i will
check the results to verify that it ran
without errors
so I can go back to SQL workshop into
object browser and i can select triggers
and I can see the triggers that were
created and these are all before insert
with the bi in front of a table name so
for example before inserting a new
student record i could look at the code
that would run in this little bit of
code and a trigger is going to go out to
a sequence get the latest value insert
it in as student ID and then exit allow
the insertion of the data because the
primary key value will be populated now
what I'm going to do is I'm going to log
out as ash weenie and I'm going to come
back in has been because sweeney and Ben
are both working on the data model the
construction of the database been was
assigned the task of inserting data so
as ben i'm going to go back into SQL
workshop and go back to scripts and I
have some insert statements in a script
so I'm going to go get the insert upload
and then i can run the script
run it now and then i can checked the
results and what I'm mainly concerned
with is the fact that i have no errors
so when I come back to the object
browser and look at the tables i can
click the data tab now and see that i do
have data
so I'm going going to come back now to
the team development area to the to do
list and as Ben I could come in and say
that for import existing data I can mark
that as one hundred percent complete so
in the next video
Sweeney will log in and we'll look at
how to create a table using the apex
interface