自拍偷在线精品自拍偷,亚洲欧美中文日韩v在线观看不卡

Oracle 10g利用utlsampl.sql創(chuàng)建scott用戶及樣本數(shù)據(jù)

作者：ddyzt
數(shù)據(jù)庫(kù) Oracle
本文我們主要介紹了Oracle 10g利用utlsampl.sql創(chuàng)建scott用戶及樣本數(shù)據(jù)的過(guò)程，并給出了utlsampl.sql腳本內(nèi)容，希望能夠?qū)δ兴鶐椭?/div>

Oracle 10g利用utlsampl.sql創(chuàng)建scott用戶及樣本數(shù)據(jù)是本文我們主要要介紹的內(nèi)容，我們知道，很多的演示程序都是以scott用戶及其用戶下的表做例子的，于是，快速的創(chuàng)建這個(gè)用戶和初始化表中的數(shù)據(jù)是必須的。在Oracle 10g環(huán)境中這個(gè)過(guò)程很簡(jiǎn)便，只需要以sys用戶執(zhí)行一下$ORACLE_HOME/rdbms/admin/utlsampl.sql腳本就OK了。

下面來(lái)演示一下這個(gè)過(guò)程。以便大家參考。

1.確認(rèn)一下數(shù)據(jù)庫(kù)的版本，同時(shí)查看一下系統(tǒng)中是否已經(jīng)存在scott用戶。

  1. sys@ora10g> select * from v$version;  
  2. BANNER  
  3. ----------------------------------------------------------------  
  4. Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi  
  5. PL/SQL Release 10.2.0.3.0 - Production  
  6. CORE    10.2.0.3.0      Production  
  7. TNS for Linux: Version 10.2.0.3.0 - Production  
  8. NLSRTL Version 10.2.0.3.0 - Production  
  9. sys@ora10g>select USERNAME,ACCOUNT_STATUS,DEFAULT_TABLESPACE,TEMPORARY_TABLESPACE,CREATED from dba_users where USERNAME = 'SCOTT';  
  10. no rows selected 

2.創(chuàng)建腳本路徑$ORACLE_HOME/rdbms/admin/utlsampl.sql

  1. sys@ora10g>@?/rdbms/admin/utlsampl.sql  
  2. Table created.  
  3. Table created.  
  4. 1 row created.  
  5. 1 row created.  
  6. 1 row created.  
  7. 1 row created.  
  8. 1 row created.  
  9. 1 row created.  
  10. 1 row created.  
  11. 1 row created.  
  12. 1 row created.  
  13. 1 row created.  
  14. 1 row created.  
  15. 1 row created.  
  16. 1 row created.  
  17. 1 row created.  
  18. 1 row created.  
  19. 1 row created.  
  20. 1 row created.  
  21. 1 row created.  
  22. Table created.  
  23. Table created.  
  24. 1 row created.  
  25. 1 row created.  
  26. 1 row created.  
  27. 1 row created.  
  28. 1 row created.  
  29. Commit complete.  
  30. Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production  
  31. With the Partitioning, Data Mining and Real Application Testing options  
  32. ora10g@linux5 /home/oracle$ 

3.驗(yàn)證用戶是否創(chuàng)建成功

 

  1. sys@ora10g>select USERNAME,ACCOUNT_STATUS,DEFAULT_TABLESPACE,TEMPORARY_TABLESPACE,CREATED from dba_users where USERNAME = 'SCOTT';  
  2. USERNAME ACCOUNT_STATUS DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED  
  3. -------- -------------- ------------------ -------------------- ---------  
  4. SCOTT    OPEN           USERS              TEMP                 05-MAR-09  
  5. sys@ora10g>conn scott/tiger  
  6. Connected.  
  7. scott@ora10g> 
  8. scott@ora10g>select * from cat;  
  9. TABLE_NAME                     TABLE_TYPE  
  10. ------------------------------ -----------  
  11. DEPT                           TABLE  
  12. EMP                            TABLE  
  13. BONUS                          TABLE  
  14. SALGRADE                       TABLE 

 

