Soal Basis Data Oracle Case and Character Manipulation

Soal + Jawaban Basis Data Oracle Case and Character Manipulation - Berikut adalah soal latihan basis data oracle mengenai case dan character manipulation dengan jawaban lengkap.



1. What does the following SQL SELECT statement return?

SELECT UPPER( SUBSTR('Database Programming', INSTR('Database Programming','P'),20)) FROM dual;

PROGRAMMING



2. Which query selects the first names of the DJ