Search results “Api tables oracle”
Converting JSON Data to Relational Data in Oracle 12C
JSON data is nice, but it is difficult to work with directly in Oracle. By converting it to relational data (rows and columns) we can easily work with it. This video demonstates how to convert JSON data to relational data using json_table.
Views: 7378 Pretty Printed
API, API, API - that's all you hear about these days (in addition to microservices, devops, etc.). APIs are critical in the distributed computing world we live in today. And they are needed at every level in the stack. Perhaps most importantly: we need solid, well-designed APIs to our data and business logic - and therein lies the strength and importance of PL/SQL. In this next Office Hours session, Steven Feuerstein and Chris Saxon explore how to use packages to craft excellent APIs. Highlights 01:10 Types of APIs in PL/SQL (Chris presents Steven's slides because Steven is sick) 06:00 Discussions on use of TAPIs 17:52 Packages as building block for APIs 29:13 Exploring overloading 38:28 Tips for high quality APIs 44:31 Overloading and calling functions in SQL 49:21 Closing comments on key value of database APIs With lots of interesting discussions via chat along the way! Link to chat text: https://bit.ly/2UmzbqF AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists. https://asktom.oracle.com/ Oracle Developers portal: https://developer.oracle.com/ Sign up for an Oracle Cloud trial: https://cloud.oracle.com/en_US/tryit
Views: 620 Oracle Developers
Oracle REST Data Services Development with Oracle SQL Developer
Version 4.2 of Oracle SQL Developer makes it very easy to develop and deploy your Oracle REST Data Services for your Oracle Database.
Views: 18342 Jeff Smith
Oracle Sale Order API Part 1
Views: 1190 MK Bug
How to Expose a SQL Database via a REST API in 5 Minutes
***Please watched the updated videos*** https://www.youtube.com/watch?v=yzlTTHtWp10&index=4&list=PLdUnWwhvJspZsEs7mCCl6oHvnAp5ZE0aj https://www.youtube.com/watch?v=_ZpYQC42Fqw&index=3&list=PLdUnWwhvJspZsEs7mCCl6oHvnAp5ZE0aj This video shows how to use the Appery.io API Express visual editor to connect to a SQL database and expose it via a REST API. The SQL component is used to connect and execute a custom SQL query.
Views: 46817 Appery io
Instant APIs for Oracle Databases
Join us to see how DreamFactory’s REST API Automation platform can dramatically speed time-to-value for your enterprise mobilization initiatives both with internal development resources and strategic development partners. We will demonstrate: - Instantly transform a production Oracle database into a REST API Backend for mobile development. - Rapidly assembling robust backends in our API Sandbox by orchestrating DreamFactory Instant APIs with commercial APIs. - Virtualizing backend resources to securely stage partner development and deploy in your production environment with no changes to the app or your production database.
OpenLegacy Platform API Generation From An Oracle Table
See how to use the OpenLegacy IDE to automatically generate a RESTful API from a table in Oracle for all CRUD operations.
Views: 10 Ched Cheatham
API 01 Customers
Oracle EBS R12- How to Load Customers Data through APIs
Views: 2477 Tarek Saleh
Oracle E-Business Suite - AR Cash Receipt Creation- Public API
Oracle E-Business Suite - AR Cash Receipt Creation- Public API
Views: 6214 Lead Technologies
Securing an Oracle Data Services REST API | Blaine Carter
Blaine Carter, Oracle developer advocate for Open Source, demonstrates that it is possible to secure an Oracle Data Services REST API in under two minutes. https://developer.oracle.com/ https://cloud.oracle.com/en_US/tryit
Views: 764 Oracle Developers
Getting to Grips with Interactive Grid API
Perhaps you’ve created an Interactive Grid or two; perhaps you’ve exhausted all the declarative features and you are itching to branch out in to some more of the advanced features you may have heard about. Learning more about the Interactive Grid API is the way to extend your knowledge about how the Interactive Grid works and perform some fancy tricks. Those new to the API will be wondering what you use the API for, and how do you even start to use it? This hands-on presentation is for developers of all abilities; from those new to Interactive Grid to those wishing to explore the more advanced features. My presentation starts small; with only a handful of lines of code to demonstrate how the configuration is used. I’ll then build up gradually from performing basic feature configuration, through validations and then concluding on row based selection processing - and more. Along the way, I’ll also be sharing some standard Interactive Grid code Explorer use.
Views: 2710 Explorer
Oracle E Business Suite Integrated SOA Gateway   PL SQL API as REST Service
Oracle E Business Suite Integrated SOA Gateway PL SQL API as REST Service
Views: 282 Ehab Asaad
Service | Querying using the Service Cloud REST API
This tutorial shows you how to use the REST API to query your Oracle Service Cloud database using syntax similar to SQL.
Service | Using the Oracle Service Cloud REST API in Java
This tutorial applies to Rel 15.8, 15.11 and 16.2. It shows you how to write Java code that uses the OSvC REST API.
Oracle Enterprise Manager 12c Database as a Service RESTful API Overview
This video provides an overview of the Oracle Enterprise Manager 12c Database as a Service (Private Database Cloud) RESTful APIs.
Views: 2083 Adeesh Fulay
How To Call Object Functions using the Custom Object REST API
Calling Object Function scripts using the REST API in Oracle Sales Cloud
Building a Web Service for up and downloading files to Oracle Database
Using just SQL and PL/SQL with Oracle REST Data Services, I'll show you how to build a REST API to POST and GET files to and from your Oracle Database. The files are stored in a table as BLOBs. The sample code and slides can be found here: https://www.thatjeffsmith.com/archive/2018/11/building-a-web-service-for-uploading-and-downloading-files-the-video/ You can skip the intro and get straight to the demo: Demo begins at 4:25
Views: 1666 Jeff Smith
Building a Real-Time Streaming Platform with Oracle, Apache Kafka, and KSQL
One of the main use-cases for Apache Kafka is the building of reliable and flexible data pipelines. Part of Apache Kafka, Kafka Connect enables the integration of data from multiple sources, including Oracle, Hadoop, S3 and Elasticsearch. Building on Kafka's Streams API, KSQL from Confluent enables stream processing and data Transformations using a SQL-like language. This presentation will briefly recap the purpose of Kafka, and then dive into Kafka Connect with practical examples of data pipelines that can be built with it. We'll explore two options for data transformation and processing: Pluggable Single-Message Transformations and the newly-announced KSQL for powerful query-based stream processing. GWEN SHAPIRA Solutions Architect Confluent Gwen is a principal data architect at Confluent helping customers achieve success with their Apache Kafka implementation. She has 15 years of experience working with code and customers to build scalable data architectures, integrating relational and big data technologies. She currently specializes in building real-time reliable data processing pipelines using Apache Kafka. Gwen is an author of “Kafka - the Definitive Guide”, "Hadoop Application Architectures", and a frequent presenter at industry conferences. Gwen is also a committer on the Apache Kafka and Apache Sqoop projects. When Gwen isn't coding or building data pipelines, you can find her pedaling on her bike exploring the roads and trails of California, and beyond.
Views: 6360 Oracle Developers
OPA REST API - What's New in Oracle Policy Automation August 2017 #2
https://theopahub.com Richard Napier explains how to use the REST API for deployments in Visual Basic. He shows simple calls, complex data, authentication and Zip File downloads using simple code examples
REST APIs for Issues Tracking System in Oracle Developer Cloud Service
How to interact with the issue tracking system in Oracle Developer Cloud Service through REST APIs and command line. Related blog - https://blogs.oracle.com/shay/introduction-to-oracle-developer-cloud-service-issue-tracking-rest-interfaces
Views: 449 ShayJDev
What is an API?
What exactly is an API? Finally learn for yourself in this helpful video from MuleSoft, the API experts. https://www.mulesoft.com/platform/api The textbook definition goes something like this: “An application programming interface (API) is a set of routines, protocols, and tools for building software applications. An API expresses a software component in terms of its operations, inputs, outputs, and underlying types. An API defines functionalities that are independent of their respective implementations, which allows definitions and implementations to vary without compromising each other. A good API makes it easier to develop a program by providing all the building blocks. APIs often come in the form of a library that includes specifications for routines, data structures, object classes, and variables. In other cases, notably SOAP and REST services, an API is simply a specification of remote calls exposed to the API consumers. An API specification can take many forms, including an International Standard, such as POSIX, vendor documentation, such as the Microsoft Windows API, or the libraries of a programming language, e.g., the Standard Template Library in C++ or the Java APIs. An API differs from an application binary interface (ABI) in that an API is source code-based while an ABI is a binary interface. For instance POSIX is an API, while the Linux Standard Base provides an ABI”. To speak plainly, an API is the messenger that runs and delivers your request to the provider you’re requesting it from, and then delivers the response back to you. To give you a familiar example, think of an API as a waiter in a restaurant. Imagine you’re sitting at the table with a menu of choices to order from, and the kitchen is the provider who will fulfill your order. What’s missing is the critical link to communicate your order to the kitchen and deliver your food back to your table. That’s where the waiter (or API) comes in. ”AHEM” The waiter takes your order, delivers it to the kitchen, and then delivers the food (or response) back to you. (Hopefully without letting your order crash if designed correctly) Now that we’ve whetted your appetite, let’s apply this to a real API example. In keeping with our theme, let’s book a flight to a culinary capital – Paris. You’re probably familiar with the process of searching for airline flights online. Just like at a restaurant, you have a menu of options to choose from ( a dropdown menu in this case). You choose a departure city and date, a return city and date, cabin class, and other variables (like meal or seating, baggage or pet requests) In order to book your flight, you interact with the airline’s website to access the airline’s database to see if any seats are available on those dates, and what the cost might be based on certain variables. But, what if you are not using the airline’s website, which has direct access to the information? What if you are using online travel service that aggregates information from many different airlines? Just like a human interacts with the airline’s website to get that information, an application interacts with the airline’s API. The API is the interface that, like your helpful waiter, runs and and delivers the data from that online travel service to the airline’s systems over the Internet. It also then takes the airline’s response to your request and delivers right back to the online travel service . And through each step of the process it facilitates that interaction between the travel service and the airline’s systems - from seat selection to payment and booking. So now you can see that it’s APIs that make it possible for us all to use travel sites. They interface with with airlines’ APIs to gather information in order to present options back to us The same goes for all interactions between applications, data and devices - they all have API’s that allow computers to operate them, and that's what ultimately creates connectivity. API’s provide a standard way of accessing any application, data or device whether it is shopping from your phone, or accessing cloud applications at work. So, whenever you think of an API, just think of it as your waiter running back and forth between applications, databases and devices to deliver data and create the connectivity that puts the world at our fingertips. And whenever you think of creating an API, think MuleSoft.
Views: 2404533 MuleSoft Videos
JSON and PL/SQL: A Match Made in Database  Steven Feuerstein Oracle and Darryl Hurley Implestrat
The 2018 CodeTalk Series webinars are co-sponsored by ODTUG and IOUG. Darryl Hurley of Implestrat and Steven Feuerstein will follow up from their popular first JSON CodeTalk session in 2017 with a session focused on features added in Oracle Database 12c. Release 2 to support manipulation of JSON documents in PL/SQL. We'll also take any and all questions on working with JSON via SQL, support for which was added in Release 1. Want to make your UI developers happy? Then get really good at serving up JSON to them via a PL/SQL API! This CodeTalk session will help you get the expertise you need to do this.
Views: 1038 ODTUG
jQuery datatables get data from database table
Link for all dot net and sql server video tutorial playlists https://www.youtube.com/user/kudvenkat/playlists?sort=dd&view=1 Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2015/08/jquery-datatables-get-data-from.html In this video we will discuss how to use database data with jQuery datatables plugin. There are many ways to get data into DataTables. If the data is small you can retrieve all the data at once and the processing (i.e paging, searching, ordering) is done on the client-side. On the other hand if the database data is large, server-side processing can be enabled. With server-side processing enabled, all paging, searching, ordering actions that DataTables performs are handed off to the server. In this video we will discuss retrieving all the data at once. The datatables plugin performs all the processing (i.e paging, searching, ordering etc) on the client-side. We want to retrieve data from the following database table tblEmployee. The database data should then be displayed using jQuery datatables plugin
Views: 169083 kudvenkat
Oracle Database11g tutorials 14 : How to CREATE TABLE using sql developer and command prompt
Oracle Database11g tutorials 14 How to Create table using command prompt and Create table using sql developer Blog Link http://bit.ly/1TkY4Oe Time Line 0:25 Introduction of Tables in Database 1:03 What is Create Table (Introduction of create table) 1:30 Syntax of Create Table 2:08 How to create table using Command Prompt 4:55 How to create table using SQL Developer Links for Oracle Database tutorials 4: database connectivity using SQL developer and command prompt http://youtu.be/wSqoXRlXDUU You can have indepth knowledge about SQL create table here http://www.rebellionrider.com/sql-create-table.html Tool used in this tutorial is command prompt. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com Today in this oracle database tutorial we will see How to CREATE A TABLE. if we have to define a table in layman language then we can say that Tables are just a collection of Rows and Columns but In RDBMS tables are database objects which help in organizing data into ROWS and COLUMNS. We can also say that SQL tables are kind of data structure which are used by database for efficient storage of data. To create a table in our database we use SQL CREATE TABLE command. SQL CREATE TABLE is a type of DATA DEFINITION LANGUAGE also known as DDL. To Create a table in your schema you will require CREATE TABLE system privilege. In our future videos we will see what are system and object privileges and how to grant them to a user. Today for this video we will be using Sample schema HR which already has all the necessary privileges. Ohk Let's see the syntax. CREATE TABLE table name ( column name1 Data-Type(size), column name2 Data-Type(size), ..... ); CREATE TABLE is an oracle reserved word or say an Oracle key word whereas There are 3 different ways of creating a table in Oracle database. Creating a table using Command Line Interface (CLI) in Oracle database For demonstrating how to create table in oracle database using CLI, I'll be using Command prompt. Thats how we create table using command prompt. you can check your table structure by DESCRIBE command for that just write DESC and your table name. Like this Another way of creating a table is by using Graphic user interface (GUI) in Oracle database To demonstrate how to create table using GUI we will use SQL developer. Lets open our SQL developer I am connected to HR schema if you do not know how to create a connection to database using SQL developer please watch my oracle database tutorial 4 that explains database connectivity using SQL developer and command prompt. Link for this video is in the description below. So lets create a table. Creating a table using SQL developer is very easy we do not have to fire any query here. Let's start First of all right click on your connection in which you want to create a table and choose schema browser. This will open a separate schema browser pane or you can expend your connection by clicking this + sign and then right click on table and choose New Table. However I prefer working with schema browser so let's skip to schema browser pane here from the first drop-down list you can choose connection name and in the second drop down list you can choose what database objects you want to work with we want to create a table thus I'll choose table and then click this arrow here and choose option for new table Ok we have created a table wizard first of all give a unique name to your table and add some column as well. For this, click the green plus button. Now we already have a column so give it some name. Also choose a datatype from the list and specify any size you can check this not null column if in case you want to make this a mandatory column you can also specify default value and constraint If you want to make this column a primary key you can click here In my future video i'll show you what are these constraints and different ways of applying them on a column in a table. for this video we will concentrate on create table only so when you are done with all your columns click ok Thats your table You can double click on your table here and can see its structure. Thats it
Views: 194492 Manish Sharma
Oracle to Excel - PL/SQL Excel xlsx export API - ORA_EXCEL
If you need to create Excel xlsx document from Oracle database using only PL/SQL http://www.oraexcel.com is solution for you. With ORA_EXCEL you will be able to: * to export SQL query to sheet * to add up to 1.048.576 rows per sheet * to save worksheet to XLSX file * to save worksheet to BLOB * to set font family, size and color * to make text, bold italic and underline * to set sheet paper size * to set left and right text indent * to add unlimited sheets per document * to apply horizontal and vertical text alignment * to set cell background color * to set column width * to set row height * to set custom format to cells * to set borders with colors and styles * to set sheet margins * to set sheet header and footer text * to set cell comment * to merge cells horizontally and vertically * to wrap text within cell * to appy cells filtering * to rotate text * to hide columns and rows * to set column formulas * to set sheet portrait or landscape * to set cell as hyperlink * to create styles with formatting For more details check on http://www.oraexcel.com
Views: 10437 Zoran Marincic
MCS: 27. Understanding the Storage API's REST API
In understanding the Oracle Mobile Cloud Service's Storage API presents data as a collection of objects, based around REST resources and operations, it’s important for mobile developers to understand what they can actually do, for example, can I call GET on a collection of objects, and if 100s of records are returned does MCS provide any advanced features for paginating through the records? With these questions in mind this episode will investigate the real power behind the Oracle Mobile Cloud Service storage API. Like to learn more about Oracle Mobile Cloud Service? - check out: https://cloud.oracle.com/mobile
Class7 Oracle Workflow  Running Workflow From Back end using API   WF ENGINE
Oracle Workflow Complete Tutorial - 23+ hrs and use bellow link to purchase videos in Udemy @ 500 INR Or 10 $ use bellow link to purchase videos in Udemy @ 500 INR Or 10 $ https://www.udemy.com/oracle-workflow-complete-tutorial-23-hrs/?couponCode=WORKFLOW1_90PERCENT Duration : 23 Hrs + Course Content : Class1-Oracle Workflow Introduction and Resource Document Class2-Oracle Workflow Introduction and workflow components Class3-Oracle Workflow - workflow builder components Class4-oracle Workflow-Prerequisites for developing Ap hold release workflow Class5 Oracle Workflow - Sending AP Invoice Hold notification to Manager Class6-Oracle Workflow -Running Workflow from Front End Class7-Oracle Workflow -Running Workflow From Back end using API - WF_ENGINE Class8-Oracle Workflow - Lookup Types-uses in messages and notification Class9-OracleWorkflow -Item Attributes(Text) - WF_ENGINE.SetItemAttrText Class10-OracleWorkflow-Attributes(Number,Date)-SetItemAttrNumber and SetItemAttrDate Class11-Oracle Workflow -Attributes with lookup - part 1 Class12-Oracle Workflow -attribute with Lookup -Part2 Class13-Oracle Workflow-Attribute with Lookup part2 Class14-Oracle Workflow - Item Attribute (Role) and Expand Role and Global application Role Class15-Oracle Work Flow - Data Base Adhoc Role - CreateAdHocRole,AddUsersToAdHocRole Class16-Oracle Workflow - Database Adhoc Roles tables Class17-Oracle Workflow - Working with WF_DIRECTORY API -adduserstoadhocrole, removeusersfromadhocrole,GetRoleUsers,UserActive Class18-Oracle Workflow - Item Attribute type -FORM Class19-Oracle Workflow - Item Attribute type - URL Class20-Oracle Workflow - Working With HTML Tags Class21-OracleWorkflow-ActualWorkflowDevelopement-From Scratch Class22-Oracle Workflow -Testing of workflow Class23-Oracle Workflow -Functions mandatory parameters Class24-Oracle Workflow - Mandatory parameters modes Class25-Oracle Workflow -Resultout -COMPLETE Class26 - Oracle Workflow - Resultout -DEFERRED Class27-Oracle Workflow - Threshold - WF_ENGINE.THRESHOLD Class28 -Oracle Workflow -Threshold - Part2 Class29-Oracle Workflow - Deferred activity with standard function - DIFFERED THRED Class30-Oracle Workflow - Scheduling workflow for Differed activities Class31-Oracle Workflow - Funcmodes for Funtion Activities Class32-Oracle Workflow -Funcmodes-Run,Validate,Respond Class33-Oracle Workflow - Funmodes(FORWARD and TRANSFER) Class34-oracleworklfow - Funcmodes(QUESTION,ANSWER) Class35-oracleworklfow - Funcmodes(RETRY,SKIP) Class36-oracleworklfow - Funcmodes(TIMEOUT) Class37-oracleworklfow - Funcmodes(TIMEOUT)-PART2 Class38-oracleworklfow - Standard functions - ASSIGN Class39-oracleworklfow - Standard functions - COMPAREDATE Class40-oracleworklfow - Standard functions - COMPARENUMBER class41-Oracleworkflow-Standard Functions -COMPARETEXT Class42-Oracle Workflow - Standard Functions - LOOP COUNTER class43-Oracle workflow -Standard function - AND class44-Oracle workflow -Standard function - OR Class45-oracleworkflow-standardfuntion-waitforflow,contiueflow class46-Oracle Workflow - Standard functions -WAIT class47-Oracle Workflow - Standard Functions - Launch process class48-Oracle Workflow - Standard Functions - WAIT Example requirement class49-Oracle Workflow - Standard Functions - WAIT Example execution Class50-Oracle Workflow - Exception Handing in oracle workflow procedure class51-Oracle Workflow - Document type attribute-PLSQL Document class52-Oracle Workflow - Document type attribute-PLSQL Document example 1 class53-Oracleworkflow-Document type attribute-Dynamic HTML Message body class54-oracleworkflow-Document Type attribute-BLOB and CLOB with single attachment class55-oracleworkflow-Document Type attribute-BLOB and CLOB with multiple attachment class56-Oracle workflow -BLOB and Clob -Working with single file from server class57-Businessevents and subscriptions introduction class58-Businessevents and subscriptions -Raising PLSQL Package class59-Businessevents and subscriptions -custom business events class60-businessevents raising using wf_event.raise class61-Oracleworkflow-subprocess and runnable checkbox class62-OracleWorkflow-Subprocess With Result Type class63-oracleworkflow-Workflow Access Level
MySQL CRUD Operations in Node.js application. In this tutorial, we'll discuss how to implement crud operation insert update delete and view all in node.js with mysql database. Content Discussed : - How to Connect MySQL DB from Node.js - Execute MySQL Query From Node.js - Use of MySQL Store Procedure in Node.js. Best Node.JS Book from Amazon (Affiliate) : ➤ http://geni.us/UvK8B Download Project From : ➤ https://goo.gl/3JKBNM Buy me a Coffee (Channel Support By Donation) ➤ https://goo.gl/bPcyXW Subscribe to this channel ➤ https://goo.gl/RFY5C2 Link to this video ➤ https://youtu.be/4fWWn2Pe2Mk Our Website ➤ http://www.codaffection.com __ $ Purchase for Programmers ➤ Laptop MacBook Air : https://geni.us/fHZzRiB Dell XPS 9570 : https://geni.us/rYB6 ASUS ZenBook 13 : https://geni.us/LDKE Lenovo Ideapad : https://geni.us/Mwvg2 ➤ Keyboard Das Keyboard 4 Professional : https://geni.us/hkAdzi ➤ Mouse VicTsing Mouse : https://geni.us/tjIM48M ➤ Headphones Mpow 059 Bluetooth Headphones: https://geni.us/wAPDmP ______________ ⌘ Social Media Links ________________ Blog : http://www.codaffection.com Facebook : https://www.facebook.com/codaffection Google plus : https://plus.google.com/+codaffection Twitter : https://twitter.com/codaffection Youtube : https://youtube.com/codaffection ______________ ↪ About this Channel ________________ CodAffection - for passionate programmers. This channel is all about teaching and inspiring developers to build applications/ websites in various technologies like Angular, NodeJS, Asp.Net MVC, JavaScript, SQL, React, Python etc. 2 Videos per Week - 12:30 PM UTC On MON and THU ______________ ₪ All Playlist ________________ https://goo.gl/gvjUJ7 : Asp.Net MVC https://goo.gl/ahk39S : Angular 5 https://goo.gl/viJcFs : Node JS https://goo.gl/itVayJ : Web API https://goo.gl/YJPPAH : MEAN Stack https://goo.gl/s1zJxo : C# Tutorial https://goo.gl/GXC2aJ : Asp.Net WebForm https://goo.gl/vHS9Hd : C# WinForm https://goo.gl/MLYS9e : MS SQL https://goo.gl/Ha71kq : Angular 4 https://goo.gl/5Vou7t : Crystal Report https://goo.gl/EPZ69B : Common C# Excercises https://goo.gl/qEWJCs : CG Exercises in C Program
Views: 93390 CodAffection
ASP NET Web API and SQL Server
In this video we will discuss creating ASP.NET Web API service that returns data from a SQL Server database. We will be using this service as the basis for understanding many of the Web API concepts in our upcoming videos. Text version of the video http://csharp-video-tutorials.blogspot.com/2016/09/aspnet-web-api-and-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2016/09/aspnet-web-api-and-sql-server_4.html Dot Net and SQL Server Tutorials https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All ASP.NET Web API Text Articles and Slides http://csharp-video-tutorials.blogspot.com/2016/09/aspnet-web-api-tutorial-for-beginners.html
Views: 371023 kudvenkat
Polymorphic Table Functions in PL/SQL
Polymorphic Table Functions (PTF) - introduced in Oracle Database 18c - are user-defined functions that can be invoked in the FROM clause of a SQL query block. They are capable of processing tables whose row type is not declared at definition time and producing a result table whose row type may or may not be declared at definition time. Polymorphic table functions leverage dynamic SQL capabilities to create powerful and complex custom functions. This is useful for applications demanding an interface with generic extensions which work for arbitrary input tables or queries. In this session, Chris & Steven give an overview how to create PTFs. Highlights include: - 00:35 What are PTFs and why would you use them? - 04:55 An overview of how you create the package and procedure for a PTF - 09:50 An example describe function to add new columns to the output - 11:50 An example fetch_rows procedure to assign new values to columns added by the describe - 18:30 Defining which order you process values from the input table with partition by & order by clauses - 27:40 PTFs rows in batches; why, what this means, and how to overcome this by saving execution state - 30:30 Managing PTF execution state with the dbms_tf.xtore* procedures - 36:25 How to debug PTFs; using the dbms_tf.trace procedure - 40:00 LiveSQL examples of PTF implementations, including: CSV to columns conversion; dynamic pivot - 46:25 User-defined aggregation functions vs PTFs Slides available at https://www.slideshare.net/ChrisSaxon1/polymorphic-table-functions-in-sql AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists. https://asktom.oracle.com/ Oracle Developers portal: https://developer.oracle.com/ Sign up for an Oracle Cloud trial: https://cloud.oracle.com/en_US/tryit
Views: 233 Oracle Developers
API Matic Simplifies Developer Experience Using Oracle Cloud
API Matic creates a code generation engine that extends Oracle API Platform and enhances the developer experience.
Views: 666 Oracle
Connect Excel to Oracle Database
How to connect an Oracle Database to Microsoft Excel. https://www.elance.com/s/edtemb/
Views: 109157 i_marketing
Oracle Apex Create Workspace/Application User (API)
Create Oracle Apex Workspace/Application User from User End. Using Oracle Apex API
Views: 218 MD Khairul Islam
Retrieve Data From Database in ASP.Net Web API
Retrieve Data From Database in ASP.Net Web API
Views: 14522 Go Freelancer
Service | Querying via the Oracle Service Cloud REST API
This tutorial applies to Rel 15.8, 15.11 and 16.2. It shows you how to write ROQL-style queries with the OSvC REST API.
Google MAPs API in Oracle APEX  application
How to use Google Maps API with APEX إضافة خرائط جوجل الي APEX Links: Google Maps Plugin https://1drv.ms/u/s!ArfxK2IlrJkJqFR8O4f8Tk1WDjMx
Views: 3511 Mohamed Saber
Managing API Deployments in Oracle API Platform Cloud Service
Learn how to manage API deployments in Oracle API Platform Cloud Service by redeploying an existing API. ================================= To improve the video quality, click the gear icon and set the Quality to 1080p/720p HD. For more information, see http://www.oracle.com/goto/oll Copyright © 2017 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Introduction to Oracle Open-XDX for Open Data API delivery from SQL to XML
This video is in two five minute sections. The first section provides an executive level introduction to the concepts and overall operational view. This is then followed by a 5 minute demonstration of creating a working Open Data API using the CAM Editor and Open XDX software tools along with Oracle WebLogic web services. For the demonstration we take a sample MySQL database and mock patient prescriptions data and quickly build a working NIEM XML query/response web service. We show how this is done using code-free methods and XML templates to configure the information exchange components. For working code samples, latest downloads and more information please visit the open source project web sites: http://www.verifyxml.org/ and the CAM editor toolkit site: http://www.cameditor.org
Views: 2074 David Webber
How to Import CSV, Excel, TXT  into Oracle Database With Oracle SQL Developer
This question comes up about as frequently as the ‘how do I import data to Oracle Database’ question. It’s pretty simple once you’ve ran through the process a few times. But you may be here because you’ve never ran through the process before.
Views: 24050 Tayyib Oladoja
Spring Boot Quick Start 20 - Implementing Update and Delete
Access the full course here: https://javabrains.io/courses/spring_bootquickstart Let's implement the update and delete operations on resources using the PUT and DELETE methods.
Views: 218077 Java Brains
MCS: 39. End to End Custom API Demo
Having learned the majority of the Oracle Mobile Cloud Service building blocks from previous episodes, rather than diving further into custom APIs, in this episode we're going to take a step back from the detail and remind you of the big picture of what custom API development is all about, demonstrating an end to end custom API example using mobile backends, connectors and node.js. Like to learn more about Oracle Mobile Cloud Service? - check out: https://cloud.oracle.com/mobile
REST API Development Part 5: Create dataBase and tables
Rest API development using JWT authentication in PHP validated API name and param created dataBase and tables created connection class
Views: 4107 learnWebCoding
ORACLE - Créer une clé API pour Google CSE
Comment créer une clé API pour le service Google Custom Search
Views: 111 My Web Intelligence
Get Facebook Profile using restfb Graph API in Java & Oracle ADF
Facebook is most popular social networking sites now a days and influencing our life in all aspect. Facebook gives us option to use it's Graph API to access it's features programmatically, The Graph API is primary way to read and write to facebook social graph using Access Tokens Read Complete Article- http://www.awasthiashish.com/2017/02/get-facebook-profile-detail-using.html
Generate JSON From Relational Data
Held on September 2018 Beda Hammerschmidt shows how JSON can be be generated form relational tables, for instance to modernize a legacy app. Lots of live demos! 1:40 - 4:00 Introduction to use case: using S JSON form a relational app 4:25-5:05 turning rows into JSON using JSON_OBJECT 6:00 - 6:40 JSON_ArrayAgg to turn multiple rows into one JSON array 10:00-10:45 Generating nested JSON structure using subqueries 15:40-16:30 JSON object with embedded JSON 28:35-30:30 Updating relational columns from JSON payload 34:00 -end Q/A AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists. https://asktom.oracle.com/ Oracle Developers portal: https://developer.oracle.com/ Sign up for an Oracle Cloud trial: https://cloud.oracle.com/en_US/tryit music: bensound.com
Views: 1411 Oracle Developers
Using the JAVA API Online Documentation
I introduce the online Java API documentation. The, I demonstrate how to find it, navigate it, and read the pages using the Java String class as an example.
Views: 14184 Craig Piercy
RESTful Application Development in the Oracle Cloud
This presentation describe how you can use Oracle REST Data Services to build RESTful API Services for Oracle Database Cloud Services.