fork download
  1. set serveroutput on
  2. create table employee (
  3. empno integer primary key,
  4. empname varchar2(20),
  5. salary decimal (9,2)
  6. );
  7. declare
  8. v_employee employee%rowtype;
  9. v_empno integer;
  10. v_empname varchar2(20);
  11. v_salary decimal(9,2);
  12. begin
  13. v_empno := &empno;
  14. v_empname:='&name';
  15. v_salary:=&salary;
  16. insert into employee values(v_empno,v_empname,v_salary);
  17. end;
  18. /
Success #stdin #stdout #stderr 0.01s 5320KB
stdin
Standard input is empty
stdout
Standard output is empty
stderr
Error: near line 1: near "set": syntax error
Error: near line 7: near "declare": syntax error
Error: near line 9: near "v_empno": syntax error
Error: near line 10: near "v_empname": syntax error
Error: near line 11: near "v_salary": syntax error
Error: near line 12: near "v_empno": syntax error
Error: near line 14: near "v_empname": syntax error
Error: near line 15: near "v_salary": syntax error
Error: near line 16: no such table: employee
Error: near line 17: cannot commit - no transaction is active