*************************************DATABASE CREATION*********************************************************************************************** DOWNLOAD LIFERAY PORTAL SCRIPTS FROM https://www.liferay.com/downloads/liferay-portal/available-releases Rename the file as liferay.sql put it let say in under c drive , so it will be located like this c:\liferay.sql from cmd dir c:\ SQLPLUS / AS SYSDBA @liferay.sql lportal lportal it will create the db ..after finishing go to sqlplus again to ggrant the below to lportal user SQLPLUS / AS SYSDBA grant create session to lportal; grant connect to lportal; grant resource to lportal; *******************************CONFIGURE WILDFLY TO CONNECT TO ORACLE DB ***************************************************************************************************** configure wildfly to connect to oracle db Download the driver: ojdbc[VERSION].jar Create subfolders [WILDFLY_HOME]/modules/system/layers/base/com/o...
-- please never put a comment starting with " / " as this character means execute the previous line BEGIN FOR i IN (SELECT us.sequence_name FROM USER_SEQUENCES us) LOOP EXECUTE IMMEDIATE 'drop sequence '|| i.sequence_name ||''; END LOOP; FOR i IN (SELECT ut.table_name FROM USER_TABLES ut) LOOP EXECUTE IMMEDIATE 'drop table '|| i.table_name ||' CASCADE CONSTRAINTS '; END LOOP; END; -- the following character executes the whole block of pl sql code /
let say we have s insurance xml data as a response of a web service and we want to expose this data as a complex structure data type to deal with it in SAP (the same like DOM parser in other programming languages) the xml data as below <?xml version="1.0" encoding="utf-8"?> <RequestResponse xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <Response> <TreatmentBasis>1</TreatmentBasis> <TreatmentClassification>1</TreatmentClassification> <MemberDetails> <Tag> <ID>1</ID> <Label>DOB</Label> <Value>05-Jun-2011</Value> <Type>Date</Type> </Tag> <Tag> ...
Comments
Post a Comment