DEV Community

andreasneuman
andreasneuman

Posted on

Creating Database Objects

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

Discussion (0)