Which of the following is not a numeric function ?
Which statements are true about Character Function ?
What will be output of the following
SELECT POWER(2,2), POWER(-2,2), POWER(2,-2) FROM Dual;
What will be output of the following ?
SELECT FLOOR(18.7), FLOOR(-18.7), FLOOR(0) FROM Dual;
SELECT TRUNC(12345, -2), TRUNC(12.345,2),TRUNC(12.345,3) FROM Dual;
SELECT UPPER('BullRaider quiz') my_length FROM Dual;
What will be output of the following ? SELECT SUBSTR('Bull Raider Quiz',1,3) as quiz from dual;
Which of the following functions show current date only ?
Which of the following are aggregate functions ?
Which of the following clause cab be used both SQL and PLSQL statement ?