posted in Oracle  

-- 在 BEGIN 之前定义变量 v_smoke_flag 
-- 在 BEGIN 之前定义游标
cursor cur_smoke_flag is
    select smoke_flag
    from uw_apply_info uai, uw_apply_product uap
    where uai.apply_no = uap.apply_no
    and uap.product_code = p_product_info.product_code
    and uai.policy_no = p_policy_no;
    
-- 在 BEGIN 之后使用游标  v_smoke_flag可以不用定义 直接使用
open cur_smoke_flag;
fetch cur_smoke_flag into v_smoke_flag;
close cur_smoke_flag;
posted in Mac  

st=>start: 开始|past:>http://www.baidu.com
e=>end: 结束|future:>http://www.baidu.com
io11=>inputoutput: 输入用户名密码
sub11=>subroutine: 查询数据库子程序
cond11=>condition: db中是否有此用户密码
op11=>operation: 用户登录，进入业务逻辑
op1=>operation: My Operation|past
op2=>operation: Stuff|current
sub1=>subroutine: My Subroutine|invalid
cond=>condition: Yes
or No?|approved:>http://www.baidu.com
c2=>condition: Good idea|rejected
io=>inputoutput: catch something...|future

st->io11->sub11->cond11->
cond11(no, right)->io11
cond11(yes, left)->op11
op11->e

st=>start: Start
e=>end
io0=>inputoutput: 输入用户密码
op1=>operation: 查询db是否有此用户密码
sub1=>subroutine: 返回登录页面逻辑
cond=>condition: Yes or No?
io=>inputoutput: 输入你要购买的东西
    
st->io0->op1->cond
cond(yes)->io->e
cond(no)->sub1(right)->io0

st=>start: 开始|past
e=>end: 结束|future
io0=>inputoutput: 输入用户名密码
sub0=>subroutine: 查询db此用户名|past
op2=>operation: 结束之前|current
sub1=>subroutine: 返回登录页面逻辑|invalid
cond=>condition: 有无此用户?|approved
c2=>condition: 验证密码正误|rejected
io=>inputoutput: 输入想要购买的东西|future

st->io0->sub0(right)->cond
cond(yes, right)->c2
cond(no)->sub1(right)->io0
c2(yes)->io->e
c2(no)->op2->e
posted in Mac  

sequenceDiagram
    participant Alice
    participant Bob
    Alice->John: Hello John, how are you?
    loop Healthcheck
        John->John: Fight against hypochondria
    end
    Note right of John: Rational thoughts <br/>prevail...
    John-->Alice: Great!
    John->Bob: How about you?
    Bob-->John: Jolly good!