Tag: PL/SQL

Quest Forum Digital Event 2020

This presentation addresses the essential questions regarding JSON and the Oracle Database:
-How to load JSON documents into the database?
-Storing JSON documents or spreading the contents into relational tables?
-How do I create JSON files from data?
-How to query to large volumes of JSON documents fast and efficient?
-How do I publish JSON documents from the Database?

All those questions will be answered using examples and demos. This presentation contains detailed live demos. All demos will be made available for download.

Quest Forum Digital Event 2020

DBAs spend time dealing with maintenance, security, and outage issues with little time for innovation. Self-driving, self-securing, and self-repairing Autonomous Databases free data professionals to leverage their domain knowledge and data skills to extract more value from data. Oracle Machine Learning, part of Autonomous Database, “moves the algorithms to the data” for in-database processing of machine learning algorithms that eliminate data movement. Now, the entire machine learning process:  problem statement, data understanding and preparation, model building and evaluation, model apply and model deployment runs inside the Oracle Database.   Database developers perform many supporting tasks today, typically 80% of the work, but refer to them as ETL, data wrangling, data transformations, and productionizing scripts.   Come learn how ADW, ATP, and Oracle Machine Learning makes it easy for you to easily expand your valuable data skills and become “data scientists” in just 6 weeks!

Quest Forum Digital Event 2020

You've got lots of languages to choose from when it comes to building apps. You could do "ground up" - 100% hand-coded - yet that often leads to over-engineered solutions completed behind schedule, over budget, or both. But have you heard of low-code tools? You're still going to do some coding, but these products will help you deliver your app faster and cheaper, with more consistency and built-in security. Attend this session to learn about the low-code approach and related tools. You might discover a fast track to delivering all the applications your users are clamoring for.

Access all 11 Quest Experience Week PeopleSoft session recordings. Purchase now.

Access all 11 Quest Experience Week PeopleSoft session recordings. Purchase now.

Samuel Pesse, an Oracle ACE, wrote in his blog about how to self-test your database. The content below is a republishing of his words.

Nov 13 @  12:30pm

Anyone who’s familiar with tuning SQL knows that you need to get the execution plan for a query. But once you’ve got an execution plan, what do you do with it? Everyone understands that an execution plan is important for diagnosing, but almost no one knows how to answer questions like “which step in the…

Original Broadcast: June 8, 2017 Version management of the PL/SQL source code has always been challenging. Database programmers lack the tools and utilities that make version control easy for developers who code with file based programming languages such as Java and JavaScript. In fact, this is one of the primary reasons why large software teams…

In this session, Blaine Carter will demonstrate how to REST enable your database using Oracle Rest Data Services (ORDS). He will demonstrate how to use SQL Developer to create and deploy REST services in ORDS. First Blaine will "Auto Rest" enable a table and a PL/SQL package.  Then he will secure the API and create…