Run Code  | API  | Code Wall  | Users  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

lakhan

Language: Layout:
absolute service time: 1,05 sec 
edit mode |  history  | discussion
   oracle version
1 Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
2 PL/SQL Release 11.2.0.2.0 - Production
3 CORE 11.2.0.2.0 Production
4 TNS for 64-bit Windows: Version 11.2.0.2.0 - Production
5 NLSRTL Version 11.2.0.2.0 - Production
   EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
1 7369 SMITH CLERK 7902 17.12.1980 00:00:00 812 NULL 20
2 7499 ALLEN SALESMAN 7698 20.02.1981 00:00:00 1612 300 30
3 7521 WARD SALESMAN 7698 22.02.1981 00:00:00 1250 500 30
4 7566 JONES MANAGER 7839 02.04.1981 00:00:00 2987 NULL 20
5 7654 MARTIN SALESMAN 7698 28.09.1981 00:00:00 1262 1400 30
6 7698 BLAKE MANAGER 7839 01.05.1981 00:00:00 2862 NULL 30
7 7782 CLARK MANAGER 7839 09.06.1981 00:00:00 2462 NULL 10
8 7788 SCOTT ANALYST 7566 19.04.1987 00:00:00 3012 NULL 20
9 7839 KING PRESIDENT NULL 17.11.1981 00:00:00 5012 NULL 10
10 7844 TURNER SALESMAN 7698 08.09.1981 00:00:00 1512 0 30
11 7876 ADAMS CLERK 7788 23.05.1987 00:00:00 1112 NULL 20
12 7900 JAMES CLERK 7698 03.12.1981 00:00:00 962 NULL 30
13 7902 FORD ANALYST 7566 03.12.1981 00:00:00 3012 NULL 20
14 7934 MILLER CLERK 7782 23.01.1982 00:00:00 1312 NULL 10
15 7521 WARD SALESMAN 7698 22.02.1981 00:00:00 1250 500 30
16 7369 SMITH CLERK 7902 17.12.1980 00:00:00 800 NULL 20
17 7499 ALLEN SALESMAN 7698 20.02.1981 00:00:00 1600 300 30
18 7566 JONES MANAGER 7839 02.04.1981 00:00:00 2975 NULL 20
19 7654 MARTIN SALESMAN 7698 28.09.1981 00:00:00 1250 1400 30
20 8001 NULL NULL NULL NULL NULL NULL 50
   ENAME SAL NVL(COMM,0) AN_SAL
1 SMITH 812 0 9744
2 ALLEN 1612 300 5822544
3 WARD 1250 500 7515000
4 JONES 2987 0 35844
5 MARTIN 1262 1400 21216744
6 BLAKE 2862 0 34344
7 CLARK 2462 0 29544
8 SCOTT 3012 0 36144
9 KING 5012 0 60144
10 TURNER 1512 0 18144
11 ADAMS 1112 0 13344
12 JAMES 962 0 11544
13 FORD 3012 0 36144
14 MILLER 1312 0 15744
15 WARD 1250 500 7515000
16 SMITH 800 0 9600
17 ALLEN 1600 300 5779200
18 JONES 2975 0 35700
19 MARTIN 1250 1400 21015000
20 NULL NULL 0 NULL