Oracle基本操作

1、普通用户登录：
方式一：
	C:\Users\Administrator>sqlplus scott/scott(用户名/密码)

	SQL*Plus: Release 11.2.0.1.0 Production on 星期五 8月 11 21:53:53 2017

	Copyright (c) 1982, 2010, Oracle.  All rights reserved.


	连接到:
	Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
	With the Partitioning, OLAP, Data Mining and Real Application Testing options
方式二：
	C:\Users\Administrator>sqlplus scott/scott

	SQL*Plus: Release 11.2.0.1.0 Production on 星期五 8月 11 21:53:53 2017

	Copyright (c) 1982, 2010, Oracle.  All rights reserved.


	连接到:
	Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
	With the Partitioning, OLAP, Data Mining and Real Application Testing options
2、超级用户登录
	C:\Users\Administrator>sqlplus /nolog

	SQL*Plus: Release 11.2.0.1.0 Production on 星期五 8月 11 22:18:04 2017

	Copyright (c) 1982, 2010, Oracle.  All rights reserved.

	SQL> connect /as sysdba
	已连接。
3、退出登录
	SQL> quit
	从 Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
	With the Partitioning, OLAP, Data Mining and Real Application Testing options 断开
4、查看当前用户下的所有表
	SQL> select * from tab;

	TNAME                          TABTYPE  CLUSTERID
	------------------------------ ------- ----------
	BONUS                          TABLE
	DEPT                           TABLE
	EMP                            TABLE
	SALGRADE                       TABLE
5、查询表的所有记录
	SQL> select * from dept;

	    DEPTNO DNAME          LOC
	---------- -------------- -------------
	        10 ACCOUNTING     NEW YORK
	        20 RESEARCH       DALLAS
	        30 SALES          CHICAGO
	        40 OPERATIONS     BOSTON
6、查看表结构
	SQL> desc dept;
	 名称                                      是否为空? 类型
	 ----------------------------------------- -------- ----------------------------
	 DEPTNO                                    NOT NULL NUMBER(2)
	 DNAME                                              VARCHAR2(14)
	 LOC
7、设置行宽
	SQL> set linesize 150;
8、设置页大小
	SQL> set pagesize 120;
9、设置列宽
	SQL> col deptno for 99999999;
10、清屏
	SQL> host cls;
11、修改SQL语句
	SQL> edit;