Creating Database Objects

#oracle #tutorial #database

This tutorial describes how to create tables, stored procedures and other objects on Oracle server.

Requirements

In order to create database objects, you have to connect to the server. This process is described in detail in the tutorial Logging onto the server.

General information

Database objects are created using Data Definition Language (DDL), which is a part of SQL. The DDL statements can be executed on the server by an account that has the necessary privileges.

There are two ways to manipulate a database. You can build DDL statements manually and run them within Oracle SQL*Plus or a component like OracleCommand. Another way is to use IDE - visual shells that provide a graphical user interface to manage the database. We will discuss both ways.

Read the full article here

How I Cut 22.3 Seconds Off an API Call with Sentry 🕒

Struggling with slow API calls? Dan Mindru walks through how he used Sentry's new Trace View feature to shave off 22.3 seconds from an API call.

Get a practical walkthrough of how to identify bottlenecks, split tasks into multiple parallel tasks, identify slow AI model calls, and more.

Top comments (0)

5 Playwright CLI Flags That Will Transform Your Testing Workflow

0:56 --last-failed

2:34 --only-changed

4:27 --repeat-each

5:15 --forbid-only

5:51 --ui --headed --workers 1

Learn how these powerful command-line options can save you time, strengthen your test suite, and streamline your Playwright testing experience. Click on any timestamp above to jump directly to that section in the tutorial!

DEV Community