create or replace procedure QueryPagedTable(order_ in nvarchar2,)
is
newSql nvarchar2(2000);
begin
newSql := '';
IF (Length(Order_) > 0) THEN
newSql := 'select * from 表名 order by '||order_;
ELSE
newSql := 'select * from 表名 order by "id"';
end if;
--exec newSql;
Dbms_Output.put_line(newSql);
end QueryPagedTable;
