SóProvas

ID
3425764
Banca
IBFC
Órgão
TRE-PA
Ano
2020
Provas
Disciplina
Banco de Dados
Assuntos

Assinale, das alternativas abaixo, a única que identifica incorretamente, e especificamente no PL/SQL, um parâmetro das STORED PROCEDURES:

Alternativas
Comentários

  • IN identifica o parâmetro como sendo do tipo “entrada”. Existem também os parâmetros do tipo OUT e do tipo IN OUT

  • IN - The parameter can be referenced by the procedure or function. The value of the parameter can not be overwritten by the procedure or function.

    OUT - The parameter can not be referenced by the procedure or function, but the value of the parameter can be overwritten by the procedure or function.

    IN OUT - The parameter can be referenced by the procedure or function and the value of the parameter can be overwritten by the procedure or function.

    Fonte: oracle doc

    go @head

  • a-

    1) IN type parameter: These types of parameters are used to send values to stored procedures.

    2) OUT type parameter: These types of parameters are used to get values from stored procedures. This is similar to a return type in functions.

    3) IN OUT parameter: These types of parameters are used to send values and get values from stored procedures.

    https://plsql-tutorial.com/plsql-passing-parameters-procedure-function.htm