oracle sql基础

将两个字段的值显示在一列
select u.id || u.name from user u

字符替换，如果这个字段为空，则显示0
nvl(字段名,0)

查看用户执行中的sql
select sql_text from v$session a, v$sqltext b where a.sql_address = b.address and username = 'newhyfx' order by address, piece;