Hello.
In this lecture we are going to display the hey tarski mark objects.
In our previous lectures we created here work space for the application express.
I have logged into workspace and thus my workspace there.
That's a name.
So what we going to do.
Because we during the database installation we are unlocked and got access to a scheme our court here
Chas saw.
I want to have a look at the objects or what's inside this scheme.
To do that we're going to use their school.
So we call a skill workshop and click on that strub down and select skewl commands escudos also refer
to a sequel.
So select the sequel command.
And this is where we write our commands car like an editor for the database.
So the command we will write to display the objects in the hitch our scheme is so we begin with the
word select
select is used to get data or information out of the database.
So we type in select fuller by the word object
Honda score name
comma.
Followed by another column which is objet columns.
Names are separated by columns.
Commas so objects want to score type.
So we are selecting two columns.
One will be the object name and the other will be the object type.
So we get to specify where we are getting them from and the from is what you use to reference the database
so be from.
Could use the object.
So the user underscore objets.
There's a semicolon.
You always have to place a semicolon on the end of your sequal statements.
So what this should do if the script or the query works it will give me a list of all the objects under
type present in the chart.
Because we do this from here.
Use the objets I am locked down here as hey char saw the user here what he's referring to is a chart
so it all pick up this new user from my logging in it will notice that I have logged in as a chart so
it would be picking up the objects from the HEAR child user.
So I click run excellent descriptors work so this is the result output.
So it tells me that these are the these are the object name and these are the object types.
Got he tells me here this is a table called regents and told me this is an index.
Does the name of the index.
This is another table called.
And does the index so it looks Ive got tables an index Ive also got a sequence here called locations.
So we've got here more than 10 rules available.
So that tells me here 10 rules returned in 0.01 seconds.
I give you the option also to download this if you wish.
So now we have an idea of the tables we have access to from the hay chart came.
We are going to create a database driving crowd and the question crowd meaning you create you update
and you delete so the application we going to create will allow us to add to update and also to delete.
So based on the information we have here I am going to create an application look into the tables here.
We have got to look at the view disturbers again.
So we've got country locations departments and so on.
There are more than 10.
So he tells me here that to increase the rules selektah you need to increase the view so here tells
you that you can select 10 rules at a time so you just need to increase this that to see that.
And if I run this again it will give me more moros.
Okay.
There you go.
So expanded its more than 20 rows.
Okay.
It tells you again if you want to expand that you just create more.
Just increase what grows it displays here.
So well look that's true.
These are both stable headquarter employees.
Let's see what that table is into a query so to get to all the information from that table you do select
star from
employees always put a semi call on the air.
So if I run that tell me everything note is it would display 30 rules at a time.
I want to increase the number of rows.
These are rows.
I can increase that here.
So these are all the columns all these one here columns the ones vertically are rows.
Okay so one going to do we are going to create a application from the data here.
Okay.
So all right so I'm quite happy with your content.
So this is the table we are going to target and create a database driven application from this Employees
table.
For now we're going to end this year here.
I hope the lecture has been useful and create more exciting stuff in the next lecture by beginning to
create an application that will be driven from the data inside the data piece.
Thank you for watching.
Bye for now.