PL/SQL
DECLARE
TYPE <type_name> IS RECORD
(
<columnl> <datatype>,
);
BEGIN
<execution_section>;
END;PL/SQL
DECLARE
TYPE <type_name> IS RECORD
(
<columnl> <datatype>,
);
BEGIN
<execution_section>;
END;plsql not equal
SELECT 1 FROM dual
WHERE 1 != 2
OR 1 <> 2;
-- WARNING: the not equal operators do NOT check for NULL value:
-- myTable: ID(CHAR) | flag(NUMBER)
-- A 1
-- B 0
-- C NULL
SELECT ID FROM myTable t
WHERE t.flag != 1;
-- returns B
SELECT ID FROM myTable t
WHERE t.flag != 1 OR t.flag IS NULL;
-- returns B and CCopyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
