Oracle
wyzyysw
不可结缘,徒增悲喜,心虽有所觉,但亦作不解
展开
-
Oracle获取条件为当天的数据
SQLSELECT * FROM 表名 WHERE 字段名 between to_date(to_char(sysdate,'yyyy-mm-dd') || ' 00:00:01','yyyy-mm-dd hh24:mi:ss') andto_date(to_char(sysdate,'yyyy-mm-dd') || ' 23:59:59','yyyy-mm-dd hh24:mi:ss');参考文章转载 2021-02-18 13:59:20 · 288 阅读 · 0 评论 -
oracle安装后listener.ora文件和tnsnames.ora文件
# listener.ora Network Configuration File: E:\app\23694\product\11.2.0\dbhome_1\network\admin\listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = E:\a原创 2021-02-07 17:17:51 · 333 阅读 · 1 评论