A delimiter is a simple or compound symbol that has a special meaning to PL/SQL. For example, you use delimiters to represent arithmetic operations such as addition and subtraction.

What are delimiters in database?

In computer programming, a delimiter is a character that identifies the beginning or the end of a character string (a contiguous sequence of characters). … Delimiters can also be used to separate the data items in a database (the columns in the database table) when transporting the database to another application.

What is delimiter in SQL stored procedure?

You define a DELIMITER to tell the mysql client to treat the statements, functions, stored procedures or triggers as an entire statement. Normally in a . sql file you set a different DELIMITER like $$. The DELIMITER command is used to change the standard delimiter of MySQL commands (i.e. ;).