数据库
小小小书屋
每天收获一点点。。。
展开
-
cx_Oracle库连接oracle服务器报错:cx_Oracle.DatabaseError: ORA-12505:
cx_Oracle库连接oracle服务器报错:cx_Oracle.DatabaseError: ORA-12505:TNS:listener does not currently know of SID given in connect descriptor>>> dsn = Oracle.makedsn("127.0.0.1", 1521, "xxx") /...原创 2018-07-31 09:40:44 · 4474 阅读 · 0 评论 -
oracle数据库,根据rownum查询第m行到第n行数据
SELECT tableTwo.* FROM (SELECT ROWNUM as id,tableOne.* FROM 表名字 tableOne WHERE ROWNUM <n) tableTwo WHERE id >m原创 2018-09-07 16:27:51 · 3178 阅读 · 0 评论