SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to reterive just those records where street type is st

va44725815Oct 17 2006 — edited Oct 19 2006

IDX ADDRESS_FORM

1152 326 GREAT EASTERN HIGHWAY
1158 CNR HAMILTON RD & CHARLOTTE ST
1159 34 WESTERN ROAD

SELECT IDX, ADDRESS_foRm FROM TEMP_AU_POI_INTERM WHERE instr(address_form,'ST') >0

MY CONCERN IS THAT I WANT TO REPLACE ST TO STREET JUST IN 2ND RECORD NOT IN FIRST AND THIRD BECASUE THESE ARE PART OF THE NAME WHILE I JUST WANT TO CHANGE STREET TYPE. I WANT TO WRITE A QUERY WHICH SHOULD GIVE ME THE BELOW OUTPUT.

1152 326 GREAT EASTERN HIGHWAY
1158 CNR HAMILTON RD & CHARLOTTE STREET
1159 34 WESTERN ROAD

TO CHANGE ST TO STREET JUST IN 2ND RECORD

THANKS

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 16 2006

Added on Oct 17 2006

18 comments

850 views