Hi ,
we have a table say x
| INDUSTRY_CODE | NOT NULL NUMBER(12,2) |
| INDUSTRY_NAME | NOT NULL VARCHAR2(75) |
Query 1:
select industry_code ,industry_name from x WHERE lower(industry_name) like 'nippon%'
2 ;
result:
=====
industry_code industry_name
------------ ---------------------------------------------------------------------------
14060009.1 Nippon Life Asset Management Ltd.
14020036 Nippon Life Insurance industry Ltd.
Query 2:
SQL> select * from x where industry_code=14060009.1;
no rows selected
what am i doing wrong here , How can i select data and get the correct result by passing industry_code from the result obtained by the first query