Search found 2062 matches

by admin
Tue Feb 28, 2023 9:17 am
Forum: Oracle APEX
Topic: Custom Authentication Function
Replies: 0
Views: 86899

Custom Authentication Function

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...
by admin
Thu Feb 16, 2023 4:16 am
Forum: Oracle APEX
Topic: Make field readonly using Custom Attributes
Replies: 0
Views: 87128

Make field readonly using Custom Attributes

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

readonly="true"
readonly.jpg
by admin
Mon Feb 13, 2023 10:32 am
Forum: Oracle APEX
Topic: Imange fixed size in Interactive/Classic Reports
Replies: 0
Views: 85142

Imange fixed size in Interactive/Classic Reports

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.
by admin
Wed Feb 08, 2023 10:18 am
Forum: Oracle APEX
Topic: Oracle APEX - Commenting Tips & Tricks - VIDEO
Replies: 0
Views: 84770

Oracle APEX - Commenting Tips & Tricks - VIDEO

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...
by admin
Mon Feb 06, 2023 1:18 pm
Forum: IT Jobs
Topic: Oracle DBA, EBS Functional & DBA for Karachi
Replies: 0
Views: 85962

Oracle DBA, EBS Functional & DBA for Karachi

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...
by admin
Sat Feb 04, 2023 8:32 am
Forum: Oracle APEX
Topic: IG Highlight color and Hide controls
Replies: 0
Views: 85367

IG Highlight color and Hide controls

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
by admin
Tue Jan 31, 2023 1:04 pm
Forum: Oracle APEX
Topic: Size settings of Image Interactive Report
Replies: 0
Views: 86103

Size settings of Image Interactive Report

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;}
by admin
Thu Jan 26, 2023 4:47 am
Forum: General / Others
Topic: Windows Print Screen Output Folder
Replies: 0
Views: 85150

Windows Print Screen Output Folder

Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders
by admin
Sun Jan 22, 2023 6:24 am
Forum: Oracle APEX
Topic: GET_SINCE Function Date Formatting like ago
Replies: 0
Views: 87047

GET_SINCE Function Date Formatting like ago

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,
format.jpg
by admin
Wed Jan 18, 2023 12:48 pm
Forum: Oracle APEX
Topic: Restricted workspace may not perform this action?
Replies: 0
Views: 88986

Restricted workspace may not perform this action?

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;
autono.jpg
by admin
Tue Jan 17, 2023 3:21 pm
Forum: Oracle APEX
Topic: Who Columns
Replies: 0
Views: 88147

Who Columns

"CREATED_BY" VARCHAR2(15),
"CREATION_DATE" DATE,
"LAST_UPDATED_BY" VARCHAR2(15),
"UPDATION_DATE" DATE,
by admin
Sun Jan 15, 2023 8:03 am
Forum: Oracle APEX
Topic: How to upgrade Oracle APEX?
Replies: 0
Views: 87349

How to upgrade Oracle APEX?

@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...
by admin
Wed Jan 11, 2023 3:18 pm
Forum: Oracle Projects & Property Manager
Topic: Range of “Tasks" within a project
Replies: 1
Views: 3318

Re: Range of “Tasks" within a project

Please share some sample data for better understanding. thanks
by admin
Sun Jan 08, 2023 6:01 am
Forum: Oracle APEX
Topic: Oracle APEX Emal Queue SQL
Replies: 0
Views: 87995

Oracle APEX Emal Queue SQL

SELECT * from APEX_MAIL_QUEUE ORDER BY LAST_UPDATED_ON DESC;

SELECT * from APEX_MAIL_LOG ORDER BY LAST_UPDATED_ON DESC;