eagle0728的专栏

select user_id,user_name,password,telephone,email,creat_date from ( select rownum rn,user_id,user_name,password,telephone,email,creat_date from ( select rownum rn,user_id,user...

Oracle 如何 查看 sid？ 1 在oracle的安装目录下,如D:\oracle\product\10.2.0\db_1\dbs,看文件名如SPFILEORCL.ORA,那么就是orcl,也就是说文件名字是 "SPFILE******.ORA ",那种的 "**** "就是SID 2 D:\oracle\product\10.2.0\oradata\SID文件夹... ...

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....

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";