select sysdate from dual
| SYSDATE | 09-APR-18 |
|---|
select sysdate-1,sysdate,sysdate+1 from dual
| SYSDATE-1 | SYSDATE | SYSDATE+1 | 08-APR-18 | 09-APR-18 | 10-APR-18 |
|---|
select sysdate-1,sysdate,sysdate+1 from dual
| SYSDATE-1 | SYSDATE | SYSDATE+1 | 08-APR-18 | 09-APR-18 | 10-APR-18 |
|---|
select sysdate-1,sysdate,sysdate+1 from dual
| SYSDATE-1 | SYSDATE | SYSDATE+1 | 08-APR-18 | 09-APR-18 | 10-APR-18 |
|---|
select * from dual
| DUMMY | X |
|---|
select * from employee
ORA-00942: table or view does not existMore Details: https://docs.oracle.com/error-help/db/ora-00942
select sysdate-1,sysdate,sysdate+1 from dual
| SYSDATE-1 | SYSDATE | SYSDATE+1 | 08-APR-18 | 09-APR-18 | 10-APR-18 |
|---|