orcle
畅快的小世界
这个作者很懒,什么都没留下…
展开
-
一条sql搞定ORA-28000: the account is locked 错误
...原创 2021-05-24 15:10:18 · 217 阅读 · 0 评论 -
oracle数据库创建的dblink及同义词
1.Oracle XE版 监听listener.ora配置SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server) (PROGRAM = extproc) ...原创 2018-02-26 18:02:37 · 737 阅读 · 0 评论 -
oracle 创建dblink 及同义词
//创建(与统一认证产生)linkcreate public database link UCENTER_LINKconnect to "单点用户名" identified by "单点密码"using '(DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = "数据库IP")(PORT = 1521)))(C...原创 2018-04-25 09:27:47 · 205 阅读 · 0 评论 -
oracle 树形结构查询sql
select t.id, t.name_v,t.pid, level from t_resource_type t start with t.pid= '-1' connect by prior t.id = t.pid解析:select 列 from 表名 start with 根节点限定条件 connect by prior 连接条件(注1) where 总体过滤条件注1: ...原创 2018-07-09 13:47:01 · 362 阅读 · 0 评论 -
计算天、周、月sql
实际应用中举例selectsum(decode(SUBSTR(TO_CHAR(CREATE_DATE, 'yyyy-MM-dd'),0,10),TO_CHAR (SYSDATE, 'yyyy-MM-dd'),1,0)) AS "sumOfficeDay",sum(decode(SUBSTR(TO_CHAR(CREATE_DATE, 'yyyy-MM-dd'),0,10),TO_CHAR (SY...原创 2018-07-09 13:49:50 · 387 阅读 · 0 评论 -
使用触发器、存储过程、定时器生成当天流程号
实际应用中举例:触发器declare dataCount integer(6);begin IF length(:new.office_number) !=15 THEN SELECT ONE into dataCount FROM trigger_data; UPDATE trigger_data SET ONE = dataCount + 1; :new.o...原创 2018-07-09 14:00:56 · 205 阅读 · 0 评论