gbase数据、南大通用产品文档：GBase8a:2181,1921686179:2181,1921686180:2181 topic test

hello world
如上所示，
在生产者终端输入hello world 并回车，
可以在消费者终端看到hello world
输出。
创建Topic
步骤1
启动Kafka 服务，创建两个Topic，均在goldengate 接收端的kafka.props 中指定了。

[root@v178 ogg]# $kafka_home/bin/kafka-topics.sh --zookeeper

gbase_fetch_row
..............................
16

这个示例将搜寻CASE表达式的值赋给变量appraisal。
DECLARE
grade CHAR(1) := 'B';
appraisal VARCHAR2(120);
id NUMBER := 8429862;
attendance NUMBER := 150;
min_days CONSTANT NUMBER := 200;
FUNCTION attends_this_school (id NUMBER) RETURN BOOLEAN IS
BEGIN
RETURN TRUE;
END;
BEGIN
appraisal :=
CASE
WHEN attends_this_school(id) = FALSE
THEN 'Student not enrolled'
WHEN grade = 'F' OR attendance < min_days

GBase 8s PL/SQL手册
南大通用数据技术股份有限公司
- 38 -

THEN 'Poor (poor performance or bad attendance)'
WHEN grade = 'A' THEN 'Excellent'
WHEN grade = 'B' THEN 'Very Good'
WHEN grade = 'C' THEN 'Good'
WHEN grade = 'D' THEN 'Fair'
ELSE 'No such grade'
END;
DBMS_OUTPUT.PUT_LINE('Result for student ' || id || ' is ' || appraisal);
END;

--Result:
--Result for student 8429862 is Poor (poor performance or bad attendance)