SQL Developer Web

Now that we have a deep understanding of the various Oracle Cloud Infrastructure (OCI) Always Free resources and created some, let us now explore how we can create web applications to make the best use of them. For Part 4 of this book, please create the f

  • PDF / 1,604,397 Bytes
  • 25 Pages / 504 x 720 pts Page_size
  • 46 Downloads / 200 Views

DOWNLOAD

REPORT


SQL Developer Web Now that we have a deep understanding of the various Oracle Cloud Infrastructure (OCI) Always Free resources and created some, let us now explore how we can create web applications to make the best use of them. For Part 4 of this book, please create the following OCI resources: 1. Autonomous Database for Transaction Processing (ATP) 2. Compute Instance running Oracle Autonomous Linux 7.x 3. Virtual Cloud Network (VCN) to support the Compute Instance All Autonomous Databases (ADBs) come with several tools preinstalled. These include SQL Developer Web (SQLDEV Web), Oracle Application Express (APEX), and Oracle Machine Learning (OML) Notebooks. Most Oracle Database developers are accustomed to using Oracle SQL Developer (SQLDEV), a desktop application that you can download from Oracle’s website (www.oracle.com/tools/downloads/sqldev-downloads.html) and use for free! This application was built with Java and will run on all major operating systems: Microsoft Windows, macOS, and Linux. SQLDEV is a comprehensive toolkit. The application (Figure 10-1) allows database administrators, analysts, and developers to work with the Oracle Database including ADBs. Depending on their user roles, these activities may include, but are not limited to •

View and manage database objects



Execute SQL queries



Check database parameters, storage, and memory consumption



Import and export data



Design and execute Machine Learning models

© Adrian Png and Luc Demanche 2020 A. Png and L. Demanche, Getting Started with Oracle Cloud Free Tier, https://doi.org/10.1007/978-1-4842-6011-1_10

177

Chapter 10

SQL Developer Web

Figure 10-1.  Screenshot showing the SQLDEV user interface It also includes SQL Data Modeler (SDDM) that allows database analysts to design and document data models and then generate the necessary Data Definition Language (DDL) files for creating the objects in the database. With so many features packaged into this platform-independent application, it is not surprising that it has a large storage footprint and can consume large amounts of memory. SQLDEV Web was first revealed along with launch of the Autonomous Database service. It contains a subset of key features from its desktop counterpart, but importantly, could be accessed on any network-connected computer using only a web browser. The software was eventually made available for on-premise deployment with the release of Oracle REST Data Services (ORDS) version 19.4. This valuable tool will be the focus of this chapter, but first, an overview of the multitiered application we will create in subsequent chapters. Most IT professionals would have attended a technical conference at least once throughout the span of his or her career. The goal of the project we are about to embark on is to create a suite of web applications to support the fictional Always Cloud Conference (ACC).

178

Chapter 10

SQL Developer Web

There are typically a few activities before, during, and after the event that are best managed using a web-based database appl