regedit，然后进入HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0将该环境变量ORACLE_SID设置为XXXX,XXXX就是你的database SID.或者右几我的电脑，属性--高级--环境变量---系统变量--新建，变量名=oracle_sid,变量值=XXXX,XXXX就是你的database SID.或者进入sqlplus前，在command line下输set oracle_sid=XXXX,XXXX就是你的database SID.是不是主机改过名?重建监听试试
Lists one or more lines of the most recently executed SQL command or PL/SQL block which is stored in the SQL buffer. Enter LIST with no clauses to list all lines. In SQL*Plus command-line you can also use ";" to list all the lines in the SQL buffer. The buffer has no command h...
Re: sqlplus vs mysql command line tool 5482 Carsten Pedersen July 19, 2004 11:22AM Sorry, you can't reply to this topic. It has been closed.Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not neces...
Executes the most recently executed SQL command or PL / SQL block which is stored in the SQL buffer. Use slash ( / ) at the command prompt or line number prompt in SQL * Plus command line, or use slash ( / ) in the iSQL * Plus Workspace. The buffer has no command history and d...
Running the helpdrop.sql Script to Remove Command-line Help Run the provided SQL script, HELPDROP.SQL, to remove the command-line help. Log in to SQL*Plus as the SYSTEM user with: SQLPLUS SYSTEM You are prompted to enter the password you have defined for the SYSTEM user. ...
SQL*Plus is a command-line interface tool provided by Oracle Corporation for interacting with the Oracle Database. It is a powerful and versatile tool widely used by database administrators, developers, and users for executing SQL statements, managing database objects, and performing various ...
sqlplus是经经常使用的工具了,它提供了非常多功能,用起来十分方便便捷。 1.获取帮助 SQL> help HELP --- Accesses this command line help system. Enter HELP INDEX or ? INDEX for a list of topics. You can view SQL*Plus resources at http://www.oracle.com/technology/tech/sql_plus/ and...
SCSI Block Command - 3(SBC-3) JP 3-30, Command and Control for Joint Air Operations inline_command_EMC内部inline命令集 TCL-TK-Command_Reference_Guide The Command Line Crash Course Krieger - Command of the Sea - The History and Strategy of Maritime Empires Oracle数据库系统应用开发实用教程电子...
在命令行状态下(win98-command or win2k-cmd or Unix-commandline)在哪里启动sqlplus，SQL就存放在哪里。在windows下，用快捷方式启动sqlplus的话，修改此快捷方式的“起始位置"
dbms_output.put_line会"吃掉"最前面的空格?在set serveroutput on后加上format wrapped参数! 10).当SQL语句的长度大于LINESIZE时,是否在显示时截取SQL语句。 SQL> SET WRA[P] {ON|OFF} 当输出的行的长度大于设置的行的长度时(用set linesize n命令设置),当set wrap on时,输出行的多于的字符会另起一行...