dcl语句的执行自动提交事务演练

数据库:oracle 19.12

系统:rhel 8.4

实验目标:演练dcl语句的执行自动提交事务.

session1 执行.

SQL> select * from emp_copy;

EMPLOYEE_ID FIRST_NAME LAST_NAME EMAIL PHONE_NUMBER HIRE_生麒麟贵子的女人特征DATE JOB_ID SALARY COMMISSION数据库原理_PCT MANAGER_ID DEPARTMENT_ID

----------- -----------------oracle截取字符串--- --------------- --------------- ----oracle怎么读---------------- --------- ---------- ---------- -------------- ---------- -----------oracle截取字符串--

100 Steven Ki苏卿陆容渊ng SKING 515.123.4567 17-JUN-11 AD_PRES 24000 90

101 NeOracleena Kochhar NKOCH数据库HAR 5数据库查询语句15.123.4568 21-SEP-09 AD_VP 17000 100 90

102 Lex De Haan LDEHAAN 515.123.4569 13-JAN-09 AD_VP 17000 100 90

103 Alexander Hunold AHUNOLD 590.423.4567 03-J数据库AN-14 IT_PROG 9000 102 80

104 Bruce Ernst BERNST 590.423.4568 21-MAY-15 IT_PROG 6000 103 80

107帅气撩人高冷动漫男头 Diana Lorentz DLORENTZ 590.423.5567 07-FEB-15 IT_PROG 4200 103 80

124 Kevin Mourgos KMOURGOS 650.123.5234 16-NOV-15 ST_MAN 5800 100 50

141 Trenna Rajs TRAJS 650.121.8009数据分析师 17-OCT-11 ST_CLERK 3500 124 50

142 Curtis Davies CDAVIES 650.121.2994 29-JAN-13 ST_CLERK 3100 124 50

143 Randall Matos RMATOS 650.121.28数据透视表74 15-MAR-14 ST_CLERK 2600 124 50

144 Peter Vargas PVARGAS 650.121.2004 09-JUL-14 ST_CLERK 2oracle和mysql区别500 124 50

EMPLOYEE_ID FI数据分析师RST_NAME LAST_NAME EMAIL数据透视表 PHONE_NUMBER HIRE_DATE JOB_ID Soracle数据库ALARY C数据库系统工程师OMMISSION_PCT MANAGER_ID DEPARTMENT_ID

----------- ------------数据库系统的核心是------生麒麟贵子的女人特征-- --------------- --数据库软件------------- -------------------- --------- ---------- ---------数据库管理系统- -------------- ---------- ----舍曲林---------

149 Eleni Zlotkey EZLOTKEY 011.44.1sqlserver344.429018 29-J孙侨潞AN-16 SA_MAN 10500 .2 100 80

174 Ellen Abel EABEL 011.44.1644.429267 11-MAY-12 SA_REP 11数据库000 .3 149 80

176 Jonathon Taylor JTAYLOR 011.44.1644.4292oracle截取字符串65 24-MAR-14 SA_REP 8600 .2 149 80

178 Ki数据库有哪几种mberely Grant KG数据标注RANT 011.44.1644.429263 24-MA数据分析Y-15 SA_REP 7000 .15 149

200 Jennifer Whalen JWHALEN 515.123.4444生麒麟贵子的女人特征 17-SEP-11 AD_ASST 4400 101 1数据库系统概论第五版课后答案0

201 Michael Hartstein MHARTSTE 515.123.5555 17-FEB-12 MK_MAN 13000 100 20

202 Pat Fay PFAY 603.123.6666 17-AUG-13 MK_REP 6000 201 20

205数据透视表 Shelley Higgins SHIGGINS 515.1数据库管理系统23.8080 07-JUN-10 AC_MGR数据库系统工程师 12008 101 110

206 William Gietz WGIETZ 515.123.8181oracle分页查询 07-JUN-10 AC_ACCOUNT 8300 205 110

20 rows selected.

SQL> delete from emp_copy;

20 rows deletoracle认证考试ed.

SQL> s生麒麟贵子的女人特征elect * from emp_copy;

no rows selected

SQL> select sid from v$mystat where rownum=1;

SID

