Home
Search results “Oracle json query” for the 2018
Ask TOM Office Hours: JSON and Oracle Database
 
51:04
In the April 2018 session, Mark Drake (JSON and XML Product Manager) reprises his "Everything Developers Need to Know About Integrating JSON into Oracle Database" presentation. 7:25 SODA - Simple Oracle Document Access 9:30 SODA for REST 13:28 SODA for Java 19:05 Demo: the Movie Ticketing application 29:50 The JSON document store 32:00 Querying JSON with SQL 45:04 Piecewise updates of JSON documents 45:55 The amazing Dataguide feature 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/ https://developer.oracle.com/ https://cloud.oracle.com/en_US/tryit music: bensound.com
Views: 195 Oracle Developers
Oracle Big Data SQL: 1 - Query JSON Data
 
02:54
This video shows you how to create an Oracle external table over JSON format data and query the JSON data via the external table using Oracle Big Data SQL. ================================= 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 © 2018 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.
Ask Tom Office Hours:  JSON Features of Oracle Database
 
53:36
Held on March 13, 2018 Join Mark Drake (product manager) and Beda Hammerschmidt (the developer, himself!) to explore JSON features and capabilities in Oracle Database. 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: 251 Oracle Developers
JSON in the Oracle Database: Auto-Generate Views and Virtual Columns
 
05:18
In part 2 of the JSON Dataguide series, Beda Hammerschmdt, consulting member of technical staff at Oracle, outlines how to auto-genrate views and virtual columns from JSON data. https://developer.oracle.com/ https://cloud.oracle.com/en_US/tryit
Views: 311 Oracle Developers
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: 575 ODTUG
Convert JSON to CREATE TABLE Statements
 
06:29
In this episode I share a query I wrote to automatically parse a JSON object into SQL Server CREATE TABLE statements. Related blog post with example code: https://bertwagner.com/2018/05/22/converting-json-to-sql-server-create-table-statements/ Github: https://github.com/bertwagner/SQLServer/blob/master/JSONtoSQLGenerator.sql Twitter: https://twitter.com/bertwagner
Views: 521 Bert Wagner
Oracle Database as Document Store & SODA QBEs
 
58:14
JSON (JavaScript Object Notation) has become the dominant data exchange format of the 21st century. As of version 12.1, Oracle Database offers powerful, flexible features for storing and querying JSON documents. In this video we show how the Oracle Database can be operated as a document store and documents can be searched by 'Query by Example' expressions, where the query itself is written in JSON. QBE's are provided by the SODA (Simple Oracle Document Access) Api which is available for REST and Java. 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: 104 Oracle Developers
JsonPath Basics Tutorial HD
 
08:22
A tutorial covering the basics of JsonPath. Be sure to select HD in the video settings. http://www.jsonquerytool.com/ How to say JSON: https://www.youtube.com/watch?v=zhVdWQWKRqM
Views: 236 Dathan Ellis
Querying JSON with XSLT, XPath, & XQuery
 
04:19
Learn how XPath, XSLT, and XQuery can be used to query JSON documents or transform JSON data to other formats, such as HTML. Check out the example files featured in the video by downloading a free trial of XMLSpy: https://www.altova.com/xmlspy-xml-editor/download
Views: 1054 Altova
JSON in the Oracle Database: Schema Discovery with the JSON Dataguide
 
05:57
Beda Hammerschmidt, Consulting Member of Technical Staff at Oracle, walks through Schema Discovery with the JSON Dataguide. Learn more: https://developer.oracle.com/ Get started on Oracle Cloud: https://cloud.oracle.com/en_US/tryit
Views: 581 Oracle Developers
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
Continuous Query Notification for the node-oracledb Driver
 
24:41
Held in June 2018 Christopher Jones, Dan McGhan and Anthony Tuininga review some of the latest features of the node-oracledb Node.js driver and answer user's questions, and in particular offer an overview of the new APIs and demonstrate how they work. Native support for Oracle Database Continuous Query Notification (CQN) has landed in the node-oracledb master branch on GitHub. CQN allows an application to register queries with the database so the database can notify the application if the objects in the query or query result change. In this office hours, we'll provide an overview of the new APIs and demonstrate how they work. 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: 106 Oracle Developers
Oracle 18C New Feature Treat AS JSON Document
 
