Oracle APEX Tutorial (03 of 20) - Run scripts to create tables & sequences

This video shows how to use tools in the SQL Workshop to upload and run SQL scripts. Scripts are available through a URL so you can work along with the videos. The URL is shown in the first 3 or 4 videos. This video series will demonstrate several APEX features: building tables, importing data, building forms and reports, shared components, and more.
URL for scripts: http://web.nmsu.edu/~jkreie/oracle/Da...

---

Closed Caption:

we now want to build some tables running
scripts in apex so if you haven't
downloaded the zip file that contains
that those scripts you need to go to
this URL in order to follow along and
work along with the video i logged in as
a developer in my workspace i'm going to
go to SQL workshop and i'm going to go
to SQL scripts and actually I just are
I dropped everything a little bit ago so
i'm going to go ahead and get rid of
that script so what I want to do is
upload a script i will choose a file and
I have these downloaded so that I see a
set of files and the names may vary
based on what you download because i'm a
change them in the zip file that you
actually have access to your going to
look for the file that says create and
i'm going to open that and upload that
so now have this script and i'm going to
click this icon to run the script and I
click run now
and it's very important that you look at
the results so click that icon and then
scroll down to make sure there are no
errors and we see that a series of
tables and sequences for each table have
been created then I go back to my SQL
scripts and actually what i will do is
go back to the object browser and I now
see that i have additional tables in my
list here not the demos I see the ones
that are related to the database will be
working with and this is probably a good
time to take a look at that data model
for a second so this is the data model
that will be working with we have a
table for projects that teams work on so
projects assigned to a team and
sometimes maybe more than one team we
have students who are assigned to teams
and each student will eventually do an
evaluation of other team members so we
have two relationships here 14 evaluate
whore and 14 evaluate t each evaluation
will contain one or more evaluation
items that are scored and those items
come from the evaluation item table
things such as professionalism promise
to meetings working well with others for
example there are also workshops
available to the students to help them
build their team working skills and so
we have a workshop table and attendance
to those workshops by the students so
this is the data model that serves as
the basis for the the database our
application will use and we can also
select sequences and we can see now that
in addition to the ones created by
oracle XE we have the ones created for
our table such as attendance ID
evaluation ID and so forth so now we
have tables and sequences to work with
those tables in the next video we're
going to create triggers