How to Create REST API for database table using ORDS Oracle REST Data Services, What is ORDS? demo
- March 18, 2024
- Posted by: MainInstructor
- Category: Go Oracle Database SQL
Video Title: How to Create REST API for database table using ORDS Oracle REST Data Services, What is ORDS? demo
In this class we are going to learn about the Oracle R data services also known as ords suppose if you working on building some business use case or implementation wherein you have to interact with your database in order to fet the data from the table and present
It to the user like you have to develop an integration layer in order to fish the details and show on the user interface for a user to take the actions like modify the details or get the insight into the data present in your database for this purpose if you usually
Building the web service which can fetch the data then you are sending those details to the client with the help of the apis you have built then you don’t have to worry much about now because Oracle has created this ORS which makes the life easy for developers
With the help of ORS you can just concentrate on building the business requirement or the solution for your customers rather than thinking about how to build an integration layer which can talk with the database F the details and provide the details further to the client application just with the one
Click you will be generating a rest API for your database that is to F you need update and to pack I’m here in the official documentation Page by Oracle that is for the ORS you can have a look at this with the help of ORS with the
Help of few button or clicks you can create the rest apis for your database in order to interact with the tables views plsql also you can create the rest AP for your custom Services which you have built with the SQL as well as the plsql also this ORS will generate an
Open API documentation just with the one URL you can generate the ENT API definition for your application also this ORS comes with the full developer support you will have a graphical user interface to create the ORS you will be provided by the command line interface
As well as there are apis with the help of which you can create the ORS rest API for your tables and the plsql also you can make use of this Oracle SQL Developer web version as well as the on provise and with the help of worksheet
You can just look at your data present in the table also you can create the ORS for your tables and the views as well as the plsql with the help of SQL Developer also there are database management apis we can have a look at this documentation Page by Oracle for further details
Alternatively you can make use of chat GPD or Google generative AI which can tell you more about the ORS and the solutions what you can build so without wasting much time let’s begin with our handson for our use case I will make use of the Oracle database that is autonomous transaction processing ATP
Database what I have in my tency you can make use of the database what you have mostly all the latest Oracle databases supports ORS first thing is in order to make use of the ORS just click on this and click on the rest it will open the Oracle database rest interface for you
Here you will get the list of all the clients what you have created in order to interact with the database that is with the help of ORS suppose if you have secured then only you will find the clients over here suppose if you have created the roles or the Privileges
Privileges in the sense you can create the mapping between your roles and the database views so we will see one by one how we can create the RO privileges but first and the foremost thing we will create a simple table and we will create a ORS without the security and by making
Use of this rest API we will fet the details from our database and show in our visual Builder screen so without wasting much time let’s see how to do the same with the help of SQL Developer I will be making use of this SQL Developer suppose if you want to
Make use of the SQL Developer web we can just click on this SQL it will launch the SQL veler web and there also you can do the same so first and the foremost thing is you have to create the table as of now we don’t have any tables in our
Database so I will create a sample table that is to show the details of employee I will first create a table over here let me just run the script our table got created successfully then I will try to insert few records I will insert details for five employees over here now I will
Run this queries our rows are getting inserted let me just commit the changes before we proceed ah head there is a spelling mistake click on R changes got committed successfully let us now just see the records are present in our database let me just run this qu yeah our five employee records are
Present over here let me just delete everything from here now so whatever things I have shown over here in the screen like the rules privileges clients those information you can get with the help of these commands as well like select start from user roles you will show the roles if you
Want to get the list of all the Privileges from the screen you can get from the screen or with the help of table suppose if you want to see what privileges are being mapped to which table or the view you can get the details suppose if your ORS rest apis
Are secured you can make use of these clients and see what and all details are present for your client that is authentication here the clients are we are using that is for securely accessing our ORS apis with the help of all 2.0 standards let me just refresh here and
See the table has been created that is employee details table first and the foremost thing in generating the ORS based rest API for your database table we have to enable the ords for your schema I’m making use of admin schema over here in order to connect to this database so right click
Over here go to rest services and you have to click the enable rest service at the schema level we are not enabling the authorization but in our subsequent classes we will see how to secure our API as well now if you don’t want to show the exact name for the end user we
Can just change the name it will create an CL so that we can secure our backend naming convention just click on next and click on finish so this will be creating a ORS for your schema next we have to select the table right click over here and we have to select this enable
Rest service here you have to uncheck this authorization request as I told we will cover this authorization part in our next class and you can provide an alas if you want to provide the same name you can provide the same name but better to not give underscore just give
The naming convention which is available across the web like without the underscore by using the smaller letters click on next here you will see the summary authorization we have selected no click on fishh done now once you have done this part we can just switch over to the Oracle database rest interface
Over here just refresh this page here if you see we will be seeing one more privileges got added that is the employee table if you want you can just click on this and click on edit and see this is a new privilege it has added
In order to access the table that is the employee table let me just go back to the overview next question is how we can make use of the ODS rest API which we have created just now so for that we can just go over to this again the rest
Client and just click on this copy metadata catalog so you can make use of a notepad if you see over here this will be your host for your ATP database next comes the keyword that is the ORF next comes the schema wherever is your table has been created or the ORS has been
Enabled in our case ORS has been enabled for this admin schema then we will get the metata catalog just copy this and make use of any browser of your choice I’m making use of Google Chrome over here just click on enter in order to read this just copy this from here make
Use of a notepad++ I will be formatting this by making use of this describe URL we will be see all the API available let me just copy this and I will see all the API available for this employee table if you have noticed when we enabled the
Rest service for the employee table we had provide this l so this is the response what we got let me just format this here if you see with the help of that URL we will be fetching all the details whatever was present in the table now you might ask that there could
Be other operations as well apart from the fetch so in order to know those we can make use of this open API catalog URL over here just copy this and paste it over here so this will be giving you the information of all the supported apis available for this ORS rest API for
Employees table so here is the response let me just copy it and paste it over here remove the existing and let me just format in order to delete any record we have to make use of this path that is Slash and the HTTP method is delete so
That is the URL is same whatever we have to use this HTTP method is differing we had already seen this get method here we have to not pass anything just the URL that is a base URL you have to provide and we will be getting all the details
In the response also it is supporting the query parameter as well suppose if you want to make use of the post we can make use of this URL and the HD method Post in order to modify the details in the employable table suppose if you want
To bash load anything you can make use of this apis suppose if you want to access only one particular API we can make use of this ID so so I will demonstrate this use case now I will copy the base URL from here and copy it
Over here and I will make use of this slash ID so in our case we had provided ID as 100 200 100 101 102 let us just see once again what and all details we had entered select start from employ details here in your case ID is 1001 102
Suppose if we provide it over here 101 we will fet the details of only that particular employee so if you want to read this properly just copy this from here and paste it over here and just format this so here we will get the details like employee IDs 101 rul so
Like this we can create the ORS based rest API for our Oracle database table I’ll fish the details and carry out other operations all our table with just few button clicks
Video Keywords: Oracle Database
-
Sale!
Wireless WIFI Repeater Extender Amplifier Booster 300Mbps
$29.99$14.99 Add to cartWireless WIFI Repeater Extender Amplifier Booster 300Mbps
Categories: Electronics, Wi-Fi Router, Wireless Wi-Fi Extender Tags: 300Mbps, 802.11N, Amplifier, Booster, Extender, mobile wi-fi booster, Remote, WIFI, Wireless, Wireless WIFI, Wireless WIFI Repeater, Wireless WIFI Repeater Extender, Wireless WIFI Repeater Extender Amplifier, Wireless WIFI Repeater Extender Amplifier Booster, Wireless WIFI Repeater Extender Amplifier Booster 300Mbps$29.99$14.99 -
Sale!
Full RGB Light Design Gaming Headset Headphones with Mic
$24.99$14.99 Add to cartFull RGB Light Design Gaming Headset Headphones with Mic
Categories: Electronics, Gaming, Gaming Headsets Tags: Design, Full, Full RGB Light Design Gaming Headset, Full RGB Light Design Gaming Headset Headphones, Full RGB Light Design Gaming Headset Headphones with Mic, Gamer, Gaming, Gaming Headset Headphones, gaming headset wireless, Headphone, Headphones, Headset, Light, Mic, Package, RGB$24.99$14.99 -
Sale!
Wireless BlueTooth Multi-Device Keyboard Mouse Combo
$39.99$19.99 Add to cartWireless BlueTooth Multi-Device Keyboard Mouse Combo
Categories: Electronics, Gaming, Gaming Keyboards, Keyboard Mouse Combos Tags: Combo, Keyboard, keyboard mouse combos, Mouse, MultiDevice, Set, WireKeyboard Mouse Combo, Wireless, Wireless BlueTooth Keyboard Mouse Combo, Wireless BlueTooth Keyboard Mouse Combos, Wireless BlueTooth Multi-Device Keyboard Mouse Combo, Wireless BlueTooth Multi-Device Keyboard Mouse Combos$39.99$19.99 -
Sale!
High Back Leather Executive Adjustable Swivel Gaming Chair with Headrest and Lumbar
$199.99$139.99 Add to cartHigh Back Leather Executive Adjustable Swivel Gaming Chair with Headrest and Lumbar
Categories: Gaming, Gaming Chairs Tags: Adjustable, Chair, computer chairs, Desk, Executive, Gaming, Girl, Headrest, High, High Back Leather Executive Adjustable Swivel Gaming Chair, High Back Leather Executive Adjustable Swivel Gaming Chair with Headrest, High Back Leather Executive Adjustable Swivel Gaming Chair with Headrest and Lumbar, High Back Leather Executive Adjustable Swivel Gaming Chairs, Leather, Lumbar, Office, Racing, Swivel$199.99$139.99 -
Sale!
Professional LED Light Wired Gaming Headphones with Noise Cancelling Microphone
$29.99$19.99 Select optionsProfessional LED Light Wired Gaming Headphones with Noise Cancelling Microphone
SKU: N/A Categories: Electronics, Gaming, Gaming Headsets Tags: Cancelling, Gaming, Gaming Headphones with Noise Cancelling Microphone, gaming headset, Headphones, Headset, LED, Light, Mic, Microphone, Noise, Professional, Professional LED Light Wired Gaming Headphones, Professional LED Light Wired Gaming Headphones with Noise Cancelling Microphone, Wired, Wired Gaming Headphones, Wired Gaming Headphones with Noise Cancelling Microphone$29.99$19.99 -
Sale!
Gaming Desk with LED Lights USB Power Outlets and Charging Ports
$349.99$249.99 Select optionsGaming Desk with LED Lights USB Power Outlets and Charging Ports
SKU: N/A Categories: Computer Desk, Gaming, Gaming Desk Tags: and Charging Ports, Charging, Desk, Desks, Gaming, gaming desk with led lights, Gaming Desks with LED Lights, Home, LED, Lights, Monitor, Office, Outlets, Port, Power, Room, Stand, USB, USB Power Outlets, White, Workstation$349.99$249.99 -
Sale!
Wired Mixed Backlit Anti-Ghosting Gaming Keyboard
$99.99$79.99 Add to cartWired Mixed Backlit Anti-Ghosting Gaming Keyboard
Categories: Electronics, Gaming, Gaming Keyboards Tags: Antighosting, Backlit, Blue, brown, Gaming, Gaming Keyboard, gaming keyboards, gaming keyboards and mouse, Keyboard, Laptop, Switch, Wired, Wired Mixed Backlit Anti-Ghosting Gaming Keyboard, Wired Mixed Backlit Anti-Ghosting Gaming Keyboards, Wired Mixed Backlit Gaming Keyboard$99.99$79.99 -
Sale!
Wireless Bluetooth 5.3 ANC Noise Cancellation Hi-Res Over the Ear Headphones Headset
$119.99$59.99 Add to cartWireless Bluetooth 5.3 ANC Noise Cancellation Hi-Res Over the Ear Headphones Headset
Categories: Electronics, Gaming, Gaming Headsets Tags: 5.3 ANC Noise Cancellation Hi-Res Over the Ear Headphones Headset, ANC, Audio, Bluetooth, Cancellation, Ear, Earphone, gaming headset, Headphones, Headset, Hi-Res Over the Ear Headphones Headset, HiRes, Noise, Wireless, Wireless Bluetooth 5.3 ANC Noise Cancellation Hi-Res Headphones, Wireless Bluetooth 5.3 ANC Noise Cancellation Hi-Res Over the Ear Headphones Headset, Wireless Bluetooth 5.3 ANC Noise Cancellation Hi-Res Over the Ear Headphones Headsets$119.99$59.99 -
Sale!
Wired Sports Gaming Headset Earbuds with Microphone
$19.99$9.99 Select optionsWired Sports Gaming Headset Earbuds with Microphone
SKU: N/A Categories: Gaming, Gaming Headsets Tags: Accessories, Earbud, Earphone, Earphones, Gaming, gaming headset with microphone, Headphones, Headset, IOS, Microphone, Sports, Wired, Wired Sports Gaming Headset Earbuds, Wired Sports Gaming Headset Earbuds with Microphone, Wired Sports Headset Earbuds$19.99$9.99 -
Sale!
150W Universal Multi USB Fast Charger 16 Port MAX Charging Station
$49.99$29.99 Add to cart150W Universal Multi USB Fast Charger 16 Port MAX Charging Station
Categories: Charging Stations, Electronics Tags: 150W, 150W Charging Station, 150W Universal Multi USB Charging Station, 150W Universal Multi USB Fast Charger 16 Port MAX Charging Station, 150W Universal Multi USB Fast Charger 16 Port MAX Charging Stations, 150W Universal Multi USB MAX Charging Station, 16 Port MAX Charging Station, 3.5A, Charger, Charging, Fast, laptop charging stations, Max, Multi, Port, Stand, Station, Universal, USB$49.99$29.99
https://bit.ly/4aa2zaU
Click above link to Learn ORDS (Oracle REST Data Services) for VBCS from scratch
Please like this video and subscribe to our YouTube channel
Kindly support/donate us by clicking on the link below:
http://bit.ly/3IFbPsl
Very useful !