concat(a,b):最多联合两个字段
示例:
创表:
create table t_num(
id varchar2(10) primary key,
name nvarchar2(10),
sex nvarchar2(10),
age number(10,0)
);
插值:
insert all
into t_num(id,name,sex,age) values(1,'张三','男',20)
into t_num(id,name,sex,age) values(2,'李四','男',21)
into t_num(id,name,sex,age) values(3,'王五','男',24)
select * from dual;
查原表:
CONCAT()和||的使用: