Contents tagged with Oracle
-
Oracle Pragma Autonomous Transaction
CREATE FUNCTION FN_MYAPP_WS_LOGGERreturn VARCHAR2as PRAGMA AUTONOMOUS_TRANSACTION;BEGIN
/* needs grant select on v$session (or any dictionary), but not via role */INSERT INTO MYAPP_WS_LOGGERSELECT * … more
-
Oracle Basic Auditing
selectto_number(substr(dbms_session.unique_session_id,1,4),'XXXX') as mysid, sys_context('USERENV','SID') as my_current_session, sys_context('USERENV','SESSIONID') as my_audsid,sysdate as now, case … more
-
Oracle Auditing and Fine Grained Auditing (FGA)
https://technology.amis.nl/2005/09/26/select-trigger-in-oracle-database-introducing-fine-grained-auditing/
http://www.dba-oracle.com/t_audit_sql_select_statements.htm
http://www.dba-oracle.com/ … more
-
Consuming JDeveloper Oracle ADF Web Services
https://blogs.oracle.com/fadevrel/how-to-query-data-using-the-web-services-find-operation
-
Oracle Enterprise Manager Console: How to Recreate
the solution is simple, you have to unplug the network cable and start the console service ( you have to do it every time you want to start the console)
emctl start dbconsole
if console still … more
-
SQL Server Reporting Services Data Source Connecting String for Oracle Database
Type: OLE DB
Connection String: Provider= ORAOLEDB.Oracle; Data Source=<MyOracleDataseName> more
-
Oracle Discoverer Command Line Interface
https://docs.oracle.com/cd/E28280_01/bi.1111/b40108/ref.htm#BIDEU141 more
-
Oracle version control and change control products
http://www.dba-oracle.com/t_version_control_change_control.htm more
-
Oracle Point-In-Time-Recovery with RMAN
https://ss64.com/ora/rman_pitr_example.html:
There are many ways to restore a database using an RMAN backup - this example assumes you are running RMAN without a Catalog and are performing a … more
-
How to Use Sequences in Oracle JDeveloper
https://www.youtube.com/watch?v=bX-b3MAGX5w
https://www.youtube.com/watch?v=QIkwwdzYmJE
-
Choosing Between NOARCHIVELOG and ARCHIVELOG Mode
https://docs.oracle.com/cd/B28359_01/server.111/b28310/archredo002.htm#ADMIN11330 more
-
Setup Up Oracle Forms 11g on Windows 64-bit
Steps:
1) install java using jdk-6u45-windows-x64.exe.
2) install weblogic using wls1036_generic.jar (must use generic installer for x64), sourced from wls1036_generic.jar_V29856-01. Use java -jar … more
-
Oracle Forms Default TNSNames.ora Location
C:\Oracle\Middleware\asinst_1\config\tnsnames.ora
-
Oracle ADF Jdeveloper Log SQL Execution
https://techutils.in/blog/2015/04/10/see-exact-query-execution-in-oracle-adf/
http://www.catgovind.com/adf/how-to-debug-adf-application/
https://stackoverflow.com/questions/14337722/need-to-see- … more
-
Oracle ADF Jdeveloper Log SQL Execution
http://www.catgovind.com/adf/how-to-debug-adf-application/
https://stackoverflow.com/questions/14337722/need-to-see-exact-query-execution-in-oracle-adf
https://code.google.com/archive/p/log4jdbc/ … more
-
Oracle ADF JDeveloper: Filter Table on Transient Column
https://tompeez.wordpress.com/2012/06/17/jdeveloper-fitler-table-on-transient-column/ more
-
JDeveloper and Oracle ADF: Filter by transient fields of a table with View Criteria and ExecuteWithParams operation in ADF
http://www.virtual7.de/blog/2015/11/a-simple-filter-by-transient-fields-of-a-table-with-view-criteria-and-executewithparams-operation-in-adf/
-
JDeveloper Tutorials
http://download.oracle.com/otn_hosted_doc/jdeveloper/11gdemos/ADF112/ADF112.html
http://www.oracle.com/us/corporate/press/406155
-
ORA-20446: The owner of the job is not registered
execute MGMT_USER.MAKE_EM_USER('database_login'); more
-
Oracle Forms 12 Installation
http://oraclestalk.blogspot.com/2016/02/installing-oracle-forms-and-reports-12c.html
https://oracle-base.com/articles/12c/standalone-forms-builder-12c-installation-on-windows-1221
http:// … more