lakhan

  
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