13:15
Oracle 18C New Feature, TREAT AS JSON document
Views: 212 Siva Academy
Calling a Web Service from Oracle Database Without Using Oracle Wallet
 
11:03
following would be the things you would be learning after watching this video Calling a Web Service from Oracle Database Without Using Oracle Wallet. Things Needed to call the Web Service: Batch File Database Directory Database Jobs Database Procedure Utl_file Procedure to Call Clob Table Calling a https web service with basic Authentication without using Oracle Wallet
Views: 234 MrBajajpankaj
How to load text file content into CLOB column using Oracle sql loader
 
05:01
How to load text content into oracle table CLOB column? http://easy-learning-tech.blogspot.in/2018/04/loading-clob-data-into-oracle-table.html
Views: 375 Siva Academy
Oracle JET 4.x - Lesson 2 - Part 4: Data Sources
 
09:15
Exploration of JSON and REST, together with related solutions, such as $getJSON and the Oracle JET Common Model.
Extract Dynamic table data into JSON XML,PNG,CSV,TXT,SQL,MS-Word,Ms-Excel and PDF format🔥
 
11:12
Simple Example to extract Dynamic table data into JSON XML,PNG,CSV,TXT,SQL,MS-Word,Ms-Excel,Ms-Powerpoint and PDF format We Can export HTML tables to the following formats: JSON XML PNG CSV TXT SQL MS-Word Ms-Excel Ms-Powerpoint PDF Want to subscribe? http://youtube.com/tutorialspoint2016 Don't forget to hit the Subscribe & Like button! Learn New Technologies -- Visit Our Channel -- https://www.youtube.com/tutorialspoint2016 1) CodeIgniter Mini Project Tutorial in Hindi/Urdu Using Angular JS & Boostrap 3 : https://goo.gl/FSwsJ4 2) Codeigniter Tutorial for Beginners Step by Step in Hindi : https://goo.gl/bxG6gJ 3) PDO-OOP-PHP-CRUD-with-Bootstrap : https://goo.gl/q1KRTn 4) AngularJS Tutorial for Beginners (For Absolute Beginners ) : https://goo.gl/Hak26N 5) JSON Tutorial for Beginner : https://goo.gl/ryPu35 6) Git and GitHub Training In Hindi : https://goo.gl/HpToSd 7) Java Tutorial For Beginners (Step by Step tutorial) : https://goo.gl/QxJ68x 8) PHP Tutorial for Beginners (For Absolute Beginners) : https://goo.gl/S3urkU 9) OOPS Tutorial for Beginners in PHP : https://goo.gl/k2kJDM 10) Bootstrap Tutorial for Beginners : https://goo.gl/NGFDse 11) Magic Methods in PHP Tutorial : https://goo.gl/BdYLfJ 12) Build a PHP MVC Application : https://goo.gl/yqDCkb 13) Whats new in PHP 7 | (Introduction) : https://goo.gl/rTTKkr 14) CRUD with PHP and MySQLi Tutorial : https://goo.gl/yyjWD7 15) Technology Tips and Tricks : https://goo.gl/MpR952 16) MongoDB Tutorial for Beginners (Hindi) : https://goo.gl/NZXD1u Any questions or suggestions you may have, let me know in the comments below and I will try to reply as soon as I can. You can connect with us in social Media :- Youtube : https://www.youtube.com/tutorialspoint2016 Twitter: https://twitter.com/tutorialspoint2 facebook : https://www.facebook.com/tutorialspoint2016 Instragram : https://www.instagram.com/tutorialspoint2016 Google plus : https://plus.google.com/+TutorialsPoint2016 Blogger : http://tutorialspoint2016.blogspot.in/ Don't forget to hit the Subscribe & Like button!
Views: 649 Technical Suneja
Oracle - report html from sqlplus
 
06:30
Oracle - report html from sqlplus
Views: 173 Santonia
Hibernate - How to use multiple databases Mysql and Oracle
 
