Tutorial by Examples

The following example returns the current operating system date and time

select sysdate from dual

The following example generates numbers between start_value and end_value

select :start_value + level -1 n from dual connect by level <= :end_value - :start_value + 1

Page 1 of 1

logo rip
SUPPORT & PARTNERS
STAY CONNECTED

Get monthly updates about new articles, cheatsheets, and tricks.