![](https://img-blog.csdnimg.cn/20201014180756913.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库
eagle0728
这个作者很懒,什么都没留下…
展开
-
Oracle 中实现分页语句
select user_id,user_name,password,telephone,email,creat_datefrom ( select rownum rn,user_id,user_name,password,telephone,email,creat_date from ( select rownum rn,user_id,user...原创 2010-07-29 12:18:54 · 140 阅读 · 0 评论 -
Oracle 如何 查看 sid?
Oracle 如何 查看 sid?1在oracle的安装目录下,如D:\oracle\product\10.2.0\db_1\dbs,看文件名如SPFILEORCL.ORA,那么就是orcl,也就是说文件名字是 "SPFILE******.ORA ",那种的 "**** "就是SID2D:\oracle\product\10.2.0\oradata\SID文件夹......原创 2010-06-01 21:11:22 · 202 阅读 · 0 评论 -
lomboz_eclipse ---oracle 笔记
lomboz_eclipse (MyEclipse,JBuilder)JDBC(Java Database Connectivity)JDBC 简介(c,c++,java...) ---- (API for Oracle) -->Oracle(c,c++,java...) ---- (API for SQLServer) -->SQLServer(c,c++,java....原创 2010-06-02 21:51:34 · 123 阅读 · 0 评论 -
sqlServer 分页查询语句
String sql = "select top "+pageSize+" * from user_info where user_no not in(select top "+(pageNo-1)*pageSize+" user_no from user_info) order by user_no";原创 2010-09-05 13:28:57 · 86 阅读 · 0 评论