velll/NOT_NULL_IS_NOT_TRUE.sql

Created April 17, 2017 11:24

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/velll/85990d4b3952edfa4c7e4c5bb143f644.js"></script>
Save velll/85990d4b3952edfa4c7e4c5bb143f644 to your computer and use it in GitHub Desktop.

Download ZIP

IF NOT AND NULL

Raw

NOT_NULL_IS_NOT_TRUE.sql


	DECLARE
	BEGIN
	IF NOT (1 = NULL) THEN
	RAISE_APPLICATION_ERROR(-20100, 'Not works!');
	END IF;
	-- it's not working obviously
	END;
	/

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment