Questões de Concurso Comentadas para mjsp

WITH salario_sup AS

(

SELECT cargo, valor FROM SALARIO WHERE valor > 1000

)

SELECT * FROM salario_sup;

CURSOR salario_sup AS

(

SELECT cargo, valor FROM SALARIO WHERE valor > 1000

);

SELECT INTO salario_sup

(

SELECT cargo, valor FROM SALARIO WHERE valor > 1000

);

INSERT salario_sup

(

SELECT cargo, valor FROM SALARIO WHERE valor > 1000

);

SELECT cargo, valor

FROM SALARIO

WHERE valor > 1000;

CREATE [OR REPLACE]

<object_name> AS OBJECT (…);

CREATE [OR REPLACE] TYPE

<type_name> AS OBJECT (…);

CREATE [OR REPLACE] TABLE

<type_table> AS OBJECT (…);

CREATE [OR REPLACE]

<object_name> INTO OBJECT (…);

CREATE [OR REPLACE] OBJECT