Basic Oracle Concepts and Programming Question: Download Questions PDF
What Are the Logical Operations?
Answer:
PL/SQL supports 3 logical operations as shown in the following sample script:
PROCEDURE proc_comparison AS
x BOOLEAN := TRUE;
y BOOLEAN := FALSE;
res BOOLEAN;
BEGIN
res = x AND y;
res = x OR y;
res = NOT x;
-- more statements
END;
PROCEDURE proc_comparison AS
x BOOLEAN := TRUE;
y BOOLEAN := FALSE;
res BOOLEAN;
BEGIN
res = x AND y;
res = x OR y;
res = NOT x;
-- more statements
END;
Download Oracle Database Interview Questions And Answers
PDF
Previous Question | Next Question |
What Are the Numeric Comparison Operations? | How Many Categories of Data Types? |