clear markdown compare help best fiddles feedback dbanow.uk
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2805490 fiddles created (40768 in the last week).

CREATE TABLE EMP(EMPNO NUMBER(4) CONSTRAINT PK_EMP PRIMARY KEY,ENAME VARCHAR2(10),JOB VARCHAR2(9),MGR NUMBER(4),HIREDATE DATE,SAL NUMBER(7,2),COMM NUMBER(7,2),DEPTNO NUMBER(2));
 hidden batch(es)


select * from EMP where JOB='PRESIDENT' /* 01-APR-21 06.31.51.678270 AM +02:00 */;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
 hidden batch(es)


select prev_sql_id from v$session where sid=sys_context('userenv','sid');
PREV_SQL_ID
5c0tty145sddp
 hidden batch(es)


update EMP set ENAME='LARRY ELLISON' where JOB='PRESIDENT' /* 01-APR-21 06.32.11.963644 AM +02:00 */;
 hidden batch(es)


select prev_sql_id from v$session where sid=sys_context('userenv','sid');
PREV_SQL_ID
0rac13hrmtrqm
 hidden batch(es)


select * from EMP where JOB='PRESIDENT' /* 01-APR-21 06.33.82.691464 AM +02:00 */;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
 hidden batch(es)


select prev_sql_id from v$session where sid=sys_context('userenv','sid');
PREV_SQL_ID
0c12g0mwq09va
 hidden batch(es)


update EMP set ENAME='LARRY PAGE' where JOB='PRESIDENT' /* 01-APR-21 06.35.66.5728590 AM +02:00 */;
 hidden batch(es)


select prev_sql_id from v$session where sid=sys_context('userenv','sid');
PREV_SQL_ID
g00g13fys2fqd
 hidden batch(es)


select * from EMP where JOB='PRESIDENT' /* 01-APR-21 06.41.26.238008094 AM +02:00 */;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
 hidden batch(es)


select prev_sql_id from v$session where sid=sys_context('userenv','sid');
PREV_SQL_ID
gcp12yf4n2r3c
 hidden batch(es)


update EMP set ENAME='BILL GATES' where JOB='PRESIDENT' /* 01-APR-21 06.30.35.4055430 AM +02:00 */;
 hidden batch(es)


select * from EMP where JOB='PRESIDENT' /* 01-APR-21 06.31.18.2381810 AM +02:00 */;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
 hidden batch(es)


select prev_sql_id from v$session where sid=sys_context('userenv','sid');
PREV_SQL_ID
azur3g4pr7mng
 hidden batch(es)


update EMP set ENAME='JEFF BEZOS' where JOB='PRESIDENT' /* 01-APR-21 06.45.35.4055430 AM +02:00 */;
 hidden batch(es)


select prev_sql_id from v$session where sid=sys_context('userenv','sid');
PREV_SQL_ID
4m4z0n7sadpm2
 hidden batch(es)


select * from EMP where JOB='PRESIDENT' /* 01-APR-21 06.51.00.0102180 AM +02:00 */;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
 hidden batch(es)


select prev_sql_id from v$session where sid=sys_context('userenv','sid');
PREV_SQL_ID
awss8rgcfkprm
 hidden batch(es)