系统: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操作.
发表评论