06:26
Java by Kiran class offers a wide range of java, selenium & python training in Pune to meet the growing corporate needs. We know individual learning capabilities are different that's why we offer to customize a course for each student. We provide 100% practical and real-time training. Lectures are only taken by Kiran sir only one branch at Karve Nagar Pune [only 2 timings 7.30 morning and evening and weekends] Kiran has worked (total 9 years) in MNC at Bangalore/ Noida/ Pune currently in MNC Pune learn from working professional who is still working so you will not get anything dummy. Only real-time scenarios at our institute whatever new technologies come into the market, we guarantee to train you.
Views: 170 Java By Kiran
Oracle - PL/SQL - Advanced Cursors
 
11:37
Oracle - PL/SQL - Advanced Cursors https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
JSON caveats and triks
 
55:21
Практические советы по применения JSON в Oracle Database. Проблемы и способы их решения. https://www.slideshare.net/AlexanderTokarev4/oracle-json-internals-advanced-edition
Views: 66 Vint
Ask Tom Office Hours: PL/SQL Error Management
 
01:01:44
In our March 2018 session, we explored error management, from raising to handling exceptions. We took a look at SAVE EXCEPTION with FORALL, LOG ERRORS, when it makes sense to "swallow up" an exception - though preferably not with WHEN OTHERS THEN NULL. 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: 261 Oracle Developers
Ask Tom Office Hours: Database Security - Key Features
 
46:06
Held on March 8 2018 The database is at the heart of every application; it is critical to every enterprise that their data be secure. In this session, Russ Lowenthal , Director of Product Management for Oracle Security Products, reviews critical features in Oracle Database 12c (12.2 = 18c) and answers questions about Audit Vault, Key Vault, Row Level Security, Security Assessment Tool, Wallets and Native Network Encryption. 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: 153 Oracle Developers
Power BI Tutorial | Working with JSON data
 
05:07
In this Power BI Tutorial, Adam shows how you can easily work with JSON data within Power BI. Working with JSON data in Power BI Desktop is one of the best-kept secrets of Power BI. LET'S CONNECT! Guy in a Cube -- https://guyinacube.com -- http://twitter.com/guyinacube -- http://www.facebook.com/guyinacube -- Snapchat - guyinacube -- https://www.instagram.com/guyinacube/ ***Gear*** Check out my Tools page - https://guyinacube.com/tools/ #powerbi #guyinacube
Views: 6297 Guy in a Cube
Oracle Big Data SQL: 4 - Query a Kafka Stream of Data
 
04:27
This video shows you how to create and query a kafka stream of current bike activity using Oracle Big Data SQL. ================================= 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 © 2018 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.
Tutorial | Oracle: Database Query Component | Matillion ETL for Amazon Redshift
 
04:59
In this tutorial we will demonstrate setting up and using the database query component with Oracle in Matillion ETL for Amazon Redshift. Start a Free Trial of Matillion ETL for Amazon Redshift: https://www.matillion.com/etl-for-redshift/free-trial/ Learn More: SUPPORT: https://redshiftsupport.matillion.com/customer/portal/articles/2147237?b_id=8915 INTEGRATION: https://www.matillion.com/etl-for-redshift/integrations/oracle/ BLOG: More information: Matillion: https://www.matillion.com/ Matillion ETL for Amazon Redshift: https://www.matillion.com/etl-for-redshift/etl-redshift/ Community: Twitter: https://twitter.com/matillion Blog: https://www.matillion.com/community/ Subscribe: https://www.youtube.com/subscription_center?add_user=MatillionVideos
Views: 254 Matillion
Postgres| PLSQL | Execute Dynamic SQL
 
07:23
This video will help you to run select query dynamically using any number of column, any table with any condition.
Views: 152 Kavtech Learning
Power BI - Read REST API / JSON File / XML File / SOAP (Pagination, OAuth, OData)
 
