Which of the following is a valid SQL statement? a. SELECT TRUNC (ROUND (125.38, 1), 0) FROM

Question:

Which of the following is a valid SQL statement?

a. SELECT TRUNC (ROUND (125.38, 1), 0) FROM dual;

b. SELECT ROUND (TRUNC (125.38, 0)

FROM dual;

c. SELECT LTRIM(LPAD (state, 5, ' '), 4, -3, "*")

FROM dual;

d. SELECT SUBSTR (ROUND (14.87, 2, 1), -4, 1)

FROM dual;

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Oracle 12c SQL

ISBN: 978-1305251038

3rd edition

Authors: Joan Casteel

Question Posted: