Why do we need to use DELIMITER $$ in pl/pgsql? Is this important like terminator in other programming languages (eg. semicolon ";" in PHP)?
Asked
Active
Viewed 813 times
0
Erwin Brandstetter
- 539,169
- 125
- 977
- 1,137
-
Are you talking about MySQL? (PL/SQL is Oracle server's procedure language and doesn't use `DELIMITER`) – Mat Dec 13 '13 at 06:12
-
we can use in oracle but it is not mandatory.Thanks Mat – Dec 13 '13 at 06:26
-
`DELIMITER` isn't a keyword in Oracle. Where did you see that you can use it? – Mat Dec 13 '13 at 06:27
-
i am not export in oracle but i can DELIMITER is also valid in oracle. – Dec 13 '13 at 06:37