vanigreat

 Profile Answers by vanigreat 

• Jan 17th, 2008

 

select sysdate from dual connect by level <=n

vanigreat

 Profile Answers by vanigreat 

• Jan 17th, 2008

 

select sysdate from dual connect by level <=25

krishnaindia2007

 Profile Answers by krishnaindia2007 

• Jun 21st, 2008

 

select sysdate from user_tables where rownum <=50;

Here you can use any table name that contains more than 50 rows.

rpsingh

 Profile Answers by rpsingh 

• Jun 21st, 2008

 

select sysdate from dual;