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.