Install the ORACLE11G database software on redhat5.5 (32bit), install a database, and then log in to the database to create the Scott/tiger test
Log in to the database first, where the database is not started
[Email protected] oradata]$ Sqlplus/as SYSDBA
Sql*plus:release 11.2.0.1.0 Production on Thu Jul 9 17:54:53 2015
Copyright (c) 1982, Oracle. All rights reserved.
Connected to an idle instance.
Sql>
Create a Scott user to learn SQL statements, scripts placed in $oracle_home/rdbms/admin/utlsampl.sql
Sql> @?/rdbms/admin/utlsampl.sql
Sql> Conn Scott/tiger
Connected.
Sql> select * from EMP;
EMPNO ename JOB MGR hiredate SAL COMM DEPTNO
---------- ---------- --------- ---------- --------- ---------- ---------- ----------
7369 SMITH Clerk 7902 17-dec-80 800 20
7499 ALLEN salesman 7698 20-feb-81 1600 300 30
7521 WARD salesman 7698 22-feb-81 1250 500 30
7566 JONES MANAGER 7839 02-apr-81 2975 20
7654 MARTIN salesman 7698 28-sep-81 1250 1400 30
7698 BLAKE MANAGER 7839 01-may-81 2850 30
7782 CLARK MANAGER 7839 09-jun-81 2450 10
7788 SCOTT ANALYST 7566 19-apr-87 3000 20
7839 KING President 17-nov-81 5000 10
7844 TURNER salesman 7698 08-sep-81 1500 0 30
7876 ADAMS Clerk 7788 23-may-87 1100 20
7900 JAMES Clerk 7698 03-dec-81 950 30
7902 FORD ANALYST 7566 03-dec-81 3000 20
7934 MILLER Clerk 7782 23-jan-82 1300 10
Rows selected.
Sql>
Under normal circumstances the above results are not so neat, you can set the displayed variables in the home directory.
Environment settings:
[Email protected] ~]$ vim Login.sql
Define_editor=vi
Set Line 180
Set pages 999
Oracle's initial creation Scott/tiger to test