Shulou(Shulou.com)06/01 Report--

[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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.