SELECT TO_CHAR(1890.55,'$99G999D00')FROM DUAL;

SELECT TO_CHAR(1890.55,'$9,999V99')FROM DUAL;

SELECT TO_CHAR(1890.55,'$0G000D00')FROM DUAL;

SELECT TO_CHAR(1890.55,'$99G999D99')FROM DUAL;

SELECT TO_CHAR(1890.55,'$9,999D99')FROM DUAL;

It produces an error because the ORDER BY clause should appear only at the end of a compound query-that is, with the last SELECT statement

It executes successfully and displays rows in the descending order of PROMO_CATEGORY

It executes successfully but ignores the ORDER BY clause because it is not located at the end of the compound statement

It produces an error because positional notation cannot be used in the ORDER BY clause with SET operators A

Both SQL and /SQL*plus allow manipulation of values in the database.

/SQL*Plus recognizes SQL statements and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.

/SQL*Plus is a language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.

SQL manipulates data and table definitions in the database; /SQL*Plus does not allow manipulation of values in the database.

string

character

integer

calendar

numeric

translation

date

conversion

MERGE INTO new_employees c USING employees e ON (c.employee_id = e.employee_id) WHEN MATCHED THEN UPDATE SET

name = e.first_name ||','|| e.last_name WHEN NOT MATCHED THEN INSERT value S(e.employee_id, e.first_name ||', '||e.last_name);

MERGE new_employees c USING employees e ON (c.employee_id = e.employee_id) WHEN EXISTS THEN UPDATE SET

name = e.first_name ||','|| e.last_name WHEN NOT MATCHED THEN INSERT valueS(e.employee_id, e.first_name ||', '||e.last_name);

MERGE INTO new_employees cUSING employees e ON (c.employee_id = e.employee_id) WHEN EXISTS THEN UPDATE SET

name = e.first_name ||','|| e.last_name WHEN NOT MATCHED THEN INSERT value S(e.employee_id, e.first_name ||', '||e.last_name);

MERGE new_employees c FROM employees e ON (c.employee_id = e.employee_id) WHEN MATCHED THEN UPDATE SET

name = e.first_name ||','|| e.last_name WHEN NOT MATCHED THEN INSERT INTO new_employees valueS(e.employee_id, e.first_name ||', '||e.last_name);