How many types of procedures are there in MariaDB database?

devquora
devquora

Posted On: Feb 22, 2018

 

There are 3 types of procedures in MariaDB database on the basis of references and parameter overwritten. These are

  • IN procedure- In this type of procedure, the values of a parameter can be overwritten and referenced by the procedure.
  • OUT procedure- In this type of procedure, the values of parameter can be overwritten by the procedure but it can’t be referenced by a procedure.
  • IN OUT- In this type of procedure, the values of a parameter can be referenced by the procedure but it can’t be overwritten by a procedure.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    MariaDB Interview Questions

    What do you understand by the MariaDB?

    MariaDB is developed by MySQL developers. It is a popular public source under GNU GPL which is related to database management technology...

    MariaDB Interview Questions

    Mention some characteristics of MariaDB?

    It has a lot of unique features that make it more useful and wonderful to work over it than MySQL. Some features are:..

    MariaDB Interview Questions

    Which command is used to delete the table in MariaDB’s database?

    The command DROP TABLE is used to delete the table in MariaDB’s database...