Home
Search results “Api oracle pl sql”
Calling Web Services from Oracle PLSQL
 
06:01
Link to the blog: https://slobaexpert.wordpress.com/2015/02/05/calling-web-services-from-oracle-plsql/
Views: 18590 Swadhin Ray
Oracle E-Business Suite Integrated SOA Gateway - PL/SQL API as REST Service
 
08:27
Oracle E-Business Suite Integrated SOA Gateway Release 12.2.4 Tutorial: Publish PL/SQL API as REST Service Copyright © 2015 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.
Oracle REST Data Services Development with Oracle SQL Developer
 
16:00
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: 13910 Jeff Smith
Oracle E Business Suite Integrated SOA Gateway   PL SQL API as REST Service
 
08:27
Oracle E Business Suite Integrated SOA Gateway PL SQL API as REST Service
Views: 76 Ehab Asaad
Session 2 - How to handle PL/SQL API changes
 
06:40
ADF Talk about regeneration of existing ApplicationModules based on PL/SQL Package.
Views: 1835 ADFTalk
Building a Web Service for up and downloading files to Oracle Database
 
25:11
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: 1000 Jeff Smith
Oracle to Excel - PL/SQL Excel xlsx export API - ORA_EXCEL
 
00:48
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: 10263 Zoran Marincic
IO8: Sending mail from PL/SQL with UTL_MAIL
 
05:00
Learn how to use the UTL_MAIL package to send mail from within your PL/SQL program. Download my demo.zip from v.gd/sfdemo to access and run all referenced scripts. This video was taken from PLSQLChannel.com, originally recorded before Steven Feuerstein re-joined Oracle in March 2014. ======================================== Practically Perfect PL/SQL with Steven Feuerstein Copyright © 2015 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.
How to use AOP PL/SQL API
 
02:12
How to use AOP PL/SQL API
From Oracle DB to RESTful Web Services
 
15:23
Via REST, you can create APIs that can be accessed and consumed by external applications. Each API provides access to a subset of data in your database. In this screencast, using an OracleDB, you are shown exactly how to do that.
Views: 25940 NetBeansVideos
Integrate Custom Applications with REST APIs
 
05:29
Learn how to use REST APIs to integrate custom applications with Oracle Identity Cloud Service. For more information, please see the following tutorials on the Oracle Learning Library http://www.oracle.com/goto/oll: - First REST API Call - Managing Users via REST APIs - Managing Groups via REST APIs ================================= 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 and http://docs.oracle.com 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.
How to Expose a SQL Database via a REST API in 5 Minutes
 
04:47
***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: 38020 Appery io
Oracle API Gateway Demonstration
 
22:11
Qubit's demonstration of using OAG with a custom plugin to perform Geo-IP filtering of an API. This is similar to the material presented in the webcast however contains more technical detail.
Views: 20295 Qubit Consulting
API Management Part 1 of 2.  Oracle API Cloud Services Platform
 
02:14
This is the second video of a series to show case the usage of the brand new Oracle API Platform CS. This is part one of API Management
Views: 993 Rolando Carrasco
JSON and PL/SQL: A Match Made in Database  Steven Feuerstein Oracle and Darryl Hurley Implestrat
 
56:52
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: 783 ODTUG
API Builder
 
02:20
PLSQL API Builder for Oracle applications
Views: 1200 David Drewette
Oracle DBA Justin - How to create a basic PL/SQL procedure
 
12:21
How to create a basic PL/SQL procedure
Views: 30586 jbleistein11
Oracle - Pl/SQL - Introduction
 
06:12
Oracle - Pl/SQL - Introduction https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
The Most Complete Lifecycle Management for APIs
 
17:00
API design and deployment is made easy with Oracle and Apiary in the cloud. See this in action with a demo on creating an API for finding a new car.
Views: 909 Oracle
Implementing APIs in Oracle API Platform Cloud Service
 
02:12
Learn how to implement APIs in Oracle API Platform Cloud Service by adding the API Request and Service Request endpoints to the managed 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.
JSON In the Oracle Database 12c Release 1 (12.1.0.2)
 
04:46
A really quick look at the ability to store JSON in the Oracle Database 12c Release 1 (12.1.0.2) and accessing it using Python and the Oracle_CX open source driver. You can find the Oracle documentation on it here http://docs.oracle.com/database/121/ADXDB/json.htm#ADXDB6246
Views: 8435 Dominic Giles
Membuat Halaman Registrasi User dengan APEX API dan PL/SQL Dynamic Cotent Region
 
