Tag: PL/SQL

•An effective way to leverage emerging technologies to solve some common complex problems which are currently being done manually. A cool way to utilize ML/AI along with Natural Language processing to scan large volumes of text. The primary goal is to identify Keywords and frequency of keywords that relate to diseases using tokenization and Lemmatization models. Opensource Models like FuzzyWuzzy logic and Document Frequency Terms (DFT) were extensively used.
•Our Business Operations at Kaiser captures long texts and unstructured data for each research subject (about 6000 to 10000 of them a year) that they work on. This unstructured data is captured in long text fields and sometimes runs into multiple pages for each subject. We created models to scan through volumes of texts, identify Keywords using python Spacy models, and have the models predict the area of and type of study.
•Tools used: Python, SQL, Oracle Cloud Analytics, Oracle Cloud reporting, and Data Science services from Oracle

Speaker: Pratap Madgula and Tony Schollum, Kaiser Permanente

Presented at Database & Technology Week 2021

Have you had that one SQL statement that you just couldn’t figure out what the Oracle optimizer was thinking? In this session we will take a deep dive into doing a trace and talk about some of the sledgehammer methods to influence the optimizer. You may not find the solution to that one nagging SQL but we will cover how the optimizer frustrated you so. Using these tools along with Oracle’s SQL Plan Management or Profiles you may be able to achieve your goals. Many developers do not understand how to dig into SQL beyond the basic explain plan. Here we will cover the somewhat gory details of going deep inside how the optimizer is making decisions.

Presented at INSYNC 21

Session ID: 100720

Business rules define the requirements of the organization such as what constitutes valid data. A PL/SQL Table API provides a centralized location for the code you write to represent those business rules. This technique has many benefits including better performance, reduced cloud database costs, simplification of user interface code, and more secure applications, and it can be used for any development environment: APEX, ADF, MAF, JET, MAX, VB Studio, Java, JavaScript, or any other framework.

Attend this session to hear about the benefits of this kind of centralized code in more detail as well as some advice about how to incorporate it into your development practices. The presentation focuses on the code components and strategies relevant to using a PL/SQL Table API and the methods used to call it. It also describes and demonstrates methods for automatically generating a large part of the code and shows examples of generated code as well as code that calls the Table API.

Presented at INSYNC 21

Session ID: 100730

Efficient applications require the best performance from all components used to implement the application. If you are using cloud services, tuning of some components is out of your control, but regardless of your use of cloud, your job as an application developer is to ensure that your database code runs as efficiently as possible. It is so much easier to create highly-performant code in the first place than it is to have to fix the code later when you find that it is not performing well.

At this session, you will hear an introduction to (or a review of) a set of PL/SQL coding techniques that help performance. Although these techniques have been known for years, if you are relatively new to the language you may not have been exposed to them. Examples of these techniques include: caching local variables, iteration handling, reducing context switching, datatype selection, and various methods for handling data manipulation. Sample code will illustrate the principles.

Oracle Database 19c is the world's leading relational database, and it gets even better when combined with Oracle SQL Developer.

Everyone knows that SQL Developer is a great tool for creating world-class applications. Not so well known, is that SQL Developer produces some amazing dashboards of the database and application operation.

These dashboards are relevant for both transactional, and data warehouse environments. To view the dashboards, the user account needs to be granted the SELECT_CATALOG_ROLE role.

Quest Forum Digital Event 2020

Oracle now boasts two Low Code development tools for building new applications or extending your Cloud services:  Application Express (APEX) and Visual Builder Cloud Service (VBCS).  How do they measure up? Which is right for your organization?  Do they work together? Which is best, for which use cases?

This session presents APEX and VBCS side by side, using a simple common application to illustrate the talking points. 

Attendees will learn essential information for making an informed decision on which to use – or both. The session covers key features of each for development, deployment, costs, learning curve, usability, and time to master. For those who have not seen APEX or VBCS, or want to see the side by side comparison, here you go. Attendees will gain information to assess which cloud development tool is best for their business needs.

Quest Forum Digital Event 2020

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 an OAuth2 client that can be used to access the service. Next, he will walk through the steps of creating a custom REST API using the REST Data Services wizard. This API will be used to POST image files into a BLOB column in the database and the GET handler will serve the image directly in a web page. You will leave this session with an understanding of how to quickly create REST services on your own database.

Quest Forum Digital Event 2020

ChatOps is an automation model connecting users and tools to processes through messaging applications. It leverages the simplicity and familiarity of chat to empower users to interact directly with applications and databases, retrieving information, and performing work in real-time. Done right, ChatOps is a safe, agile way to minimize or eliminate tedious, repetitive operational tasks and reduce workloads. Virtually anything can be automated or called via ChatOps through simple commands—from self-service password resets, to initiating reporting cycles, to running ad hoc refreshes of development environments—all without granting end users access to a database or application.

This session covers:
-Connecting Oracle databases in the Cloud or on-premises to chat services via REST
-Considerations for building database APIs to handle ChatOps interactions
-Methods for securing communications between the database and application
-Practical examples of ChatOps integrations

Quest Forum Digital Event 2020

Want to learn about Git? If you are thinking about using a Version Control System, this is a session you must attend, also this is a must-have skill for DBAs, Developers and Product Managers! Learn how we implemented this type of technology at CloudDB and how we are been beneficiate by it!

Learn all about Git and Oracle Developer Cloud Services and how to Streamline Team Development and Software Delivery using a SaaS solution.

You will be able to plan and manage: Issue tracking, Team management, Agile Dashboard.

With regards to code: Version management, code review, and track changes.

Plus build and deliver (continuous integration, orchestration, deployment automation) and finally team collaboration (activity stream, wiki, web dashboard).

Quest Forum Digital Event 2020

APEX Interactive Grids have a myriad of customization options, some declarative, and most via JavaScript APIs.  How to stay sane, organized, and consistent with so many options? Standardize!  Delivering clean, uniform, customized interactive grids within a single application, or across many developers, many applications across an organization is less difficult than you think.

We will demonstrate use of a common configuration file and classes to standardize grid features across your applications. Decide upon your grid options, code them once, then include and use everywhere. Better yet, not everyone needs to be a JavaScript expert to implement your standard grid configurations. Attend to learn how to standardize grid customization, and save on sanity.