21 July 2016

How to Change/View Applet Windows Title in Oracle EBS

System Administrator responsibility and navigate to Profile > System, search for the profile name "Site Name"

To see the value what was set,

SQL :

SELECT v.profile_option_value   FROM apps.fnd_profile_option_values v, apps.fnd_profile_options n  WHERE v.profile_option_id = n.profile_option_id AND n.profile_option_name LIKE 'SITENAME%'


To see database creation date, 

SQL

 SELECT created
from V$DATABASE;

20 July 2016

Oracle SQL Developer : Formatting Query Results to CSV/xml/html/json

Add hint to sql in the below format to get custom and run in execute mode (F5)

SELECT /*csv*/ * FROM scott.emp;
SELECT /*xml*/ * FROM scott.emp;
SELECT /*html*/ * FROM scott.emp;
SELECT /*delimited*/ * FROM scott.emp;
SELECT /*insert*/ * FROM scott.emp;
SELECT /*loader*/ * FROM scott.emp;
SELECT /*fixed*/ * FROM scott.emp;
SELECT /*text*/ * FROM scott.emp;
SELECT /*json*/ * FROM scott.emp;

or

SET SQLFORMAT csv
SET SQLFORMAT json

Oracle SQL Developer ShortCuts