Questões de Concurso Público MJSP 2020 para Analista de Governança de Dados - Big Data

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

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;