17,075
社区成员
发帖
与我相关
我的任务
分享
--创建视图
create view view_date
as
SELECT A1||'-'||A2||'-'||A3 a
from DATA-TABLE
--建立索引 语法
create index idx_date on DATA-TABLE(A1)
SQL> select * from test;
A1 A2 A3
----- ----- -----
a1 a2 a3
b2 b3 b4
SQL> select a1 || ',' || a2 || ',' || a3 as a from test;
A
-----------------
a1,a2,a3
b2,b3,b4