03:40
Learn how to Read data from REST API, JSON Files or XML Files inside Power BI. ZappySys ODBC Driver supports many advanced settings such as API Pagination to call virtually any API. For more information visit https://zappysys.com/products/odbc-powerpack/ ================================== About ODBC PowerPack ================================== ODBC PowerPack is a collection of high performance ODBC API Drivers for various API data source (i.e. Web API, REST API, JSON, XML, SOAP, OData). With simple and familiar SQL query language you can read/query data from API sources or JSON / XML Files inside your favourite Reporting / ETL tools (i.e. Power BI, Tableau, Qlik, Informatica, Excel, SSIS). Using our API drivers you can consume data from local files or connect to virtually any API data source (internal or cloud API) such as Amazon AWS API, Salesforce API, Google API (i.e. Analytics, AdWords, DoubleClick), Facebook, Twitter, Zendesk, eBay and many more. ================================== Main Features ================================== ODBC 3.8 Compliant high performance drivers to integrate with virtually any API source or Local JSON/XML files. Familiar SQL query engine to read/write data from API source (REST API, Web API, OData API) Support for Basic Authentication, OAuth 1.0 and OAuth 2.0 API (Which means support for services like Office 365, Facebook, Twitter, Google BigQuery, AdWords, Salesforce, MailChimp... ) Support very large JSON / XML files Support for Caching engine to reduce query time Support for retry options (To handle intermittent failures) Support for API pagination options (Many ways to paginate large API response) Supported by most ODBC compliant BI / Reporting / ETL tools (e.g. Power BI, Tableau, Qlik, Informatica, Excel, SSRS, SSIS) Comes with ZappySys Data Gateway Service which allows to use ZappySys Drivers without installing anything on their machine ================================== What's included ================================== - ODBC Driver for JSON Files / REST API - ODBC Driver for XML Files / SOAP API - Data Gateway Service ================================== ZappySys Data Gateway Service (ZSDG) ================================== ZappySys has developed a unique proxy service called ZappySys Data Gateway Service (ZSDG) it can run in cloud or you can install locally. Client application can connect to Data Gateway Service using any Microsoft SQL Server compatible driver (i.e. SQL Server ODBC, OLEDB, ADO.net or JDBC Driver or Linked Server in SQL Server). Data Gateway can be installed on central server where you can have many users who can connect to Data Gateway to use ZappySys Drivers without installing anything on their machine. Data Gateway Service understand TDS Protocol and Client App can be running on any machine or operating system (MacOS, Linux, Windows). ================================== App Integration Scenarios (Reporting / ETL / BI / Analytics Tools) ================================== ZappySys ODBC API Drivers built using ODBC standard which is widely adopted by industry since long time. Which mean majority of BI Tools / Database Engines / ETL Tools already comes will ODBC Driver support. Below is the small list which can take advantage of ZappySys ODBC drivers. If your app doesn't appear in the below list, which means we have not tested or documented use case but as long as your tool support ODBC Standard, our drivers should work fine. Tableau Microsoft Power BI Informatica PowerCenter (Windows Edition) QlikView MS Excel SSIS (SQL Server Integration Services) SSRS (SQL Server Reporting Services) T-SQL (SQL Server Query Language) Visual Studio Oracle OBIEE ================================== Programming Language Support ================================== Most programming languages comes with out of the box support for ODBC. Which means you can use ZappySys ODBC drivers inside your favorite language. Here are few languages which already support ODBC. C# C++ JAVA (using JDBC-ODBC Bridge or using ZappySys Data Gateway via SQL Server JDBC) Python PHP PowerShell T-SQL (Using Linked Server) ================================== Keywords: ================================== Power BI REST API, Read from REST API in Power BI, How to load JSON file in Power BI, How to import JSON to Power BI, JSON to XLSX, JSON to PowerBI, XML to Power BI, XML to XLSX. Import JSON API into PowerBI. Import JSON File into Power BI. Import REST API into PowerBI.
Views: 3165 ZappySys
Oracle 18c - Private temporary tables
 
01:57
New to 18c! Private temporary tables. blog: https://connor-mcdonald.com Not only is your data private to your session, but so is the definition of the table itself.
Views: 1416 Connor McDonald
Introduction to JSON data types in PostgreSQL by Andrew Dunstan
 
