[color=red][b]1.分页[/b][/color]
select * from (select rownum r from test1 where rownum<=20) t where t.r>=10
[color=red][b]2. 如何查询Oracle 编码格式 [/b][/color]
select value from nls_database_parameters where parameter='NLS_CHARACTERSET';
[color=red][b]3.查询Oracle的版本[/b][/color]
select banner from sys.v_$version;
select * from (select rownum r from test1 where rownum<=20) t where t.r>=10
[color=red][b]2. 如何查询Oracle 编码格式 [/b][/color]
select value from nls_database_parameters where parameter='NLS_CHARACTERSET';
[color=red][b]3.查询Oracle的版本[/b][/color]
select banner from sys.v_$version;