Search found 2063 matches
- Fri Mar 10, 2023 2:37 pm
- Forum: Oracle APEX
- Topic: Authorization Schemes Script & Video Demo
- Replies: 0
- Views: 102388
Authorization Schemes Script & Video Demo
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 ...
- Tue Feb 28, 2023 9:17 am
- Forum: Oracle APEX
- Topic: Custom Authentication Function
- Replies: 0
- Views: 102359
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...
- Thu Feb 16, 2023 4:16 am
- Forum: Oracle APEX
- Topic: Make field readonly using Custom Attributes
- Replies: 0
- Views: 102846
Make field readonly using Custom Attributes
This way field will be readonly while stillyou can assign values using code etc.
readonly="true"
readonly="true"
- Mon Feb 13, 2023 10:32 am
- Forum: Oracle APEX
- Topic: Imange fixed size in Interactive/Classic Reports
- Replies: 0
- Views: 100721
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.
- Wed Feb 08, 2023 10:18 am
- Forum: Oracle APEX
- Topic: Oracle APEX - Commenting Tips & Tricks - VIDEO
- Replies: 0
- Views: 100575
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...
- Mon Feb 06, 2023 1:18 pm
- Forum: IT Jobs
- Topic: Oracle DBA, EBS Functional & DBA for Karachi
- Replies: 0
- Views: 100895
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...
- Sat Feb 04, 2023 8:32 am
- Forum: Oracle APEX
- Topic: IG Highlight color and Hide controls
- Replies: 0
- Views: 100925
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
- Tue Jan 31, 2023 1:04 pm
- Forum: Oracle APEX
- Topic: Size settings of Image Interactive Report
- Replies: 0
- Views: 101553
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;}
2. In the page inline CSS following code,
td[headers="PHOTO_BLOB"] img {width: 64px;}
- Thu Jan 26, 2023 4:47 am
- Forum: General / Others
- Topic: Windows Print Screen Output Folder
- Replies: 0
- Views: 100390
Windows Print Screen Output Folder
Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders
- Sun Jan 22, 2023 4:08 pm
- Forum: Oracle APEX
- Topic: Change Text Field Background Color
- Replies: 0
- Views: 102890
- Sun Jan 22, 2023 6:24 am
- Forum: Oracle APEX
- Topic: GET_SINCE Function Date Formatting like ago
- Replies: 0
- Views: 102976
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,
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,
- Wed Jan 18, 2023 12:48 pm
- Forum: Oracle APEX
- Topic: Restricted workspace may not perform this action?
- Replies: 0
- Views: 104679
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;
begin
wwv_flow_api.remove_flow(101);
end;
- Tue Jan 17, 2023 3:21 pm
- Forum: Oracle APEX
- Topic: Who Columns
- Replies: 0
- Views: 103814
Who Columns
"CREATED_BY" VARCHAR2(15),
"CREATION_DATE" DATE,
"LAST_UPDATED_BY" VARCHAR2(15),
"UPDATION_DATE" DATE,
"CREATION_DATE" DATE,
"LAST_UPDATED_BY" VARCHAR2(15),
"UPDATION_DATE" DATE,
- Sun Jan 15, 2023 8:03 am
- Forum: Oracle APEX
- Topic: How to upgrade Oracle APEX?
- Replies: 0
- Views: 102963
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...
- Wed Jan 11, 2023 3:18 pm
- Forum: Oracle Projects & Property Manager
- Topic: Range of “Tasks" within a project
- Replies: 1
- Views: 4273
Re: Range of “Tasks" within a project
Please share some sample data for better understanding. thanks