查询STUDENT表start到end行的数据
SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT NAME FROM STUDENT) A WHERE ROWNUM <= end) WHERE RN >= start;
查询STUDENT表的列数
select count( column_name )from user_tab_columns where table_name = 'STUDENT';
查询STUDENT表start到end行的数据
SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT NAME FROM STUDENT) A WHERE ROWNUM <= end) WHERE RN >= start;
查询STUDENT表的列数
select count( column_name )from user_tab_columns where table_name = 'STUDENT';