reset password
Author Message
304449449
Posts: 10
Posted 12:50 May 02, 2016 |

Hello Dr Sun

I have a doubt related to functions and triggers. can we use logical operators in conditional statements just like how we do in java "if(a && b)" something like this?

 

Thank You

Sumanth Shankar

cysun
Posts: 2935
Posted 12:53 May 02, 2016 |

Sure, but it's like in SQL rather than in Java. For example, you can do

if l_name = 'joe' and l_graduation_date is not null then
...
end if;
304449449
Posts: 10
Posted 13:19 May 02, 2016 |

Thanks a lot Dr sun for ur reply