1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
| SQL> set linesize 500
SQL> select ename, job, sal, comm, nvl(to_char(comm), 'cadre') as nvl from scott.emp;
ENAME JOB SAL COMM NVL
---------- --------- ---------- ---------- ----------------------------------------
SMITH CLERK 800 cadre
ALLEN SALESMAN 1600 300 300
WARD SALESMAN 1250 500 500
JONES MANAGER 2975 cadre
MARTIN SALESMAN 1250 1400 1400
BLAKE MANAGER 2850 cadre
CLARK MANAGER 2450 cadre
SCOTT ANALYST 3000 cadre
KING PRESIDENT 5000 cadre
TURNER SALESMAN 1500 0 0
ADAMS CLERK 1100 cadre
ENAME JOB SAL COMM NVL
---------- --------- ---------- ---------- ----------------------------------------
JAMES CLERK 950 cadre
FORD ANALYST 3000 cadre
MILLER CLERK 1300 cadre
14 rows selected.
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
SQL> |