37:50
"Introduction to JSON data types in PostgreSQL" covers the following topics: • What is JSON? • How is it available in PostgreSQL? • What's the difference between JSON and JSONB? • Accessing JSON values • Creating JSON from table data • Creating table data from JSON • Crosstabs with JSON • Indexing and JSON • When to use JSON, when to use JSONB, and when neither should be used The session was conducted by Andrew Dunstan, Principal Contributor of JSON functionality to PostgreSQL and Senior Developer & PostgreSQL Committer at 2ndQuadrant Andrew Dunstan has been involved with PostgreSQL since his first contribution in 2003. In 2004 he created the PostgreSQL Build Farm system, which he has maintained ever since, and in 2005 he was made a core committer of the PostgreSQL project. He has contributed many features to PostgreSQL, including the Windows port, dollar quoting, CSV import and export, PL/Perl enhancements, CSV logging, parallel pg_restore and enum extension.
SQL Query Optimization. Why is it so hard to get right?
 
01:39:24
Slides, notes, and donations: https://www.BrentOzar.com/go/dewitt
Views: 1614 Brent Ozar Unlimited
Pandas Tutorial 14: Read Write Data From Database (read_sql, to_sql)
 
12:14
Pandas' read_sql, read_sql_table, read_sql_query methods provide a way to read records in database directly into a dataframe. to_sql on dataframe can be used to write dataframe records into sql table. Using sqlalchemy engine, one can interface easily with mysql, postgres, oracle databases. Code link: https://github.com/codebasics/py/blob/master/pandas/21_sql/pandas_sql.ipynb Website: http://codebasicshub.com/ Facebook: https://www.facebook.com/codebasicshub Twitter: https://twitter.com/codebasicshub Google +: https://plus.google.com/106698781833798756600
Views: 8790 codebasics
Reading Kafka Data from KSQL | Level Up your KSQL by Confluent
 
12:07
Try KSQL: https://confluent.io/ksql | This video shows you how to explore Kafka topic data, create a STREAM or TABLE from a Kafka topic, identify fields, explains metadata like ROWTIME and TIMESTAMP, and covers different formats like Avro, JSON, and Delimited. KSQL is an open source, Apache 2.0 licensed streaming SQL engine that implements continuous, interactive queries against Apache Kafka®. KSQL makes it easy to read, write, and process streaming data in real-time, at scale, using SQL-like semantics. This offers an easy way to express stream processing transformations as an alternative to writing an application in Java or Python. KSQL provides capabilities such as streaming joins, aggregations, event-time windowing, and more! CONNECT Subscribe: http://youtube.com/c/confluent?sub_confirmation=1 Site: http://confluent.io GitHub: https://github.com/confluentinc Facebook: https://facebook.com/confluentinc Twitter: https://twitter.com/confluentinc Linkedin: https://www.linkedin.com/company/confluent Instagram: https://www.instagram.com/confluent_inc ABOUT CONFLUENT Confluent, founded by the creators of Apache Kafka®, enables organizations to harness business value of live data. The Confluent Platform manages the barrage of stream data and makes it available throughout an organization. It provides various industries, from retail, logistics and manufacturing, to financial services and online social networking, a scalable, unified, real-time data pipeline that enables applications ranging from large volume data integration to big data analysis with Hadoop to real-time stream processing. To learn more, please visit http://confluent.io
Views: 2034 Confluent
Tableau Tutorial 4 | Connecting Tableau to JSON file | Getting JSON data in Tableau
 
02:07
Hi guys... in this video I have talked about how you can get JSON data in tableau.
Views: 1173 Data & Tools
JSON Tutorial - 5 - Access JSON Data Using For Loop - Hindi
 
02:33
JSON Playlist : https://www.youtube.com/playlist?list=PLNHw_0qv1zy9KKnGlwLhzJpgM2eKNqHG2 JavaScript Playlist : https://www.youtube.com/watch?v=PDLYL7ci0_Y&list=PLNHw_0qv1zy-gfo9o2ZvbvQGxiBIKEI0t Netbeans IDE Website: https://netbeans.org/downloads/ Java JRE ( Require To Run Netbeans IDE ) : http://www.oracle.com/technetwork/java/javase/downloads/jre8-downloads-2133155.html How To Setup Netbeans IDE( Video ) : https://www.youtube.com/watch?v=fu7rAlfLp4I
Views: 2005 Ganguly Tech
Что нового в MySQL 8.0? / Дмитрий Ленев (Oracle)
 
