拼接字符串为查询结果
concat()方法
select concat(username,password) from test # 搜索结果:admin12345
select concat(username,',',password) from test # 搜索结果:admin,12345
联合查询
select stuid,stuname from student
union
select teaid,teaname from teacher
查询出所有的学生和老师的ID和编号
【43】Oracle查看锁表与解锁方法
–查看
select a.object_name,b.session_id,c.serial#,c.program,c.username,c.command,c.machine,c.lockwait from all_objects a,v
l
o
c
k
e
d
o
b
j
e
c
t
b
,
v
locked_object b,v
lockedobjectb,vsession c where a.object_id=b.object_id and c.sid=b.session_id;
–解锁
alter system kill session’session_id,serial#’;
–例句
alter system kill session’453,10316’;