how to connect to oracle database using sqlplus in windows
how to connect to oracle database using sqlplus in windows
Read about how to connect to oracle database using sqlplus in windows, The latest news, videos, and discussion topics about how to connect to oracle database using sqlplus in windows from alibabacloud.com
How to connect to the Oracle database and how to solve the fault-Summary highly recommended This article describes how to connect to Oracle Summary , Especially suitable Program Developers and Oracle cainiao How to configure to connect the client
Use SQL * Plus to connect to the database and sqlplus to connect to the database
About SQL * Plus
SQL * Plus is the primary command-line interface to your Oracle database. you use SQL * Plus to start up and shut down the database, set database
Common exceptions:ORA-14025: Cannot specify partition for a solid view or a solid view logOra-14026:partition and cluster clauses repel each otherORA-14027: Only one partition clause can be specifiedORA-14028: Missing at or values
Problem Description: When landing Oracle database, whether from SQL Plus or from Toad Landing, there will be no landing on the phenomenon. Prompt for package receive failed: ORA-12637 appears.
Workaround: Modify the Sqlnet.ora file,
1.oracle InstallationRefer to http://wenku.baidu.com/view/d01ffd43336c1eb91a375d68.html, no longer repeat here2. Command line sqlplus Connect Oracle(1) Check the monitoring statusc:\>lsnrctl StatusLsnrctl for 32-bit windows:version
Our usual DML, DDL, and DCL statements are sql*plus statements that, when executed, can be stored in an area of memory called SQL Buffer, and can only hold a recently executed SQL statement, and we can save SQL in SQL buffer Statements are modified
First of all, I apologize to you for your lack of stability due to work reasons, so my blog has not been updated in time. Today, I finally took the time to update my blog and write the results I got in two hours.
Recently, the development platform
Some time ago, a brother found a post on my blog about how to use OCI to link oracle Database Configuration methods. Because it was just a simple record, there were a lot of things in the article.
Some time ago, a brother found a post on my blog
The DML, DDL, and DCL statements we usually call are SQL * plus statements. After they are executed, they can be stored in a memory area called SQL buffer, in addition, only one SQL statement can be saved recently. We can modify the SQL statement
Basics of connecting OCI to Oracle in Linux ---- configuring Instant Client to connect to oracle Database
Some time ago, a brother posted a post on my blog about how to use OCI to link oracle Database Configuration methods, A lot of things in that
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.