52:09
РИТ++ 2017, Backend Conf Зал Сан-Паулу, 6 июня, 16:00 Тезисы: http://backendconf.ru/2017/abstracts/2801.html 8.0 - это следующая крупная версия СУБД MySQL Server, которая на данный момент находится в активной разработке. Цель данного доклада - познакомить слушателей с новыми возможностями и улучшениями производительности,которые реализованы в этой версии. В частности, мы поговорим о: - новом словаре данных, связанных с ним изменениях в INFORMATION_SCHEMA, а также поддержке атомарного DDL; - новых возможностях в выполнении запросов - поддержке Common Table Expressions и Window функций, "невидимых" и descending индексах; - улучшениях в поддержке Unicode; - возможностях более гибкой работы с блокировками в запросах (SKIP LOCKED/NOWAIT); - ролях и других изменениях в системе привилегий; - улучшениях в репликации.
Views: 1122 HighLoad Channel
JDBC Next: A New Asynchronous API for Connecting to a Database
 
50:24
Rajesh Tiwary Principal Member Technical Staff - JDBC Oracle Saurabh Verma Principal Member of Technical Staff - JDBC Oracle Kuassi Mensah Director of Product Management - JDBC Oracle Reactive Applications require non-blocking database access. The existing JDBC API leads to blocked threads, threads scheduling, and contention. For high throughput and large-scale deployment, the Java community needs a standard asynchronous API for database access where user threads never block. This session presents an advance look at a possible new Java standard for accessing SQL databases. This new API is completely non-blocking. It is not intended to be an extension to, or a replacement for, JDBC but, rather, an entirely separate API that provides completely non-blocking access to the same databases as JDBC. This session examines the API, its execution model, code samples, a demo of a prototype, and the next steps.
Views: 1107 Oracle Developers
Ask TOM Office Hours: Code Classification for SmartDB
 
54:15
Held on April 17 2018 Toon Koppelaars presents his thoughts on how best to classify the types of code that should reside inside the database. Along the way, he offers recommendations for a sound database design, and much more. 05:44 Recommendations for a sound database design 12:00 Data Integrity Constraints 16:11 Data Logic Code 17:30 Classifications: Query-only Business Logic, Transaction Business Logic, Data Logic 21:21 Avoiding a big pile of PL/SQL code: separate schemas and more 24:32 Vertically materialize APIs per page 25:43 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/ https://developer.oracle.com/ https://cloud.oracle.com/en_US/tryit music: bensound.com
Views: 161 Oracle Developers
SimpleOpinions -  Data Tools Query Tutorial - Semalt
 
