一个是SELECT lpad(FORWARDER_ID_SEQ.nextval,7,'0') from dual这个SQL(产生个字符串)还有个是
select distinct STATE_SID from ALL_ORG_VIEW where BRANCH_SID =?我想把这两个查询出来的结果拼接
要怎么做ALL_ORG_VIEW是视图谢谢!!
select distinct STATE_SID from ALL_ORG_VIEW where BRANCH_SID =?我想把这两个查询出来的结果拼接
要怎么做ALL_ORG_VIEW是视图谢谢!!
我用||写了几个不行
给你个例子SQL> select
2 ((select lpad('adfdfdfdfd',7,'0') from dual)||
3 (select substr('1234',1,3) from dual)) from dual
4 ;
((SELECTLPAD('ADFDFDFDFD',7,'0
------------------------------
adfdfdf123
... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec [0 successful, 0 warnings, 1 errors]
SQL是
select
(select distinct STATE_SID from ALL_ORG_VIEW where BRANCH_SID ='898')||
(SELECT lpad(FORWARDER_ID_SEQ.nextval,7,'0') from dual) from dual
union all
elect distinct STATE_SID from ALL_ORG_VIEW where BRANCH_SID =?
union all
select distinct STATE_SID from ALL_ORG_VIEW where BRANCH_SID ='898'错误 14:40:04 [SELECT - 0 row(s), 0.000 secs] [Error Code: 2287, SQL State: 42000] ORA-02287: sequence number not allowed here
... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec [0 successful, 0 warnings, 1 errors]
2 ((select lpad('adfdfdfdfd',7,'0') from dual)||
3 (select substr('1234',1,3) from dual)) from dual
4 ;
((SELECTLPAD('ADFDFDFDFD',7,'0
------------------------------
adfdfdf123
这种的可以,但是加上序列号是不行的 ora-02287:此处不允许序列号
不会吧????你确定?
但是必须要调用个sequences,因为要与查询出来的sequences拼接在一起
你可以试下
这位朋友可能没理解我的意思。或者我没理解您的意思。
like '%21279%'。。这个模糊查询干嘛呢?
from (select distinct empno from emp ) t上面这个语句可以,但不知道是不是你想要的
from ( select distinct STATE_SID from ALL_ORG_VIEW where BRANCH_SID =?) a;