Hello, one of students asked me how he can use Oracle map in ADF application. So in this lecture, I will show you how you can use Oracle map to display buoyant in the map, which is please the location of a specific department. And once the user permissions appointment, he should see some information. So if you have a look in the HR database, you will find here, the department's has a location ID. And this location ID has some information about which is a location. But to display a point in a baby map you have you should have a coordinate x and y.

So, in the location table, I will add two more column one is location x location y. You can find the script to add this to column attach it to the lecture here. I will create A new column called location underscore x and it should be number location underscore y and it should be not. Okay. So I have added this two column in the location tip let's now create a new application if application can see Oracle Application knickers okay. You table this Select is sure.

Okay. An entity we need department and you will need location. This is a view object. Okay now I need a view object, which has this location now as view object which has x location x and y, location x and y. And here is the department. So I need one view object which display the department information department ID department manager and instead of location ID I need to get a location x location y and all informations location likes three posts city information, how I can do this.

Now as I as you can see here the department has only location ID which should map to this location ID, but I need to get all this information here in the same department view. There are multiple way you can do this you can add like a transient attribute and in the select the SQL you can select the statement or generic Java class and from the guitar of this transit attribute to contract SELECT statement which would get all this information. But there are easy way without writing any code writing any SQL SQL statement you can create a view object which is based on to view of your entity object sorry, you have department entity, you have a location and associate Between divorcement and location. So, I will create here a new view object. This view object should be based on two entity objects. So I can say here depart mints and look a shin view and it will be based on entity but is the entity I will select the post department and the location both but how the robot will generate the SQL statement it will generate SQL statement based on the association which is created between department and location.

You will see the query after generates this view object. The department will be updatable user updated location will not be updatable. If you need the location to be updatable. You can select updatable option, but for now, we don't want to make any updatable so I will keep it as it is. Nick is here you You will decide which attribute you want to display or need to display, the department ID department name plus i can display patient ID, city, street address, postcode, and of course we need occasion x and occasion y z chord. So this view object now will have the department information blas the location information.

Biggest, biggest, biggest, biggest finish. So let's have a look into the query of this. You will find here it's select the department name, Id location all what we need from departments and the location where location department location ID equal location. This is the association or the link between both tables. So now I have one view object which will display my department and X and Y for each department, I need to create a PDF application Sorry, I need to create a page This page has split into site one which displays all departments and here in the left hand side or the right hand side will be a map which will displays the location of Studies Department on the map Okay, so, let us just go to application module data model and shuttled this department and the location so, that they can use it in the view layer.

Okay. So, this is what we need from the model layer now, here in the view layer, let us create a new page can call this page map make it blank page So in this page, I will add benilde splitter okay maybe here 600 the first one I need to display is the department and to location view as a table read only table and you can just display okay all information exists Okay, here is a table and let us add here just been in group which we will add map inside the row. Okay I will drag the same for you and they will select to hear you metric map, map and buoyancy we need to splay map and pointy here to display a map in your application you have to connect to the map server. So, should be a server this server has all the information related to the locations a coordinate and so on.

So, this server already exists in the Oracle site. So I will create here a map configuration here or you can write any ID map viewer ID. I will generate here map view or ID URL here you can call it Oracle map for example, and here is there is a URL endpoint which should point to the Oracle map server. It should be HTTP IE location to oracle.com Home slash map viewer This is the entry point to the Oracle map viewer server just this connection it is successful and I will press OK. Here you select your Oracle password. So this is your configuration let us press OK and see now it bring here you map you can see that x and y and the level of zoom which level of zoom you want to initially display.

So here we can configure this later. Okay, now I will press ok this is our scene here I need to display the point using x&y so I will select x&y here x I will select location x, y, I will select location y, here is the label if you want to display the birth mint as a label and department name as a date okay. So, this is how you can configure the Oracle map component and how you can set x and y which you already defined the view object into as a longitude and latitude. So your view object should have x and y values which will be able to pick it here and I will press OK. So this is my map. There are some configuration on the map we will do but before going and running this we need to sit Zed location x&y data here.

