Oracle SQL * plus is a client tool that interacts with oracle. In SQL * plus, you can run the SQL * plus command and the SQL * plus statement.
The DML, DDL, and DCL statements we usually call are SQL * plus statements. After they are executed,
SQL * Plus command (1) Introduction: Oracle SQL * Plus is a client tool for interacting with Oracle. In SQL * Plus, you can run the SQL * Plus command and the SQL * Plus statement.
The DML, DDL, and DCL statements we usually call are SQL * Plus
1. Execute an SQL script file
SQL> Start file_name
SQL> @ file_name
We can save multiple SQL statements in a text file, so that when we want to execute all the SQL statements in this file, we can use any of the following commands, which is similar
How to solve the connection problem in SQL Server 2000
Applicable
Important: This article contains information about modifying the registry. Before modifying the registry, you must back up the registry and know how to restore the Registry in case of
There are two types of SQL statements written and used in the Delphi application: Static SQL statements, dynamic SQL statements. The static SQL statement is the SQL attribute value setting for the Tquery part in the program design phase. Dynamic SQL
Create Database hufangOn Primary -- by default, it belongs to the primary main file group, which can be omitted(/* -- Specific description of the data file --*/Name = 'hufang _ data', -- physical name of the primary databaseFilename = 'f: \ project \
Method 1:1. Open the query analyzer and enter the command
Backup log database_name WITH NO_LOG
2. Choose "Enterprise Manager"> "right-click the database to be compressed"> "all tasks"> "shrink Database"> "contract file"> "select" Log File ">"
Oracle Oracle's Sql*plus is a client tool that interacts with Oracle. In Sql*plus, you can run the Sql*plus command and the Sql*plus statement.
Our usual DML, DDL, and DCL statements are sql*plus statements that, when executed, can be stored in an
Oracle SQL * plus is a client tool that interacts with oracle. In SQL * plus, you can run the SQL * plus command and the SQL * plus statement. The DML, DDL, and DCL statements we usually call are SQL * plus statements. After they are executed, they
The following describes some common SQL * Plus commands:
1. Execute an SQL script fileSQL> Start file_nameSQL> @ file_nameWe can save multiple SQL statements in a text file, so that when we want to execute all the SQL statements in this file, we can
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.