oracle
万德佛
个人笔记与经验!!仅供参考
展开
-
Oracle时间范围查询
select * from sj.g_wip_sn_detail g where g.d_t between to_date('2020-07-03 08:00:00', 'YYYY-MM-DD hh24:mi:ss') and to_date('2020-07-04 08:00:00', 'YYYY-MM-DD hh24:mi:ss') and g.report_name = 'CIT' order by g.d_t desc;原创 2020-07-03 18:44:37 · 6100 阅读 · 0 评论 -
cmd 用命令连接oracle数据库
这里所用的数据库在tnsnames.ora里的配置:mesdb155 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = IP地址)(PORT = 端口号)) (CONNECT_DATA = (SERVER = XXX) (SERVICE_NAME = XXX) ) )首先检测环境是否配置...原创 2018-06-04 11:42:30 · 24718 阅读 · 3 评论