Valid time zone names can be found in ....
v$timezone_names
v$timezone
user_timezone_names
dba_timezone_names
Which function will take input parameter...?
tz_offse
sessiontimezone
systemstamp
sysdate
Which one is date function of Oracle...?
multiply_months(x,y)
add_months(x,y)
devide_months(x,y)
upper(x)
Which one is date function of oracle....?
last_day(x)
next_day(x)
first_day(x)
1 & 3
1 & 2
2 & 3
Which one is oracle function....?
divert
convert
straight
revert
which one is not a function in oracle....?
compose
decompose
translate
retranslate
find the correct usage....
colesce
coalesce
coalsce
coalese
Which components are required to run iSQL*Plus from your PC? (Choose all that apply.)
SQL*Plus installed on the PC
Oracle Net on the PC
HTTP Server
iSQL*Plus Server
Which line of the following code has an error? SELECT * FROM emp WHERE comm = NULL ORDER BY ename;
SELECT *
FROM emp
WHERE comm = NULL
There is no error in this statement.