hi all,
HR.@.testdb > select banner from v$version;
BANNER
----------------------------------------------------------
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for 64-bit Windows: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
assigned a task to access an API through Web Service in Oracle and get XML data (which include Images) in DB via Oracle Forms 10g. ( data is of NIC (National Identity Card) ). I have no knowledge for all of these requirements, so requesting seniors here to help me.
some columns will contain data in Urdu Language and I have to convert it in English before insert in DB via google API
a column Expiry Date will also contain like "Life Time" and others, in case of this string, I have to convert in date to Date of Birth + 100 years at least.
regards