10:12
APEX API (Application Program Interface) merupakan perintah khusus yang dimiliki Oracle APEX untuk menggantikan fungsi-fungsi yang ada. Salah satu API yang ada adalah APEX_ITEM. APEX_ITEM merupakan package yang memiliki function dan procedure, salah satun function yang ada adalan APEX_ITEM. PL/SQL Dynamic Content merupakan sebuah region yang dapat digunakan pada Oracle APEX. pada region ini developer dapat menempatkan kode HTML, javascript, css, sql dan PL/SQL secara bersamaan di region tersebut.
Views: 460 Boby Siswanto
Converting JSON Data to Relational Data in Oracle 12C
 
08:26
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: 5328 Pretty Printed
Oracle plsql xml generation DBMS_XMLGEN part 2.mp4
 
17:49
Oracle plsql dbms_xmlgen xml generation
Views: 953 Sridhar Raghavan
Oracle pl sql tutorial - %TYPE and %ROWTYPE attributes #26
 
05:16
Lesson 26 END tutorial Subscrise for my thx !! all
Views: 7093 Dol1nitary
MNG2: The Optimizing Compiler of Oracle PL/SQL (PL/SQL Channel)
 
28:43
In Oracle Database 10g and higher, the PL/SQL compiler will automatically optimize your code to make it run faster. This lesson explores how the optimizer works, how it can affect your code, and how you can set the optimization level. This video was taken from PLSQLChannel.com, originally recorded before Steven Feuerstein re-joined Oracle in March 2014. ======================================== Practically Perfect PL/SQL with Steven Feuerstein Copyright © 2015 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.
ORDS and the New SQL/JSON Database Functions - Part 1
 
15:10
Shows how to use the new SQL/JSON functions available in Oracle Database 12c to insert the data in nested JSON objects into multiple tables in the Oracle database as one transaction using REST and Oracle REST Data Services (ORDS). For more detail also see blog post https://blogs.oracle.com/newgendbaccess/entry/inserting_nested_json_objects_into
WebADI  - Various Interface Fields-Concurrent Program - PLSQL Practice
 
01:02:14
This video describe complete implementation of WebADI various interface columns, readonly columns , terms and conditions , Calling concurrent program through plsql API with parameters and various business scenario handling webadi
PL/SQL Tutorial 1 (Oracle): Importing data from an Excel Spreadsheet
 
03:43
PL/SQL Tutorial 1 (Oracle): Importing data from an Excel Spreadsheet In this tutorial I show you how to import data from excel into a table in Oracle PL/SQL Developer. Source Code: https://github.com/mitchtabian/SQL-tutorials Subscribe to my Blog and YouTube channel to get notifications when new FREE coding tutorials are posted! Blog: http://www.codingwithmitch.com/
Views: 11882 CodingWithMitch
Quickstart for Node.js and Oracle Database
 
08:39
This quickstart video shows the simple steps for installing and running a Node.js application that accesses Oracle Database using the node-oracledb add-on. Ask questions at https://github.com/oracle/node-oracledb/issues Useful Resources: npm repository: https://www.npmjs.com/package/oracledb Installation instructions: https://oracle.github.io/node-oracledb/INSTALL.html Documentation: https://oracle.github.io/node-oracledb/doc/api.html Examples: https://github.com/oracle/node-oracledb/tree/master/examples Blog: https://blogs.oracle.com/opal/ Twitter: https://twitter.com/ghrd
JavaScript Fundamentals for Oracle APEX & PLSQL Developers
 
06:55
Oracle APEX & PL/SQL developers! Learn JavaScript development. Start with this tutorial on how javascript fits into web development and how to declare variables and arrays. Attend class with instructor Tyson Jouglet http://skillbuilders.com/javascript-training-for-oracle-apex .
Views: 3311 SkillBuilders
How to Export Data To CSV from Oracle Database using PLSQL script.
 
19:44
How to Export Data To CSV from Oracle Database using PLSQL script. A simple oracle tutorial to get idea about exporting data from oracle database using plsql.
Views: 21352 Subhroneel Ganguly
OAF How to perform DML Operations Using PLSQL Procedure
 
45:22
1.How to invoke PLSQL procedure using callableStatement API in OAF
Views: 2900 Lead Technologies
Creating OAuth2 Protected RESTful Web Services with ORDS and APEX
 