4.【附錄】utlsampl.sql腳本內(nèi)容

  1. $ cat $ORACLE_HOME/rdbms/admin/utlsampl.sql  
  2. Rem Copyright (c) 1990, 1996, 1997, 1999, 2001 by Oracle Corporation  
  3. Rem NAME  
  4. REM    UTLSAMPL.SQL  
  5. Rem  FUNCTION  
  6. Rem  NOTES  
  7. Rem  MODIFIED  
  8. Rem     menash     02/21/01 -  remove unnecessary users for security reasons  
  9. Rem     gwood      03/23/99 -  make all dates Y2K compliant  
  10. Rem     jbellemo   02/27/97 -  dont connect as system  
  11. Rem     akolk      08/06/96 -  bug 368261: Adding date formats  
  12. Rem     glumpkin   10/21/92 -  Renamed from SQLBLD.SQL  
  13. Rem     blinden   07/27/92 -  Added primary and foreign keys to EMP and DEPT  
  14. Rem     rlim       04/29/91 -         change char to varchar2  
  15. Rem     mmoore     04/08/91 -         use unlimited tablespace priv  
  16. Rem     pritto     04/04/91 -         change SYSDATE to 13-JUL-87  
  17. Rem   Mendels    12/07/90 - bug 30123;add to_date calls so language independent  
  18. Rem  
  19. rem  
  20. rem $Header: utlsampl.sql 21-feb-01.18:15:30 menash Exp $ sqlbld.sql  
  21. rem  
  22. SET TERMOUT OFF  
  23. SET ECHO OFF  
  24. rem CONGDON    Invoked in RDBMS at build time.   29-DEC-1988  
  25. rem OATES:     Created: 16-Feb-83  
  26. DROP USER SCOTT CASCADE;  
  27. DROP USER ADAMS CASCADE;  
  28. DROP USER JONES CASCADE;  
  29. DROP USER CLARK CASCADE;  
  30. DROP USER BLAKE CASCADE;  
  31. GRANT CONNECT,RESOURCE,UNLIMITED TABLESPACE TO SCOTT IDENTIFIED BY TIGER;  
  32. DROP PUBLIC SYNONYM PARTS;  
  33. CONNECT SCOTT/TIGER  
  34. CREATE TABLE DEPT  
  35.        (DEPTNO NUMBER(2) CONSTRAINT PK_DEPT PRIMARY KEY,  
  36.         DNAME VARCHAR2(14) ,  
  37.         LOC VARCHAR2(13) ) ;  
  38. CREATE TABLE EMP  
  39.        (EMPNO NUMBER(4) CONSTRAINT PK_EMP PRIMARY KEY,  
  40.         ENAME VARCHAR2(10),  
  41.         JOB VARCHAR2(9),  
  42.         MGR NUMBER(4),  
  43.         HIREDATE DATE,  
  44.         SAL NUMBER(7,2),  
  45.         COMM NUMBER(7,2),  
  46.         DEPTNO NUMBER(2) CONSTRAINT FK_DEPTNO REFERENCES DEPT);  
  47. INSERT INTO DEPT VALUES  
  48.         (10,'ACCOUNTING','NEW YORK');  
  49. INSERT INTO DEPT VALUES (20,'RESEARCH','DALLAS');  
  50. INSERT INTO DEPT VALUES  
  51.         (30,'SALES','CHICAGO');  
  52. INSERT INTO DEPT VALUES  
  53.         (40,'OPERATIONS','BOSTON');  
  54. INSERT INTO EMP VALUES  
  55. (7369,'SMITH','CLERK',7902,to_date('17-12-1980','dd-mm-yyyy'),800,NULL,20);  
  56. INSERT INTO EMP VALUES  
  57. (7499,'ALLEN','SALESMAN',7698,to_date('20-2-1981','dd-mm-yyyy'),1600,300,30);  
  58. INSERT INTO EMP VALUES  
  59. (7521,'WARD','SALESMAN',7698,to_date('22-2-1981','dd-mm-yyyy'),1250,500,30);  
  60. INSERT INTO EMP VALUES  
  61. (7566,'JONES','MANAGER',7839,to_date('2-4-1981','dd-mm-yyyy'),2975,NULL,20);  
  62. INSERT INTO EMP VALUES  
  63. (7654,'MARTIN','SALESMAN',7698,to_date('28-9-1981','dd-mm-yyyy'),1250,1400,30);  
  64. INSERT INTO EMP VALUES  
  65. (7698,'BLAKE','MANAGER',7839,to_date('1-5-1981','dd-mm-yyyy'),2850,NULL,30);  
  66. INSERT INTO EMP VALUES  
  67. (7782,'CLARK','MANAGER',7839,to_date('9-6-1981','dd-mm-yyyy'),2450,NULL,10);  
  68. INSERT INTO EMP VALUES  
  69. (7788,'SCOTT','ANALYST',7566,to_date('13-JUL-87','dd-mm-rr')-85,3000,NULL,20);  
  70. INSERT INTO EMP VALUES  
  71. (7839,'KING','PRESIDENT',NULL,to_date('17-11-1981','dd-mm-yyyy'),5000,NULL,10);  
  72. INSERT INTO EMP VALUES  
  73. (7844,'TURNER','SALESMAN',7698,to_date('8-9-1981','dd-mm-yyyy'),1500,0,30);  
  74. INSERT INTO EMP VALUES  
  75. (7876,'ADAMS','CLERK',7788,to_date('13-JUL-87', 'dd-mm-rr')-51,1100,NULL,20);  
  76. INSERT INTO EMP VALUES  
  77. (7900,'JAMES','CLERK',7698,to_date('3-12-1981','dd-mm-yyyy'),950,NULL,30);  
  78. INSERT INTO EMP VALUES  
  79. (7902,'FORD','ANALYST',7566,to_date('3-12-1981','dd-mm-yyyy'),3000,NULL,20);  
  80. INSERT INTO EMP VALUES  
  81. (7934,'MILLER','CLERK',7782,to_date('23-1-1982','dd-mm-yyyy'),1300,NULL,10);  
  82. CREATE TABLE BONUS  
  83.         (  
  84.         ENAME VARCHAR2(10)      ,  
  85.         JOB VARCHAR2(9)  ,  
  86.         SAL NUMBER,  
  87.         COMM NUMBER  
  88.         ) ;  
  89. CREATE TABLE SALGRADE  
  90.       ( GRADE NUMBER,  
  91.         LOSAL NUMBER,  
  92.         HISAL NUMBER );  
  93. INSERT INTO SALGRADE VALUES (1,700,1200);  
  94. INSERT INTO SALGRADE VALUES (2,1201,1400);  
  95. INSERT INTO SALGRADE VALUES (3,1401,2000);  
  96. INSERT INTO SALGRADE VALUES (4,2001,3000);  
  97. INSERT INTO SALGRADE VALUES (5,3001,9999);  
  98. COMMIT; 

 