Some x&y Here we need to set it here so that you can see some point on the map. So what I will do now I will go to the Google map now and I will pick some location. For example, this is Roman Italy, I would select x&y and I will set it here. Apps This is our map so we can search for Roma Italy. Okay, and we can make any. For example, we need this just to press on it or you can just right click here and select what's here.

You will find here this is excellent why you can select it Here you will find your x&y so this is our x pack here and this is why okay we can make another a police drama for example here right click what's here you will find this is selected or you can get someone some someplace bit for what's here to connect to this you will find here this is x and this is Okay. You can pick any other a from any other location if you go for example, in London let's pick x axis and y. That's wrong. This should be x and this is like this okay let's just see if this sister here okay? That's enough let us commit okay and now we can see here, x and y, two points in the map. Here at the bottom it says select here is the malt with public nation.

So now you can see now some points splayed, which have all x&y in the map. So a and once you press in it you will find the department and at the bottom it name y department name is a beer here because if you go two page definition of this map, selected this map you will find here with splayed department name. So if you want to display multiple or different information like city street, whatever you can create like a transit attribute which will display the department ID and the name and the city and all information and you can select this attribute Hear as at that. So, this is why you can see here your department name appear for each point. Now let's make some a change on this map or configuration like this is the overview. You want for example, by default to to be collapsing or you want to remove it at all you want to change this icons, you want to change this code right you want initially a start with this level and in this in Europe area for example, because by default it will start in the windows two point.

If there is no point it will display like this, but no I need to display it in zoom for example, three buttons that case it will display it in this location. So with all this other We'll show you how you can do this. So, let us back to the maps here, go to properties. Here starting x and starting y, here you can say what is the starting point here is the map zoom. For example, if I say map zoom, I need to start with zoom four. So let us refresh the map.

So, you will find it is started with zoom number four, if you want to go more deeply, so you can say I need to be in zoom five. Okay, so in that case, the map will be stored in more zoom which is five but I need to start point should be In Europe, for example, like here in this area, so you have to give X and Y for the map to start with. So for example, I need to go to here in Europe and I need one example this x and y to be our starting point, so I will go here and I see x should be this. Why should be this? Okay, this is starting x and starting y and because this won't be four let's go back here and refresh. So as you can see now why in zoom four and starting in this location if you want to increase the map with some height, so you will find here and by default in this tire, you will find here the width and height of the map so you can see okay I needed it hundred and height maybe 675 so I will refresh this.

So all is this some app you have. Okay, if you want to it disappears this for now. So what you can do with us here make it the height be a little bit less Okay yeah so okay this is our web now I need By default this overview to be collapsing like this okay. So, how you can do this you can add insights this map overview and in the overview appearance here you can see if you want it to visible or not or initially show or not so I say initially show false. Okay, so I will set this to be false and if you do want to display it at all you can see this video With default, this is the width and the height of their overview width and height. You can change the width and height, but I need to make initial issue shown no.

So I will refresh it now. You will find by default it is collapsing here and your user can open. Okay. If you want to change this Orange Bowl to anything else, you can select it map point theme here. Built in image you can select any image as you can see anything like for example, flag grid, that is right here. Like red.

You will find here fleck rate is happiness. And if you want to, once you select this since it's the current row of the current selected department, you can do this. If you go to big definition here and you mark enable true selection, enable row selection it means once you select the point in the map, it will sit the current row as a selected row. So if you display the department here as a form of example and select this, you will find the department selected department will be the current row. Okay, if you want to change the copyright here to you was a copyright. You can do it in the map itself.

He is zero or data, copyright tickets you can write your code we write like this, your copyright will be here. So this is quickly how you can use Oracle maps to display some location and place some information on each location. This is a quick lecture. Hopefully you get the point now of how you can use Oracle map