01:59
Visit us - https://semalt.com/?ref=y #tools, #query, #tutorial, #data, #data_and, #tutorial_follow, #piechart_data, #jorchelcerdito_tutorial, #android_tools, #sorteiotirolplus_data, #data_in, #data_transfer, #lyrics_tutorial, #tutorial_si data query tools ember data query tools data warehousing query tools nass data query tools data query tools list silverstripe data query tools ca data query tools big data query tools sharepoint data query tools morganmarkets data query tools jpm data query tools data mining query tools attribute data query tools data base query tools comtrade data query tools jpmm data query tools sql data query tools data warehouse query tools mrip data query tools query tools data warehousing usace data query tools jpmorgan data query tools joomla data query tools spsite data query tools imf data query tools sas data query tools linq data query tools core data query tutorial excel data query tutorial cacti data query tutorial jp morgan data query tools query tools in data warehousing data mining versus query tools query tools for data warehouse data mining vs query tools query tools in data mining data query and reporting tools load data sql query tools data tools platform query builder mongodb query tools in data excel web data query tools what are data query tools fermi lat data query tools mdx query ssis data tools lotus 123 data query tools morgan markets data query tools sql query data cleansing tools gis spatial data query tools re cache data query tools cacti recache data query tools crm tools data query designer data warehousing tools tutorial data tools bootstrap tutorial data tools platform tutorial eclipse data tools tutorial sql data tools tutorial tools tamper data tutorial data tools smartgwt tutorial event data xml query tutorial form data query string tutorial load data mysql query tutorial mdx query tutorial pentaho data load data sql query tutorial custom query spring data tutorial entity data model query tutorial data modeling tutorial sql query iphone core data query tutorial has data access query tutorial merge data access query tutorial query data from hadoop tutorial xcode query core data tutorial query data report vb6 tutorial data query editor sharepoint tutorial data mining query language tutorial data warehouse tutorial sql query native query spring data tutorial query data with javascript tutorial query json data jquery tutorial query tools data modeling tools mongo db query data tools platform sql query builder data warehouse query and reporting tools sharepoint 2010 site data query tools sharepoint 2013 site data query tools sharepoint 2007 site data query tools query tools in data warehousing ppt denormalize data in sql query tools data mining vs query tools ppt data query tools for oracle databases data mining vs query tools pdf995 pivot data in sql query tools query tools used in data mining jp morgan markets data query tools data mining versus query tools ppt ad hoc query tools in data reporting query tools applications data warehousing crm tools o data query designer specify data type sql query tools sql server data tools query designer reporting query tools applications data warehouse update data type sql query tools sql database query tools in data data mining vs query tools pdf split data in sql query tools difference between data mining query tools data range in sql query tools data format in sql query tools sql server data tools mdx query unsupported data type sql query tools admin tools admin query string tutorial data query query data tutorial query query tutorial data modeling tools linux tutorial data warehousing tools tutorial hijab data visualization tools hadoop tutorial data warehousing tools tutorial photoshop data governance tools informatica tutorial data warehousing tools tutorial jilbab data visualization tools wpf tutorial eclipse data tools postgresql tutorial data warehouse tools informatica tutorial data statistics tools matlab tutorial data warehousing tools tutorial shawl data analytics tools hadoop tutorial data cleansing tools informatica tutorial data visualization tools jquery tutorial big data tools splunk tutorial tutorial ibm data studio tools data visualization tools linux tutorial data mining tools weka tutorial data profiling tools informatica tutorial data visualization tools python tutorial data tools platform tutorial game big data sql tools tutorial big data tools hadoop tutorial data management tools arcgis tutorial
Views: 4 vamshi krishna
JSON Data Modeling for RDBMS Users
 
18:23
JSON data modeling is a vital part of using a document database like Couchbase. There are two key approaches to modeling relationships.
Views: 197 Matthew Groves
A1 injection Tutorial on Sqli, Command and JSON injection
 
04:18
Injection flaws are very prevalent, particularly in legacy code. Injection vulnerabilities are often found in SQL, LDAP, XPath, or NoSQL queries, OS commands, XML parsers, SMTP headers, expression languages, and ORM queries. Injection flaws are easy to discover when examining code. Scanners and fuzzers can help attackers find injection flaws.
Views: 28 shivanjali khare
JSON Validation Support
 
06:06
This demonstration shows several techniques and features for working with JSON documents in a more productive way.
Views: 589 oxygenxml
Uipath - Oracle Analytics Cloud Service Job Automation!
 
01:31
Get all essbase jobs from cloud OACS and write to excel file using rest apis and Uipath studio!
Views: 260 yannis vossos
Editable Tables in Oracle Visual Builder Cloud Service
 
12:40
How to define a table in your UI that lets you edit the values of the fields in each row and save them. More info here - https://blogs.oracle.com/vbcs/creating-editable-tables-in-oracle-visual-builder-cloud-service
Views: 252 ShayJDev
Spark SQL with JSON data
 
02:37
In this video you will learn how to read a JSON dataset, create Spark SQL dataframe and then analyse the data. | Developer Bytes - Like and Share this Video, Subscribe and Support us . ****************************************************************** JOIN Developer Bytes & Support us : YouTube : https://www.youtube.com/channel/UCX4nwbrO1_wG76n2pXgfeNw/?sub_confirmation=1 Facebook: https://www.facebook.com/developer.bytes.tech
Views: 382 Developer Bytes
Office Hours for DBA - April 2018
 
59:47
in this session, Connor McDonald covers a variety of questions challenging the modern DBA: - Getting support for MySQL - Index statistics in the dictionary - Changes to regular expressions in 12c - Understanding queries with unusable indexes - Data change notification to applications https://connor-mcdonald.com https://asktom.oracle.com https://developer.oracle.com/ https://cloud.oracle.com/en_US/tryit music: bensound.com
Views: 244 Oracle Developers