摘要:
在SQLPLUS下,实现中-英字符集转换 alter session set nls_language='AMERICAN'; alter session set nls_language='SIMPLIFIED CHINESE'; 主要知识点: 一、有关表的操作 1)建表 create table test as select * from dept; --从已知表复制数据和结构 create... 阅读全文
摘要:
SELECT * FROM tablename WHERE ENTRY_ID IN ( SELECT ENTRY_ID FROM tablename GROUP BY ENTRY_ID HAVING COUNT(*)>1) 或者 select * from tablename t1 where exists (select 1 from tablename t2 where t1.ENTRY... 阅读全文
摘要:
spl> select * from emp where dates between to_date('2007-06-12 10:00:00', 'yyyy-mm-dd hh24:mi:ss') and to_date('2007-06-12 10:00:00', 'yyyy-mm-dd hh24:mi:... 阅读全文