ERPstuff - Oracle EBS Community

BEGIN EXECUTE IMMEDIATE 'DROP TABLE ERPSTUFF_EMPS'; EXECUTE IMMEDIATE 'DROP TABLE ERPSTUFF_DEPTS'; EXCEPTION WHEN OTHERS THEN NULL; END; / CREATE TABLE "ERPSTUFF_EMPS" ( "EMPNO" NUMBER(4,0) GENERATED BY DEFAULT ON NULL AS IDENTITY MINVALUE 1 MAXVALUE 90000 INCREMENT BY 10 START ...

function js_authentication ( p_username in varchar2, p_password in varchar2 ) return boolean is l_user my_users.user_name%type := upper(p_username); l_id my_users.id%type; l_hash my_users.password_hash%type; begin begin select id , password_hash into l_id, l_hash from my_users where user_name = l_us...

This way field will be readonly while stillyou can assign values using code etc.

readonly="true"

Pictures are always of different diminsions and if you need to display them in a fixed size in Interactive/Classic Reports then enter following code in the page Inline, td[headers="PHOTO"] img { display: block; width: 60px; } here "PHOTO" is your column name of reports query.

Oracle APEX - Commenting Tips & Tricks The commenting feature in Oracle Application Express (APEX) allows developers to add notes or explanations to their code. This can be helpful for collaboration, debugging, or just keeping track of what different parts of the code do. Oracle PL/SQL Developer...

1-3 Primary Oracle DBA Duties: Oracle 12/19c administration and support (on-prem or cloud) Oracle Patch Management Coordination and implementation Oracle backup and recovery planning/testing Provide infrastructure support at all levels and after hours support as needed Coordinate Oracle DB work wit...

function(config) { config.reportSettingsArea = false; // may want to disable the highlights feature. Comment out this code to make initial highlight settings apex.util.getNestedObject(config, "views.grid.features").highlight = false; return config; } IG color.jpg IG color2.jpg

1. Assing a static ID like PHOTO_BLOB to your image field and type of this field should be Display Image.
2. In the page inline CSS following code,

td[headers="PHOTO_BLOB"] img {width: 64px;}

Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders

https://apex.oracle.com/pls/apex/r/apex ... -modifiers

APEX_UTIL.GET_SINCE (
p_date DATE )
p_short IN [ BOOLEAN DEFAULT FALSE | VARCHAR2 DEFAULT 'N' ] )
RETURN VARCHAR2;

select application_id, application_name,apex_util.get_since(last_updated_on) last_update
from apex_applications
order by application_id

Sample output,

In Autonomous database if you are unable to delete application "Restricted workspace may not perform this action" as an admin then you can use following script,

begin
wwv_flow_api.remove_flow(101);
end;

"CREATED_BY" VARCHAR2(15),
"CREATION_DATE" DATE,
"LAST_UPDATED_BY" VARCHAR2(15),
"UPDATION_DATE" DATE,

@apexins1.sql SYSAUX SYSAUX TEMP /i/ @apexins2.sql SYSAUX SYSAUX TEMP /i/ @apexins3.sql SYSAUX SYSAUX TEMP /i/ Copy and Replace images in the web folder /i @catpatch BEGIN DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE( host => '*', ace => xs$ace_type(privilege_list => xs$name_list('connect'), principal_nam...

Please share some sample data for better understanding. thanks