select lpad(3400,10,*) from dual returns

Keep practicing — related questions

• The output for the qyery "select lpad('sql functions',18,'*#$') from dual;" is
• select trunc(10,-1) from dual would results in?
• select trunc(760.5,-2) from dual returns
• what is the output: select mod(1600,300) from dual;
• SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;
• select '1'+'1' from dual ; The o/p would be..
• SELECT TRUNC(1234.5678,-2) FROM DUAL;
• select avg(dummy) from dual; o/p: