PL/SQL


No comments:

Post a Comment

Subscribe to: Posts (Atom)

ORA-01436: CONNECT BY loop in user data

            SELECT CASE                      WHEN CONNECT_BY_ISLEAF = 1 THEN 0                      WHEN LEVEL = 1 THEN 1                   ...

  • Home
    Welcome to our blog. Our mission to learn and solve Oracle related problem.  Introduction to Oracle Oracle is a product from Oracle Corpo...
  • Various use of CASE statement
    Q.  Which query return different value? 1. SELECT CASE 0 WHEN 0 THEN 'A' ELSE 'B' END FROM DUAL; 2. SELECT CASE WHEN 0 ...
  • ORA-01436: CONNECT BY loop in user data
                SELECT CASE                      WHEN CONNECT_BY_ISLEAF = 1 THEN 0                      WHEN LEVEL = 1 THEN 1                   ...