Which three tasks can be performed using SQL functions built into Oracle Database?

Which three tasks can be performed using SQL functions built into Oracle Database?

Which three tasks can be performed using SQL functions built into Oracle Database?

A.
Displaying a date in a nondefault format

B.
Finding the number of characters in an expression

C.
Substituting a character string in a text expression with a specified string

D.
Combining more than two columns or expressions into a single column in the output

Explanation:

Show Hint

Leave a Reply 4

Your email address will not be published. Required fields are marked *

Marcelo Thomaz

Marcelo Thomaz

You can’t combining more than two columns into a single columns in the output with function builds by Oracle.

Reply

Sayed

Sayed

Yes. D is wrong. The CONCAT function can combine only two columns. However, we can concatenate more than two column by using ||.

Reply

Michal

Michal

How come? Can’t you just use CONCAT(str1,CONCAT(str2,str3))?

Reply

Amit

Amit

Hi Guys,

I’m doing preparation for Oracle Database 12c: sql fundamentals, so i have need some dump copies for it. if you guys have any idea about Oracle Databse 12c: sql fundamentals then please send me at [email protected] ..

Thanks,
Amit

Reply