1
00:00:00,750 --> 00:00:01,430
Hello.

2
00:00:01,440 --> 00:00:07,820
In this lecture we are going to display the hey tarski mark objects.

3
00:00:10,170 --> 00:00:17,080
In our previous lectures we created here work space for the application express.

4
00:00:17,150 --> 00:00:21,390
I have logged into workspace and thus my workspace there.

5
00:00:21,390 --> 00:00:22,420
That's a name.

6
00:00:22,650 --> 00:00:23,700
So what we going to do.

7
00:00:23,700 --> 00:00:32,430
Because we during the database installation we are unlocked and got access to a scheme our court here

8
00:00:32,490 --> 00:00:34,200
Chas saw.

9
00:00:34,210 --> 00:00:40,320
I want to have a look at the objects or what's inside this scheme.

10
00:00:40,650 --> 00:00:42,430
To do that we're going to use their school.

11
00:00:42,450 --> 00:00:51,180
So we call a skill workshop and click on that strub down and select skewl commands escudos also refer

12
00:00:51,180 --> 00:00:52,430
to a sequel.

13
00:00:52,470 --> 00:00:54,990
So select the sequel command.

14
00:00:55,130 --> 00:01:02,810
And this is where we write our commands car like an editor for the database.

15
00:01:02,940 --> 00:01:10,080
So the command we will write to display the objects in the hitch our scheme is so we begin with the

16
00:01:10,080 --> 00:01:11,040
word select

17
00:01:15,660 --> 00:01:21,540
select is used to get data or information out of the database.

18
00:01:21,750 --> 00:01:24,750
So we type in select fuller by the word object

19
00:01:29,490 --> 00:01:30,720
Honda score name

20
00:01:34,710 --> 00:01:35,380
comma.

21
00:01:37,250 --> 00:01:42,800
Followed by another column which is objet columns.

22
00:01:42,830 --> 00:01:45,430
Names are separated by columns.

23
00:01:45,510 --> 00:01:51,500
Commas so objects want to score type.

24
00:01:51,500 --> 00:01:54,560
So we are selecting two columns.

25
00:01:54,560 --> 00:01:59,180
One will be the object name and the other will be the object type.

26
00:01:59,480 --> 00:02:08,660
So we get to specify where we are getting them from and the from is what you use to reference the database

27
00:02:09,390 --> 00:02:10,680
so be from.

28
00:02:13,830 --> 00:02:16,970
Could use the object.

29
00:02:19,850 --> 00:02:25,040
So the user underscore objets.

30
00:02:28,330 --> 00:02:29,370
There's a semicolon.

31
00:02:29,370 --> 00:02:35,000
You always have to place a semicolon on the end of your sequal statements.

32
00:02:35,010 --> 00:02:43,640
So what this should do if the script or the query works it will give me a list of all the objects under

33
00:02:43,650 --> 00:02:47,000
type present in the chart.

34
00:02:47,460 --> 00:02:51,850
Because we do this from here.

35
00:02:52,000 --> 00:03:03,090
Use the objets I am locked down here as hey char saw the user here what he's referring to is a chart

36
00:03:03,090 --> 00:03:11,600
so it all pick up this new user from my logging in it will notice that I have logged in as a chart so

37
00:03:11,650 --> 00:03:15,450
it would be picking up the objects from the HEAR child user.

38
00:03:15,710 --> 00:03:22,290
So I click run excellent descriptors work so this is the result output.

39
00:03:22,620 --> 00:03:29,470
So it tells me that these are the these are the object name and these are the object types.

40
00:03:29,580 --> 00:03:37,240
Got he tells me here this is a table called regents and told me this is an index.

41
00:03:37,290 --> 00:03:38,600
Does the name of the index.

42
00:03:38,610 --> 00:03:40,990
This is another table called.

43
00:03:41,340 --> 00:03:49,510
And does the index so it looks Ive got tables an index Ive also got a sequence here called locations.

44
00:03:49,560 --> 00:03:53,150
So we've got here more than 10 rules available.

45
00:03:53,520 --> 00:04:00,010
So that tells me here 10 rules returned in 0.01 seconds.

46
00:04:00,020 --> 00:04:04,480
I give you the option also to download this if you wish.

47
00:04:04,770 --> 00:04:13,770
So now we have an idea of the tables we have access to from the hay chart came.

48
00:04:14,220 --> 00:04:23,850
We are going to create a database driving crowd and the question crowd meaning you create you update

49
00:04:23,880 --> 00:04:35,910
and you delete so the application we going to create will allow us to add to update and also to delete.

50
00:04:36,270 --> 00:04:47,100
So based on the information we have here I am going to create an application look into the tables here.

51
00:04:47,460 --> 00:04:51,890
We have got to look at the view disturbers again.

52
00:04:52,590 --> 00:05:03,210
So we've got country locations departments and so on.

53
00:05:03,210 --> 00:05:05,000
There are more than 10.

54
00:05:05,010 --> 00:05:13,170
So he tells me here that to increase the rules selektah you need to increase the view so here tells

55
00:05:13,170 --> 00:05:22,970
you that you can select 10 rules at a time so you just need to increase this that to see that.

56
00:05:23,430 --> 00:05:28,140
And if I run this again it will give me more moros.

57
00:05:28,380 --> 00:05:28,860
Okay.

58
00:05:28,860 --> 00:05:29,410
There you go.

59
00:05:29,410 --> 00:05:32,790
So expanded its more than 20 rows.

60
00:05:33,090 --> 00:05:33,770
Okay.

61
00:05:33,850 --> 00:05:37,070
It tells you again if you want to expand that you just create more.

62
00:05:37,060 --> 00:05:42,670
Just increase what grows it displays here.

63
00:05:42,870 --> 00:05:44,510
So well look that's true.

64
00:05:44,550 --> 00:05:49,800
These are both stable headquarter employees.

65
00:05:49,890 --> 00:05:57,960
Let's see what that table is into a query so to get to all the information from that table you do select

66
00:06:00,300 --> 00:06:03,270
star from

67
00:06:06,060 --> 00:06:08,380
employees always put a semi call on the air.

68
00:06:08,390 --> 00:06:14,530
So if I run that tell me everything note is it would display 30 rules at a time.

69
00:06:14,730 --> 00:06:16,470
I want to increase the number of rows.

70
00:06:16,470 --> 00:06:17,760
These are rows.

71
00:06:17,910 --> 00:06:19,540
I can increase that here.

72
00:06:19,830 --> 00:06:27,240
So these are all the columns all these one here columns the ones vertically are rows.

73
00:06:27,600 --> 00:06:34,220
Okay so one going to do we are going to create a application from the data here.

74
00:06:34,830 --> 00:06:35,420
Okay.

75
00:06:35,440 --> 00:06:39,060
So all right so I'm quite happy with your content.

76
00:06:39,270 --> 00:06:47,660
So this is the table we are going to target and create a database driven application from this Employees

77
00:06:47,670 --> 00:06:48,350
table.

78
00:06:48,630 --> 00:06:51,130
For now we're going to end this year here.

79
00:06:51,240 --> 00:06:59,580
I hope the lecture has been useful and create more exciting stuff in the next lecture by beginning to

80
00:06:59,610 --> 00:07:05,860
create an application that will be driven from the data inside the data piece.

81
00:07:06,120 --> 00:07:07,350
Thank you for watching.

82
00:07:07,350 --> 00:07:08,290
Bye for now.
