Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
TRIGGER
CREATE OR REPLACE TRIGGER display_changes AFTER UPDATE OF LASTNAME ON bharat DECLARE BEGIN dbms_output.put_line('display_changes is triggered'); END; INSERT INTO BHARAT (PERSONID,LASTNAME,FIRSTNAME,ADDRESS,CITY) VALUES (143,'V','SUBHA','YDFASVDDYFUG','TIRUCHI')\\ update BHARAT set LASTNAME='C' where PERSONID=123\\
run
|
edit
|
history
|
help
0
Srinivas
3
add pl/sql
Srinivas
Srinivas
if-else condition in pl/sql
pagination example
Factorial from SQL
6
minimum of two(replace)