Société Galerie 7 - Maher NOUIRA - Ras Jebel - Tunisie

Installation et réparation parabole
Réparation et déblocage GSM
Réparation et vente matériels informatiques

Contact : Maher NOUIRA / nouira.maher@gmail.com

ADF 11g runtime files required for Tomcat

Here you find the list of ADF 11g runtime files:
adf-controller-api.jar
adf-controller-rt-common.jar
adf-controller.jar
adf-faces-databinding-rt.jar
adf-pageflow-dtrt.jar
adf-pageflow-fwk.jar
adf-pageflow-impl.jar
adf-pageflow-rc.jar
adf-richclient-api-11.jar
adf-richclient-impl-11.jar
adf-share-base.jar
adf-share-ca.jar
adf-share-support.jar
adflibfilter.jar
adflogginghandler.jar
adfm.jar
adfmweb.jar
cache.jar
commons-el.jar
db-ca.jar
dms.jar
dvt-faces.jar
dvt-jclient.jar
dvt-utils.jar
fmw_audit.jar
identitystore.jar
inspect4.jar
javatools-nodeps.jar
javax.management.j2ee_1.0.jar
jewt4.jar
jmxframework.jar
jmxspi.jar
jps-api.jar
jps-common.jar
jps-ee.jar
jps-internal.jar
jps-unsupported-api.jar
jsf-api.jar
jsf-ri.jar
jstl.jar
mdsrt.jar
ojdbc6.jar
oracle-el.jar
oraclepki.jar
org.apache.commons.beanutils_1.6.jar
org.apache.commons.collections_3.1.jar
org.apache.commons.logging_1.0.4.jar
osdt_cert.jar
osdt_core.jar
share.jar
standard.jar
trinidad-api.jar
trinidad-impl.jar
wls-api.jar
xercesImpl.jar
xmlef.jar
xmlparserv2.jar

A simple source code versionning for Oracle DB

To implement a simple control version source on oracle package, function and procedure, we need a table and a database trigger, so you can use and ameliore this tips :

• Create a table

CREATE TABLE CVS_[SCHEMA_NAME]
(
CHANGE_DATE DATE,
OWNER VARCHAR2(30 BYTE),
NAME VARCHAR2(30 BYTE),
TYPE VARCHAR2(20 BYTE),
LINE NUMBER,
TEXT VARCHAR2(4000 BYTE),
TERMINAL VARCHAR2(50 BYTE)
);

• Create a trigger

CREATE OR REPLACE TRIGGER TRG_CVS_[SCHEMA_NAME]
AFTER CREATE ON DATABASE
BEGIN
INSERT INTO CVS_[SCHEMA_NAME]
SELECT SYSDATE, OWNER, NAME, TYPE, LINE, TEXT
FROM DBA_SOURCE
WHERE OWNER = ORA_DICT_OBJ_OWNER
AND NAME = ORA_DICT_OBJ_NAME
AND TYPE = ORA_DICT_OBJ_TYPE
AND OWNER = [SCHEMA_NAME];
END TRG_CVS_[SCHEMA_NAME];