46:28
UKOUG APEX SIG 10th presentation by Colin Archer This demonstration will give an overview of how to create RESTful web services using the ORDS PL/SQL API package, how to protect them using OAuth2.0, and how to use them within an APEX application. In the first part of the demonstration, I will walk you through the steps involved in creating and testing some simple ‘GET’ and ‘POST’ method web services. I will then demonstrate how to protect the web services using roles and privileges, and how grant access using OAuth2.0 and client credentials. In the second part of the demonstration, I will show you how to use the web services inside an APEX application, including the use of client credentials to access ones that have been protected with OAuth2.0
Views: 4113 Explorer
Automate Oracle Cloud Services with Oracle API Catalog
 
03:11
Learn how the Oracle API Catalog Service's Try It feature helps you automate your cloud service tasks. ================================= 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 and http://docs.oracle.com 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
 
10:42
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: 2055 David Webber
Working with PL-SQL in Oracle SQL Developer v4.0
 
10:53
How to navigate your PL-SQL, a few options to consider, and working with execution results of your programs in Oracle SQL Developer version 4.0.
Views: 28790 Jeff Smith
RESTful Application Development in the Oracle Cloud
 
31:00
This presentation describe how you can use Oracle REST Data Services to build RESTful API Services for Oracle Database Cloud Services.
Oracle APEX - How to send SMS from oracle apex to Mobile
 
05:03
Today I read an article on Grant Rolands blog about sending a SMS from Oracle Forms through a Web-Service. I thought it would be nice to have the same in APEX and PL/SQL, too. For example if you have a system failure or get a new order in your shop… Grant is using a Web-Service provided by Esendex, but I’m sure there are others service providers available too. First I thought using the offered Web-Service and create a PL/SQL wrapper for it our use the Web-Service feature of APEX. But I decided to go with the simple POST version which is also offered by them. Because why invoke all the Java stuff when there is also a simple version available. The APEX web-service couldn’t be used, because then you would not be able to call it from PL/SQL. The code is quite straight forward. Get a free account, replace the constant values in the example procedure and you are ready to go! Note: If you have a proxy then you have to uncomment the proxy line. There is also a secure version available which uses HTTPS, but that requires a wallet, … and I just wanted to demonstrate that it works. The error handling of the procedure could also be improved, but hey, it’s just a demonstration. Thanks so much for watching this video If you are the first one in my channel Please subscribe to the channel If you have any comments on this video, then definitely give it in the comment box Facebook page Link: https://www.facebook.com/orclapexbd/ Blog Link: http://orclapexbd.blogspot.com/
Views: 2682 Oracle Apex
Bryn Llewellyn - Guarding your data behind a PL/SQL API—the detail
 
51:00
I’ve taken my “Why Use PL/SQL?” talk around the conference circuit and published the companion whitepaper. It was a high-level account that appealed to common sense and to abstract principles of computer science. This session takes the opposite approach. It tells you in practical detail how to ensure that the hard shell of the database’s PL/SQL API is impenetrable by addressing code organization and security. It advocates a four-schema model (data, code implementation, API, and connect) using only invokers rights units together with code-based access control to honor the principle of least privilege. The approach is refined b explicit control of “inherit privileges, the “accessible by” whitelist, and secure error handling. And scrupulous care is taken to ensure that the privileges needed for installation and patching are not available at run-time. I will present real code and demonstrations.
Views: 131 Riga Dev Days
Oracle APEX - Complete Guide to Dynamic Actions
 
55:41
Dynamic Actions are extremely powerful and flexible for the APEX developer and by understanding their use and how to customise, repurpose and extend; you can quickly master them. Knowing more about Dynamic Actions enables the PL/SQL developer to build functionally rich APEX applications without being a semi-pro at JavaScript.
Views: 34676 Explorer
Oracle using SQL Developer Data Pump for export and import
 
04:50
Using Oracle SQL Developer to export and import data via the data pump facilities.
Views: 66989 thehighway360
Using SQL in Oracle Database 12c to Query Twitter Data stored as JSON
 
27:37
You can use SQL to query JSON as a relational object in Database 12c. This video demonstrates this using Twitter data gathered using their public API.
HOW TO SEND EMAIL USING ORACLE APEX
 
