Whenever you format your code in TOAD a header line is displayed as below,
If you want to disable it use the following option,
Search found 2063 matches
- Sat Dec 18, 2021 4:01 pm
- Forum: Oracle APEX
- Topic: Disable Format Header in TOAD
- Replies: 0
- Views: 9232
- Sat Dec 18, 2021 6:45 am
- Forum: Oracle APEX
- Topic: SQL Joins
- Replies: 0
- Views: 9504
SQL Joins
select * from emp; select * from dept; select e.* from emp e inner join dept d on e.deptno = d.deptno select e.* from emp e left join dept d on e.deptno = d.deptno select e.* from emp e left outer join dept d on e.deptno = d.deptno select e.* from emp e right join dept d on e.deptno = d.deptno selec...
- Sat Dec 18, 2021 6:41 am
- Forum: Oracle APEX
- Topic: EMP & DEPT Sample Tables Creation Script
- Replies: 0
- Views: 9405
EMP & DEPT Sample Tables Creation Script
create table js_dept( deptno number(2,0), dname varchar2(14), loc varchar2(13), constraint pk_dept primary key (deptno) ); / create table js_emp( empno number(4,0), ename varchar2(10), job varchar2(9), mgr number(4,0), hiredate date, sal number(7,2), comm number(7,2), deptno number(2,0), constraint...
- Mon Dec 13, 2021 6:01 am
- Forum: Oracle APEX
- Topic: Flows for APEX DB Objects List
- Replies: 0
- Views: 9421
Flows for APEX DB Objects List
select object_name, object_type from user_objects where object_name like 'FLOW_%' order by object_name, object_type; OBJECT_NAME OBJECT_TYPE FLOW_API_PKG PACKAGE FLOW_API_PKG PACKAGE BODY FLOW_BOUNDARY_EVENTS PACKAGE FLOW_BOUNDARY_EVENTS PACKAGE BODY FLOW_BPMN_PARSER_PKG PACKAGE FLOW_BPMN_PARSER_PKG...
- Sun Dec 12, 2021 3:46 pm
- Forum: Oracle APEX
- Topic: APEX_DEBUG_MESSAGE
- Replies: 0
- Views: 9380
APEX_DEBUG_MESSAGE
DECLARE l_value varchar2(100) := 'ERPstuff Error Message'; BEGIN APEX_DEBUG_MESSAGE.ENABLE_DEBUG_MESSAGES(p_level => 3); APEX_DEBUG_MESSAGE.LOG_MESSAGE( p_message => 'This is my message = ' || l_value, p_level => 1 ); APEX_DEBUG_MESSAGE.DISABLE_DEBUG_MESSAGES(); END; NOTE: Level or levels of messag...
- Sun Dec 05, 2021 2:05 pm
- Forum: Oracle APEX
- Topic: Master Detail Report using XML Desktop Publisher
- Replies: 0
- Views: 10228
Master Detail Report using XML Desktop Publisher
In this topic all scripts and details related to developing a master-detail report in Oracle APEX. Register free at https://apex.oracle.com/ PO Header Table CREATE TABLE "PO_HEADERS_ALL" ( "PO_HEADER_ID" NUMBER, "VENDOR_NAME" VARCHAR2(100), "VENDOR_SITE_NAME" ...
- Fri Dec 03, 2021 4:12 pm
- Forum: Oracle APEX
- Topic: Data Export Function Sample PL_SQL
- Replies: 0
- Views: 9182
Data Export Function Sample PL_SQL
DECLARE l_context apex_exec.t_context; l_export apex_data_export.t_export; BEGIN l_context := apex_exec.open_query_context( p_location => apex_exec.c_location_local_db, p_sql_query => 'select * from emp' ); l_export := apex_data_export.export ( p_context => l_context, p_format => apex_data_export.c_...
- Mon Nov 29, 2021 4:11 am
- Forum: Oracle APEX
- Topic: Trigger to Assign sequence as PK
- Replies: 0
- Views: 9313
Trigger to Assign sequence as PK
create or replace SEQUENCE JS_HEALTH_CHECK_seq start with 1 nocache;
CREATE OR REPLACE TRIGGER JS_HEALTH_CHECK_BIU
before insert OR UPDATE ON JS_HEALTH_CHECK
for each row
BEGIN
IF :NEW.ID IS NULL THEN
SELECT JS_HEALTH_CHECK_seq.nextval INTO :NEW.ID FROM sys.dual;
END IF;
END;
/
CREATE OR REPLACE TRIGGER JS_HEALTH_CHECK_BIU
before insert OR UPDATE ON JS_HEALTH_CHECK
for each row
BEGIN
IF :NEW.ID IS NULL THEN
SELECT JS_HEALTH_CHECK_seq.nextval INTO :NEW.ID FROM sys.dual;
END IF;
END;
/
- Mon Nov 22, 2021 2:08 am
- Forum: Oracle APEX
- Topic: Uninstall PWA
- Replies: 0
- Views: 9204
Uninstall PWA
C:\Users\Sikandar\AppData\Local\WhatsApp
C:\Users\Sikandar\AppData\Roaming\Microsoft\Windows\Start Menu\Programs\Chrome Apps
C:\Users\Sikandar\AppData\Roaming\Microsoft\Windows\Start Menu\Programs\Chrome Apps
- Sat Nov 20, 2021 4:29 am
- Forum: Oracle APEX
- Topic: Check box in Interactive Reports
- Replies: 0
- Views: 8985
Check box in Interactive Reports
-- A column to be added as below, so the user will check the lines and then in the process loop will insert values in a table. select ID, apex_item.checkbox2(1,PROFILE_ID) as "Select", name from js_users -- Process begin for i in 1..apex_application.g_f1.count loop apex_debug_message.log_m...
- Thu Nov 18, 2021 2:19 am
- Forum: Oracle APEX
- Topic: Add or Remove Roles
- Replies: 0
- Views: 9170
Add or Remove Roles
apex_acl.add_user_role ( p_application_id => wwv_flow_security.g_flow_id, , p_user_name => p_app_user , p_role_static_id => 'ACCOUNTANT' ); apex_acl.remove_user_role ( p_application_id => default wwv_flow_security.g_flow_id, , p_user_name => p_app_user , p_role_static_id => 'ACCOUNTANT' ); APEX_ACL....
- Thu Nov 18, 2021 1:42 am
- Forum: Oracle APEX
- Topic: Setting Language Preference
- Replies: 0
- Views: 9015
Setting Language Preference
apex_util.set_preference(
p_preference => 'FSP_LANGUAGE_PREFERENCE',
p_value => 'en-us'
);
p_preference => 'FSP_LANGUAGE_PREFERENCE',
p_value => 'en-us'
);
- Tue Nov 16, 2021 4:06 am
- Forum: Oracle APEX
- Topic: APEX 21.1 standard Views
- Replies: 0
- Views: 8993
APEX 21.1 standard Views
SQL> select view_name from all_views where owner = 'APEX_210100'; VIEW_NAME -------------------------------------------------------------------------------- WWV_INSTALL_ERRORS WWV_FLOW_RT$SERVICES WWV_FLOW_RT$IDM_PRIVS WWV_FLOW_RT$APEX_ACCOUNT_PRIVS WWV_FLOW_CURRENT_SGID WWV_FLOW_CURRENT_WORKSPACES ...
- Sat Nov 13, 2021 3:57 pm
- Forum: Oracle APEX
- Topic: Listener and APEX config on XE 21c
- Replies: 0
- Views: 10275
Listener and APEX config on XE 21c
Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production Version 21.3.0.0.0 # listener.ora Network Configuration File: C:\app\Sikandar\product\21c\homes\OraDB21Home1\NETWORK\ADMIN\listener.ora # Generated by Oracle configuration tools. DEFAULT_SERVICE_LISTENER = XE SID_LIST_LISTENER = (SI...
- Wed Nov 10, 2021 8:11 am
- Forum: Oracle APEX
- Topic: Showing image inside a Region
- Replies: 0
- Views: 10207
Showing image inside a Region
To add an image inside a region click the region and in the HTML Code property enter image reference which was uploaded in application static file as a shared component,
<img src="#APP_FILES#technology.jpg">
<img src="#APP_FILES#technology.jpg">