關(guān)于Oracle 10g數(shù)據(jù)庫(kù)利用系統(tǒng)自帶腳本utlsampl.sql創(chuàng)建scott用戶及樣本數(shù)據(jù)的過(guò)程就介紹到這里了，希望本次的介紹能夠?qū)δ兴斋@！

【編輯推薦】

  1. Oracle數(shù)據(jù)庫(kù)包的構(gòu)造過(guò)程實(shí)例
  2. Oracle數(shù)據(jù)庫(kù)創(chuàng)建Schema的代碼示例
  3. ORACLE GOLDENGATE的主要組件詳解
  4. Python模擬Oracle的SQL/PLUS工具的實(shí)現(xiàn)方法
  5. Windows7安裝Oracle database lite 10g的錯(cuò)誤解決
責(zé)任編輯：趙鵬 來(lái)源： 網(wǎng)易博客
Oracle 10gutlsampl.sqlscott用戶
相關(guān)推薦

2011-03-29 09:56:48

Oracle數(shù)據(jù)庫(kù)10SQL

2009-10-26 13:54:29

Oracle 10g用

2009-10-20 18:32:25

Oracle 10g

2011-04-15 09:53:37

Oracle 10gSQL優(yōu)化

2010-04-13 10:07:19

Oracle 10G

2010-04-14 16:09:51

Oracle 10g歸

2011-08-17 15:13:47

Oracle 10g透SQL Server

2010-04-09 15:59:24

Oracle 10g

2009-10-23 15:54:01

Oracle 10g序

2011-08-29 13:40:12

Oracle 10g創(chuàng)建表空間

2011-05-13 11:21:51

linuxoracle 10g安裝

2010-04-12 13:34:42

Oracle 10g

2010-04-07 09:39:18

Oracle 10G

2009-11-19 15:57:34

Oracle 10g數(shù)

2011-03-25 16:10:58

oraclenagios

2010-02-03 16:16:49

Linux Oracl

2009-11-19 10:32:41

Oracle 10g服

2010-03-30 19:31:25

Oracle 10g

2010-04-13 09:58:52

Oracle 10G

2011-08-09 18:15:24

Oracle 10g查找數(shù)據(jù)
點(diǎn)贊
收藏

51CTO技術(shù)棧公眾號(hào)