Write a PL/SQL block to create a procedure using the "IS [NOT] NULL Operator" and show OR operator returns TRUE if either operand is TRUE
- pl/sql
- 2021-09-26
- mhanasmh00489829403
الأجوبة
PL/SQL Code:
CREATE OR REPLACE PROCEDURE pri_bool(
boo_name VARCHAR2,
boo_val BOOLEAN
) IS
BEGIN
IF boo_val IS NULL THEN
DBMS_OUTPUT.PUT_LINE( boo_name || ' = NULL');
ELSIF boo_val = TRUE THEN
DBMS_OUTPUT.PUT_LINE( boo_name || ' = TRUE');
ELSE
DBMS_OUTPUT.PUT_LINE( boo_name || ' = FALSE');
END IF;
END;
/
Now call the procedure pri_bool:
PL/SQL Code:
DECLARE
PROCEDURE pri_m_or_n (
m BOOLEAN,
n BOOLEAN
) IS
BEGIN
pri_bool ('m', m);
pri_bool ('n', n);
pri_bool ('m OR n', m OR n);
END pri_m_or_n;
BEGIN
DBMS_OUTPUT.PUT_LINE('------------- FOR m OR n both FALSE ---------------------');
pri_m_or_n (FALSE, FALSE);
DBMS_OUTPUT.PUT_LINE('------------- FOR m TRUE OR n FALSE ---------------------');
pri_m_or_n (TRUE, FALSE);
DBMS_OUTPUT.PUT_LINE('------------- FOR m FALSE OR n TRUE ---------------------');
pri_m_or_n (FALSE, TRUE);
DBMS_OUTPUT.PUT_LINE('------------- FOR m TRUE OR n TRUE ---------------------');
pri_m_or_n (TRUE, TRUE);
DBMS_OUTPUT.PUT_LINE('------------- FOR m TRUE OR n NULL ---------------------');
pri_m_or_n (TRUE, NULL);
DBMS_OUTPUT.PUT_LINE('------------- FOR m FALSE OR n NULL---------------------');
pri_m_or_n (FALSE, NULL);
DBMS_OUTPUT.PUT_LINE('------------- FOR m NULL OR n TRUE ---------------------');
pri_m_or_n (NULL, TRUE);
DBMS_OUTPUT.PUT_LINE('------------- FOR m NULL OR n FALSE ---------------------');
pri_m_or_n (NULL, FALSE);
END;
/
Sample Output:
------------- FOR m OR n both FALSE --------------------- m = FALSE n = FALSE m OR n = FALSE ------------- FOR m TRUE OR n FALSE --------------------- m = TRUE n = FALSE m OR n = TRUE ------------- FOR m FALSE OR n TRUE --------------------- m = FALSE n = TRUE m OR n = TRUE ------------- FOR m TRUE OR n TRUE --------------------- m = TRUE n = TRUE m OR n = TRUE ------------- FOR m TRUE OR n NULL --------------------- m = TRUE n = NULL m OR n = TRUE ------------- FOR m FALSE OR n NULL--------------------- m = FALSE n = NULL m OR n = NULL ------------- FOR m NULL OR n TRUE --------------------- m = NULL n = TRUE m OR n = TRUE ------------- FOR m NULL OR n FALSE --------------------- m = NULL n = FALSE m OR n = NULL
أسئلة مشابهة
القوائم الدراسية التي ينتمي لها السؤال
معلومات ذات صلة