Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Srinivas
vert back changes of one insert statement. set serveroutput on; DECLARE rollno student.sno%type; snm student.sname%type; s_age student.age%type; s_cr student.course%type; BEGIN rollno := &sno; snm := '&sname'; s_age := &age; s_cr := '&course'; INSERT into student values(rollno,snm,age,course); dbms_output.put_line('One record inserted'); COMMIT; -- adding savepoint SAVEPOINT savehere; -- second time asking user for input rollno := &sno; snm := '&sname'; s_age := &age; s_cr := '&course'; INSERT into student values(rollno,snm,age,course); dbms_output.put_line('One record inserted'); ROLLBACK [TO SAVEPOINT savehere]; END;
run
|
edit
|
history
|
help
0
W
Práctica MySQL 2
test
act5
results of divide by zero in MySQL
farmaciacarnaru
Employee
Employee
Create Procedure For Getting Grades Through Student Id and Marks
ventas