How can we view sysdate for n number of times

rpsingh

 Profile Answers by rpsingh Questions by rpsingh

• Jun 21st, 2008

Select sysdate from dual;

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions 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.

Answer Question  Select Best Answer

vanigreat

 Profile Answers by vanigreat Questions by vanigreat

• Jan 17th, 2008

select (to_date('31/01/2008','dd/mm/rrrr')-to_date('01/01/2008','dd/mm/rrrr')+1) - (select count(days) from (selectto_char(to_date('01/01/2008','dd/mm/rrrr&...

Answer Question  Select Best Answer

Vamsikrishna Sudanagunta

• Nov 16th, 2022

Print first names and the last names of the artists who had zero sales or no sales?

Ekansh

• Jul 12th, 2022

Just add the ; in the end of quest :)

Answer Question  Select Best Answer