oracle修改用的表名

//oracle 查询 各表中重复的列名

SQL> DESC A

名称 是否为空? 类型

----------------------------------------- -------- --------------------- A DATE NAME CHAR(10)

SQL> DESC B

名称 是否为空? 类型

----------------------------------------- -------- --------------------- ID NUMBER A DATE

SQL> DESC TEST

名称 是否为空? 类型

----------------------------------------- -------- --------------------- A DATE

SQL> SELECT * 2 FROM (

3 SELECT TABLE_NAME, 4 COLUMN_NAME,

5 COUNT(*) OVER (PARTITION BY COLUMN_NAME) COL_COUNT 6 FROM USER_tAB_COLUMNS 7 )

8 WHERE COL_COUNT>1;

TABLE_NAME COLUMN_NAME COL_COUNT ------------------------------ ------------------------------ ---------- TEST A 3 A A 3 B A 3 SQL>

T_110_FKDXX_XG SJCJSJ 3 T_ALARMINFO SJCJSJ 3 T_110_FKDXX SJFSSJ 2

查询警情的记录//\" select CJRJH from T_110_FKDXX_XG where SJCJSJ = (select

to_char(SJCJSJ,'YYYY-MM-DD HH24:MI:SS') from T_ALARMINFO where JQBH=201007141145);\" //查询警情的记录

SQL用的表

use my_data

select top 10 * from t_curalarm

select top 10 * from t_alarminfo