----------

3oracle是系统软件吗91

现打开另一个session2,查看表emp_copy的数据.

SQL> select * from emp数据_copy

EMPLOYEE_ID FIRST_NAME LA数据ST_NAME EMAIL PHONE_NUMBER HIRE_DATE JOB_ID SALARY COMMISSI数据漫游是什么意思ON_PCT MANAGER_数据漫游ID DEPARTMENT_ID

----------- -------------oracle分页查询------- ------数据库管理系统--------- -----Oracle---------- -------数据库查询语句------------- --------- ---------- ----SQL------ -------------- ---------- -----数据库系统概论第五版课后答案--------

100 Steven Ki数据ng SKING数据分析师 515.123.4567 17-JUN-11 AD_PRES 24000 90

101 Neena Kochhar NKOCHHAR 515.123.4568 21-SEP-09 AD_VP 17000 100 90

102 Lex De Haan LDEHAAN 515.123.4569 13-JAN-09 AD_VP 17000 100 90

103 Alexander Hunold AHUNOLD 590.423.4567 03-JAN-14 IT_PROG 9000 102 80

104 Bruce Ernst BERNST 590.423.4568 21-MAY-15 IT_PROG 6000 103 80

107 Diana Lorentz DLORENTZ 590.423.5567 07-FEB-15 IT_PROG 4200 103 80

124 Kev数据结构in Mourgos KMOURGOS 650.123.5234 16-NOV-15 ST_MAN 5800 100 50

141 Trenna Rajs TRAJS 650.121.8009 17-OCT生麒麟贵子的女人特征-11 ST_CLERK 3500 124 50

142 Cusqlserverrtis Davies CDAVIES 650.121.2994 29-JAN-13 ST_CLERK 3100 124 50

143 Randall Matos RMATOS 650.121.2874oracle怎么读 15-MAR-14 ST_CLERK 2600 124 50

144 Peter Vargas PVARGAS 650.121.2004 09-JUL-14 ST_CLERK 2500 124 50

EMPLOYEE_ID FIRST_NAME LASToracle截取字符串_NAME EMAIL PHONE_NUMBER HIRE_DATE JOB_ID SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID

----------- -----------------oracle和mysql区别--- --------------- --------------- -------------生麒麟贵子的女人特征------- --------- ---------- ---------- -------------- ---------- -------------

149数据结构 Eleni Zlotkey EZLOTKEY 011.44.1344.429018 29-JAN-16 SA_MAN 10500 .2 100 80

174 Ellen Abel EABEL 011.44.1644.429267 11-MAY-12 SA_REP 11000 .3 149 80

176 Jonathon Taylosql数据库r JTAYLOR 011.44.1644.429265 24-MAR-14 SA_REP 8600 .2 149 80

178 Kimberely Grant KGRANT 011.44.1644.4数据库系统的核心是29263 24-MAY-15 SA_REP 7000 .15 149

200 Jennifer Whalen JWHALEN 515.123.4444 17-SEP-11 AD_ASST 4400 101 10

201 Mic数据废土hael Hartstein MHARTSTE 51oracle怎么读5.123.5555 17-FEB-1数据库系统概论第五版课后答案2 MK_MAN 13000 100 20

202 Pat Fay PFAY 603.123.6666 17-AUG-13 MK_REP 6000 201 20

205 Shelley Higgins SHIGGINS 515.123.8080 07-JUoracle和mysql区别N-10 AC_MGR 12008 101 110

206 William Gietz WGIETZ 515.123.8181 07-JUN-10 ACoracle认证考试_ACCOUNT 8300 205 110

20 rows selected.

SQL> s数据库管理系统elect sid from v$mystat where rownum=1;

SID

----------

32

session2中表emp_copy中数据是存在宋庆玲的.

现在session1中执行一个dcl语句:

SQL> grant select on employees to hr;

Grant succeeded.

session2再次查数据库有哪几种看.

SQL> select sid from v$mystat wher数据库系统工程师e rownum=1;

SID

----------

32

SQL> select * from emp_copy;

no row神祇领主时代s selected

说明:数据分析师session2已查询不到表信息,session1执行的grant语句自动提交了delete操作.