This tutorial describes how to create tables, stored procedures and other objects on Oracle server.
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.
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