oracle
嘻哈玩java
正能量玩代码,帮助更多喜欢代码的人
展开
-
防sql注入的oracle函数
CREATE OR REPLACE TYPE str_split IS TABLE OF VARCHAR2 (4000); CREATE OR REPLACE FUNCTION splitstr(p_string IN VARCHAR2, p_delimiter IN VARCHAR2) RETURN str_split PIPELINED AS str1 va原创 2018-02-01 11:58:59 · 546 阅读 · 0 评论 -
oracle左连接、有连接+分页查询(区间查询)
select * from (select t.* ,ROWNUM as rn from (SELECT b.FNAME_L2,c.FALIAS_L2 FROM T_PM_RolePerm a left join T_PM_Role b on b.FID =a.FROLEID left join T_PM_PermItem c on a.FPERMITEMID =c.fid where ...原创 2018-02-28 17:31:55 · 1367 阅读 · 0 评论