07:10
HOW TO SEND EMAIL USING PL/SQL PROGRAMMING LANGUAGE ,USE OF PROCEDURE ,ON ORACLE APEX
Views: 3326 Divyansh Srivastava
37. Design - Architecting for PL-SQL Integration - ADF BC PL-SQL Integration
 
15:37
The author's recommendation: the ADF Architecture TV channel is a training course to extend customers' knowledge in ADF, it is not a marketing or promotional exercise from Oracle Corporation. If you've arrived on this episode by Googling in, please make sure to look at all of the content on the TV channel rather than taking this episode as a standalone topic. This episode: Frank Nimphius during this episode of the ADF Architecture TV series explains how to build ADF Business Components custom implementation classes to use the PL-SQL table API with ADF BC models. It also covers a generic - highly reusable - approach for developers looking for integration with lots of PL-SQL procedures for DML. Like to know more? Check out: Watch the previous episode: - Design - Architecting for PL-SQL Integration - Motivation and Design Consideration - http://youtu.be/tfQgdLu74EQ Watch the next episode: - Design - Architecting for PL-SQL Integration - PL-SQL Read Access - http://youtu.be/-tFe0giBgE0 Subscribe to the channel: - http://bit.ly/adftvsub See the episode index: - ADF Architecture Square - http://bit.ly/adfarchsquare
Views: 1807 ADF Architecture TV
Oracle REST Data Services Product Walk-through and Demonstration
 
59:52
A quick overview of REST, then an introduction of Oracle REST Data Services (ORDS) and how it brings a RESTful access to your Oracle Database.
Views: 7228 Jeff Smith
Using RESTful Web Services On Custom Object Records
 
05:54
Using RESTful Web Services On Custom Object Records in Oracle Sales Cloud
Documenting Your APIs in Oracle API Platform Cloud Service
 
02:55
Learn how to add documentation to managed APIs in Oracle API Platform Cloud Service. ================================= 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.
Submitting Concurrent Program through plsql package fnd_request in oracle apps( No Audio)
 
09:01
This is request set It can be used in interface programs.. To do interface programs.. we need to run 1) sql loader program 2) interface program But The requirement is Client wants to run A single program.. In that he need 1)sql loader program and 2)interface program so we need to add sql loader program inside interface program using fnd_request package Create or replace package xxtest as procedure main(errbuf out varchar2,retcode out number); end; / Create or replace Package body XXTEST as V_REQUEST_ID NUMBER; v_phase varchar2(100); v_status varchar2(100); v_dev_phase varchar2(100); v_dev_status varchar2(100); v_message varchar2(100); V_wait_for_request boolean; procedure main(errbuf out varchar2,retcode out number) as BEGIN fnd_global.apps_initialize(fnd_global.user_id ,fnd_global.resp_id ,fnd_global.resp_appl_id); mo_global.init('PO'); --=====================================================================-- --== Standard Program Submition ==-- --=====================================================================-- V_REQUEST_ID := FND_REQUEST.SUBMIT_REQUEST ( 'PO', 'XXKRAXML program',-- PROGRAM NAME null, '06-JAN-2015',-- YOU MAY USE SYSDATE FALSE ); FND_FILE.PUT_LINE(FND_FILE.LOG,'REQUEST ID.......'||V_REQUEST_ID); COMMIT; --=====================================================================-- --== Concurrent Program waiting ==-- --=====================================================================-- V_wait_for_request :=FND_CONCURRENT.wait_for_request(V_REQUEST_ID, 10, 0, v_phase, v_status, v_dev_phase, v_dev_status, v_message ); COMMIT; DBMS_OUTPUT.PUT_LINE('REQUEST ID.......'||V_REQUEST_ID); DBMS_OUTPUT.PUT_LINE('Phase.......'||v_phase); DBMS_OUTPUT.PUT_LINE('Status.......'||v_status); DBMS_OUTPUT.PUT_LINE('Dev Status.......'||v_dev_phase); DBMS_OUTPUT.PUT_LINE('Dev Status.......'||v_dev_status); DBMS_OUTPUT.PUT_LINE('Message.......'||v_message); END; end; /
Views: 4273 kranti kumar
API Builder
 
03:20
Oracle Unit Testing now presents the new Oracle API Builder. This PLSQL utility will generate all your Select, Insert, Update and Delete code for ALL your tables in your schema saving you potentially hundreds of hours of work (or contractor time!). It can also contribute to your Daily Build Architecture since it can be rerun again and again as your table structure changes.
Views: 1602 webcomsystemsbiz