sql转成oracl,.net程序员可看
新亿 2010-11-16 04:29:40 一个oracle 的 sql 分页
SELECT * FROM
(
SELECT A.*, ROWNUM RN
FROM (SELECT * FROM TABLE_NAME) A
)
WHERE RN BETWEEN 21 AND 40
有朋友可以转成oracle存储过程的么
------------------------我们现在程序是.net的,数据库是sqlserver 所以想转
dbCommand = db.GetStoredProcCommand(CmsConfiguration.Common.StoredProc.ReturnPage);
db.AddInParameter(dbCommand, "Select", DbType.String, "SELECT * FROM " + CmsConfiguration.Membership.Table.User + where);
db.AddInParameter(dbCommand, "OrderBy", DbType.String, orderBy);
db.AddInParameter(dbCommand, "StartRow", DbType.Int32, startRow);
db.AddInParameter(dbCommand, "EndRow", DbType.Int32, endRow);