Tag: databases

v$timezone_names

v$timezone

user_timezone_names

dba_timezone_names

tz_offse

sessiontimezone

systemstamp

sysdate

multiply_months(x,y)

add_months(x,y)

devide_months(x,y)

upper(x)

last_day(x)

next_day(x)

first_day(x)

1 & 3

1 & 2

2 & 3

divert

convert

straight

revert

compose

decompose

translate

retranslate

colesce

coalesce

coalsce

coalese

multiply_months(x,y)

add_months(x,y)

devide_months(x,y)

upper(x)

SQL*Plus installed on the PC

Oracle Net on the PC

HTTP Server

iSQL*Plus Server

SELECT *

FROM emp

WHERE comm = NULL

There is no error in this statement.