select uname,pswd,'tab1' tbname from tab1 union all select user_name uname,password pswd,'tab2' tbname from tab2;
select uname,pswd,'tab1' tbname from tab1 union select user_name uname,password pswd,'tab2' tbname from tab2;
nyfor, bzszp,我按你们所说的的方法,测试的语句如下,提示的错误都是:ORA-00911:invalid character我具体用到的测试语句是:(用是Oracl8.1.7) 1.select pkid,login_name,pwd,'user_info' from user_info union all select pkid,login_name,pwd,'rep_user_info' from rep_user_info;2.select pkid,login_name,pwd,'user_info' tab from user_info union all select pkid,login_name,pwd,'rep_user_info' tab from rep_user_info;3.select pkid,login_name,pwd,'user_info' as tab from user_info union all select pkid,login_name,pwd,'rep_user_info' as tab from rep_user_info;
不可能呀,这么简单的SQL会出现 无效字符 的错误? 我这里不出现你的错误; 我的也是 oracle 8.1.7 SQL> create table user_info 2 ( 3 pkid number, 4 login_name varchar2(20), 5 pwd varchar2(20) 6 );Table created.SQL> SQL> create table rep_user_info as 2 select * from user_info;Table created.SQL> SQL> select pkid,login_name,pwd,'user_info' from user_info 2 union all 3 select pkid,login_name,pwd,'rep_user_info' from rep_user_info;no rows selectedSQL> drop table user_info;Table dropped.SQL> drop table rep_user_info;Table dropped.SQL>
union all
select user_name uname,password pswd,'tab2' tbname from tab2;
union
select user_name uname,password pswd,'tab2' tbname from tab2;
1.select pkid,login_name,pwd,'user_info' from user_info union all select pkid,login_name,pwd,'rep_user_info' from rep_user_info;2.select pkid,login_name,pwd,'user_info' tab from user_info union all select pkid,login_name,pwd,'rep_user_info' tab from rep_user_info;3.select pkid,login_name,pwd,'user_info' as tab from user_info union all select pkid,login_name,pwd,'rep_user_info' as tab from rep_user_info;
我这里不出现你的错误;
我的也是 oracle 8.1.7
SQL> create table user_info
2 (
3 pkid number,
4 login_name varchar2(20),
5 pwd varchar2(20)
6 );Table created.SQL>
SQL> create table rep_user_info as
2 select * from user_info;Table created.SQL>
SQL> select pkid,login_name,pwd,'user_info' from user_info
2 union all
3 select pkid,login_name,pwd,'rep_user_info' from rep_user_info;no rows selectedSQL> drop table user_info;Table dropped.SQL> drop table rep_user_info;Table dropped.SQL>
建议还是不要用了,直接用SQL PLUS也很方便