fork download
copy 
  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
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
stderr
copy 
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
https://ideone.com/SCCgFi
language:
SQLite (sqlite 3.27.2)
created:
3 days ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!