1.查询时不区分大小写
select t.* from ballotcount t where upper(code) = upper('q')
select t.* from ballotcount t where lower(code) = lower('q')
2.查看一个表的主键
select column_name from user_cons_columns wherE CONSTRAINT_NAME in (select CONSTRAINT_NAME from user_constraints where table_name =upper('TABLE_NAME') and CONSTRAINT_TYPE='P');