急问一条sql语句。在线等.

Question

1.有两个表Ausr和Busr两表中都有字段ID,USR,PWD.想通过一条sql语句查出两个表中，USR等于变量TMP的记录!而且能知道是哪个表中的查出来的数据.用UNION或内、外连接两个方法实现.急。谢了select 'A' TABLENAME ,ID,USR,PWD from A WHERE USR='TMP'
UNION ALL
select 'B' TABLENAME ,ID,USR,PWD from B WHERE USR='TMP'
2 
 SQL> column 字段名1 format a10
 SQL> column 字段名2 format a10
 SQL> select * from aTable

Answer 1

select 'COMPANYUSR' TABLENAME,ID,PWD from COMPANYUSR WHERE USR='bb'
                                 *
ERROR 位于第 1 行:
ORA-12704: 字符集不匹配

Answer 2

select 'COMPANYUSR' TABLENAME,ID,PWD from COMPANYUSR WHERE USR='bb'
                                 *
ERROR 位于第 1 行:
ORA-12704: 字符集不匹配
PWD字段存在!为什么？

Answer 3

sql> select 'COMPANYUSR' TABLENAME,ID from COMPANYUSR WHERE USR='bb'
 -- 还有下面的结果贴上来
 sql> desc COMPANYUSR

Answer 4

desc COMPANYUSR;
名称                                      是否为空? 类型
 ----------------------------------------- -------- ----------------------------
 ID                                        NOT NULL NUMBER(12)
 ISPERMIT                                  NOT NULL NUMBER(8)
 ISPASS                                    NOT NULL NUMBER(8)
 USR                                                NVARCHAR2(12)
 PWD                                                VARCHAR2(12)
 CONAME                                    NOT NULL NVARCHAR2(30)
 PHONE                                     NOT NULL NVARCHAR2(20)
 FAX                                                NVARCHAR2(20)
 EMAIL                                     NOT NULL NVARCHAR2(30)
 REGNAME                                   NOT NULL NVARCHAR2(40)
 SSCOPE                                    NOT NULL NVARCHAR2(30)
 COMNO                                     NOT NULL CHAR(40)
 EKIND                                     NOT NULL NVARCHAR2(30)
 POSTID                                             NVARCHAR2(10)
 DETAILADD                                          NVARCHAR2(100)
 COUNTRYID                                 NOT NULL VARCHAR2(30)
 PROID                                     NOT NULL NVARCHAR2(30)
 CITYID                                    NOT NULL NVARCHAR2(30)
 PROFILE                                            NCHAR(100)
 PHOTO                                              NVARCHAR2(150)
 REGTIME                                   NOT NULL DATE
 ISPOST                                    NOT NULL NUMBER(1)desc adminuser;
名称                                      是否为空? 类型
 ----------------------------------------- -------- ----------------------------
 ID                                        NOT NULL NUMBER(10)
 FROMID                                    NOT NULL NVARCHAR2(10)
 COMPANY                                   NOT NULL NVARCHAR2(30)
 USR                                       NOT NULL NVARCHAR2(10)
 PWD                                       NOT NULL NVARCHAR2(10)
 CONTACT                                            NVARCHAR2(20)
 INTRO                                              NCHAR(50)

Answer 5

SQL> select 'TEST1' TABLENAME,ID, PWD from TEST1 WHERE USR=TRANSLATE('bb' USING
NCHAR_CS);TABLENAME          ID PWD
---------- ---------- ------------------------
TEST1               1 bbSQL> desc test1
 名称                                      是否为空? 类型
 ----------------------------------------- -------- ---------------------------- ID                                                 NUMBER(12)
 USR                                                NVARCHAR2(12)
 PWD                                                VARCHAR2(12)SQL> select * from test1;        ID USR                      PWD
---------- ------------------------ ------------------------
         1 1                        bb
         1 bb                       bb

Answer 6

用pl/sql developer显示比较直观