随笔分类 -  database

plsql pipe
摘要：create or replace type Arr as table of varchar2(500);create or replace function getApproverByRole2(busi_dept_id IN NUMBER, role_code IN VARCHAR2) RETU 阅读全文

posted @ 2020-03-13 22:42 rigidwang 阅读(160) 评论(0) 推荐(0)

CentOS7 安装 oracleXE（快捷版）教程
摘要：https://blog.csdn.net/qq_26820293/article/details/78566063 plsql登入： 1. 设置本机环境变量 NLS_LANG SIMPLIFIED CHINESE_CHINA.ZHS16GBK 阅读全文

posted @ 2018-09-15 11:11 rigidwang 阅读(389) 评论(0) 推荐(0)

postgre 导入sql文件
摘要：C:\Users\wang>psql -U poem poem < D:\db_schema.sql 阅读全文

posted @ 2017-08-01 14:54 rigidwang 阅读(303) 评论(0) 推荐(0)