Oracle兼容-存储过程-匿名块

1. 语法

1. SET sql_mode = ORACLE;

3. 1. DECLARE
4. ...
5. BEGIN
6. ...
7. END;

9. 2. BEGIN
10. ...
11. END;

2. 定义和用法

在GreatSQL中支持类似Oracle风格的匿名块用法。

3. 示例

1. greatsql> SET sql_mode = ORACLE;
2. greatsql> DELIMITER //

4. greatsql> BEGIN
5. SELECT 'Hi GreatSQL';
6. END; //
7. +-------------+
8. | Hi GreatSQL |
9. +-------------+
10. | Hi GreatSQL |
11. +-------------+
12. 1 row in set (0.00 sec)

14. greatsql> DECLARE
15. a INT;
16. b INT;
17. BEGIN
18. a := 3306;
19. SELECT CONCAT('GreatSQL default port is:' , a);
20. END; //
21. +-----------------------------------------+
22. | CONCAT('GreatSQL default port is:' , a) |
23. +-----------------------------------------+
24. | GreatSQL default port is:3306           |
25. +-----------------------------------------+
26. 1 row in set (0.00 sec)

28. Query OK, 0 rows affected (0.00 sec)

问题反馈

联系我们

扫码关注微信公众号

greatsql-wx