DotConnect for Oracle getting started Guide (3): creating database objects
[download the latest version of dotConnect for Oracle]
DotConnect for Oracle (formerly known as OraDirect.NET) is based on ADO.NET technology and provides a complete solution for applications based on Oracle database. It brings a new method for designing the application structure, improves the work efficiency, and makes the development of the database application easier.
This tutorial shows you how to create tables, stored procedures, and other objects on an Oracle server.
In this tutorial:
Request
General information
Use SQL*Plus
Use DBForge Fusion for Oracle
Additional information
Request
In order to create database objects, you must connect to the server. This process is described in detail in the tutorial on logging in to the server.
General information
Database objects are created using data definition language (DDL), and DDL is part of SQL. DDL statements can be executed on the server by an account with the necessary permissions.
There are two ways to manipulate the database. You can build DDL statements manually and run them in components such as Oracle SQL*Plus or OracleCommand. Another way is to use an IDE visual shell that provides a graphical user interface to manage the database. We will discuss two ways.
Use SQL*Plus
Start SQL*PLUS and authorize it yourself.
Type:
one
