Posts by Leo • 51 points
2 posts
-
1
votes1
answer353
viewsA: Trigger prevents table change
Trigger would look like this. CREATE OR REPLACE TRIGGER NOME_DA_TRIGGER BEFORE INSERT OR UPDATE ON TRIPULACAO FOR EACH ROW DECLARE V_JAEXISTE NUMBER; BEGIN SELECT 1 INTO V_JAEXISTE FROM TRIPULACAO T…
-
4
votes4
answers10668
viewsA: How to create a Boolean column on Oracle?
NUMBER (0/1) is the default. Frames like Entityframework, Nhibernate, Dapper, etc., identify by default when running a command in the Oracle database, that 0 = false and 1 = true.