medium,
10.2.0.4
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for 32-bit Windows: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
SQL> select pr.*
2 from
3 (
4 select 1 id
5 , null person_id
6 , case '2'
7 when '1'
8 THEN 'YES'
9 else 'NO'
10 end field1
11 from dual d
12 )
13 p
14 left join
15 (
16 select 1 id, null || '.' fio from dual
17 )
18 Pr
19 ON Pr.ID = p.Person_ID;
ID F
---------- -
SQL> select pr.*
2 from
3 (
4 select 1 id
5 , null person_id
6 /*, case '2'
7 when '1'
8 THEN 'YES'
9 else 'NO'
10 end field1*/
11 from dual d
12 )
13 p
14 left join
15 (
16 select 1 id, null || '.' fio from dual
17 )
18 Pr
19 ON Pr.ID = p.Person_ID;
ID F
---------- -
11.2.0.1
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
SQL> select pr.*
2 from
3 (
4 select 1 id
5 , null person_id
6 , case '2'
7 when '1'
8 THEN 'YES'
9 else 'NO'
10 end field1
11 from dual d
12 )
13 p
14 left join
15 (
16 select 1 id, null || '.' fio from dual
17 )
18 Pr
19 ON Pr.ID = p.Person_ID;
ID F
---------- -
SQL> select pr.*
2 from
3 (
4 select 1 id
5 , null person_id
6 /*, case '2'
7 when '1'
8 THEN 'YES'
9 else 'NO'
10 end field1*/
11 from dual d
12 )
13 p
14 left join
15 (
16 select 1 id, null || '.' fio from dual
17 )
18 Pr
19 ON Pr.ID = p.Person_ID;
ID F
---------- -
11.2.0.2
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for 32-bit Windows: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
SQL> select pr.*
2 from
3 (
4 select 1 id
5 , null person_id
6 , case '2'
7 when '1'
8 THEN 'YES'
9 else 'NO'
10 end field1
11 from dual d
12 )
13 p
14 left join
15 (
16 select 1 id, null || '.' fio from dual
17 )
18 Pr
19 ON Pr.ID = p.Person_ID;
ID F
---------- -
1 .
SQL> select pr.*
2 from
3 (
4 select 1 id
5 , null person_id
6 /*, case '2'
7 when '1'
8 THEN 'YES'
9 else 'NO'
10 end field1*/
11 from dual d
12 )
13 p
14 left join
15 (
16 select 1 id, null || '.' fio from dual
17 )
18 Pr
19 ON Pr.ID = p.Person_ID;
ID F
---------- -