可以SQL> select * from aa;NAME TIME CD ---------- ---------- ---------- TONY 2 AA HALLEN 1 BB KAKA 3 CC HENRY 4 DD 1 SQL> select name||time||cd from aa;NAME||TIME||CD ------------------------------------------------------------ TONY2AA HALLEN1BB KAKA3CC HENRY4DD 1SQL> select name||time||cd from aa where name||time||cd='KAKA3CC' 2 ;NAME||TIME||CD ------------------------------------------------------------ KAKA3CCSQL> select name,time,cd from aa where name||time||cd='KAKA3CC' 2 ;NAME TIME CD ---------- ---------- ---------- KAKA 3 CC
建一个视图,它的一列d 就是abc三个列拼接的 这样就行了
CREATE OR REPLACE VIEW VIEW_ABC AS SELECT A||B||C "D" FROM TABLE_NAME ;
OR SELECT * FROM TABLE_NAME WHERE A||B||C = '&ENTER_VAR';
---------- ---------- ----------
TONY 2 AA
HALLEN 1 BB
KAKA 3 CC
HENRY 4 DD
1 SQL> select name||time||cd from aa;NAME||TIME||CD
------------------------------------------------------------
TONY2AA
HALLEN1BB
KAKA3CC
HENRY4DD
1SQL> select name||time||cd from aa where name||time||cd='KAKA3CC'
2 ;NAME||TIME||CD
------------------------------------------------------------
KAKA3CCSQL> select name,time,cd from aa where name||time||cd='KAKA3CC'
2 ;NAME TIME CD
---------- ---------- ----------
KAKA 3 CC
SELECT A||B||C "D"
FROM TABLE_NAME
;
OR SELECT *
FROM TABLE_NAME
WHERE A||B||C = '&ENTER_VAR';