Search found 1995 matches
- Mon Jun 13, 2022 6:00 am
- Forum: Oracle APEX
- Topic: SMS service in Oracle Database & APEX
- Replies: 0
- Views: 79
SMS service in Oracle Database & APEX
In Pakistan, if you want to use SMS service then try to get a package from a company like http://lifetimesms.com or any other company providing such services and integrate as below in the Oracle database. by Muhammad Abrar CREATE OR REPLACE PACKAGE erpstuff_sms_api IS FUNCTION send_sms(api_token IN ...
- Fri May 20, 2022 3:44 am
- Forum: Application DBA & System Administration
- Topic: GNUPG GPG
- Replies: 0
- Views: 184
GNUPG GPG
$ gpg2 –list-keys
$ gpg2 –list-secret-keys
$ gpg2 –list-secret-keys
- Mon May 16, 2022 5:23 am
- Forum: Application DBA & System Administration
- Topic: CDB and PDB Queries
- Replies: 0
- Views: 154
CDB and PDB Queries
Determining Whether a Database is a CDB
SELECT CDB FROM V$DATABASE;
Each Container in a CDB
SELECT NAME, CON_ID, DBID, CON_UID, GUID FROM V$CONTAINERS ORDER BY CON_ID;
Status of Each PDB
SELECT PDB_ID, PDB_NAME, STATUS FROM DBA_PDBS ORDER BY PDB_ID;
SELECT CDB FROM V$DATABASE;
Each Container in a CDB
SELECT NAME, CON_ID, DBID, CON_UID, GUID FROM V$CONTAINERS ORDER BY CON_ID;
Status of Each PDB
SELECT PDB_ID, PDB_NAME, STATUS FROM DBA_PDBS ORDER BY PDB_ID;
- Sun May 15, 2022 5:04 pm
- Forum: Application DBA & System Administration
- Topic: How to get SID and Service Name?
- Replies: 0
- Views: 142
How to get SID and Service Name?
Import SQL's SELECT sys_context('userenv','instance_name') FROM dual; select value from v$parameter where name like '%service_name%'; SELECT sys_context('USERENV', 'SID') FROM DUAL; select sys_context('userenv','db_name') from dual; select sys_context('userenv', 'server_host') from dual; select ora_...
- Mon May 09, 2022 3:46 am
- Forum: Oracle APEX
- Topic: Get Milliseconds in Date & time?
- Replies: 0
- Views: 211
Get Milliseconds in Date & time?
Hi,
The following query can be used to get milliseconds in the date & time stamp,
SELECT to_char (SYSTIMESTAMP, 'DD-Mon-RR HH24:MI:SS.FF') FROM DUAL;
SELECT to_char (SYSTIMESTAMP, 'DD-Mon-RR HH24:MI:SS.FF3') FROM DUAL;
08-May-22 23:38:13.698
Reference_R21
The following query can be used to get milliseconds in the date & time stamp,
SELECT to_char (SYSTIMESTAMP, 'DD-Mon-RR HH24:MI:SS.FF') FROM DUAL;
SELECT to_char (SYSTIMESTAMP, 'DD-Mon-RR HH24:MI:SS.FF3') FROM DUAL;
08-May-22 23:38:13.698
Reference_R21
- Fri Apr 15, 2022 7:53 am
- Forum: Oracle APEX
- Topic: APEX_AUTOMATION Package
- Replies: 0
- Views: 346
APEX_AUTOMATION Package
The APEX_AUTOMATION package provides automated functionality to your environment. Automations are a sequential set of actions that are triggered by query results. Use automation to monitor data and then perform the appropriate action, such as auto-approving specific requests and sending email alerts...
- Tue Mar 15, 2022 5:30 am
- Forum: Oracle APEX
- Topic: Oracle APEX Online Training
- Replies: 1
- Views: 588
Oracle APEX Online Training
This Oracle APEX training is designed for those who are already working in Oracle EBS and want to use Oracle APEX to create Dashboards, Reports, and other Self Service Applications. Duration: 3 Days Fee: 650 USD Introductory Fee: 325 USD Proposed Dates: 21st Mar to 31st Mar (depending on registered ...
- Fri Mar 04, 2022 4:41 pm
- Forum: Application DBA & System Administration
- Topic: Assign static IP in Oracle Linux
- Replies: 0
- Views: 426
Assign static IP in Oracle Linux
ifconfig eth0 192.168.1.10 netmask 255.255.255.0
- Fri Mar 04, 2022 3:26 pm
- Forum: Application DBA & System Administration
- Topic: Verify Oracle EBS user password
- Replies: 0
- Views: 337
Verify Oracle EBS user password
select fnd_web_sec.validate_login(‘SYSADMIN’,’sysadmin’) from dual;
It should return Y or N.
It should return Y or N.
- Fri Mar 04, 2022 3:26 pm
- Forum: Application DBA & System Administration
- Topic: Enable/Disable Oracle Linux GUI
- Replies: 0
- Views: 331
Enable/Disable Oracle Linux GUI
In Oracle EBS VM's normally GUI is not there so only terminal will be there for the command line. To install/enable GUI following these steps as root user, Enable 1 - $ yum update 2 - $ yum groupinstall "Server with GUI" 3 - Start Oracle Linux GUI on system startup $ ln -sf /lib/systemd/sy...
- Sun Feb 06, 2022 9:41 am
- Forum: Application DBA & System Administration
- Topic: Downloading Linux Image and Installation
- Replies: 0
- Views: 499
Downloading Linux Image and Installation
1. Download Linux 8.0 (example). linux1.png 2. There are 3 files in it you need V983280-01 V983278-01 V983279-01 V983280-01 3. Now need to download a Bootable Creator USB/DVD better use USB 8GB or above. https://www.balena.io/etcher/ https://rufus.ie/en 4. I used Etcher as it is open source while Ru...
- Wed Feb 02, 2022 5:03 pm
- Forum: Oracle APEX
- Topic: Oracle default EMP and DEPT table script with data
- Replies: 0
- Views: 517
Oracle default EMP and DEPT table script with data
CREATE TABLE "DEPT" ( "DEPTNO" NUMBER(2,0), "DNAME" VARCHAR2(14 BYTE), "LOC" VARCHAR2(13 BYTE) ) ; ALTER TABLE "DEPT" ADD PRIMARY KEY ("DEPTNO"); CREATE TABLE "EMP" ( "EMPNO" NUMBER(4,0) NOT NULL, "ENAME" VARC...
- Wed Feb 02, 2022 2:36 am
- Forum: Application DBA & System Administration
- Topic: Oracle VM Virtual Appliances for Oracle E-Business Suite 12.2.10
- Replies: 0
- Views: 492
Oracle VM Virtual Appliances for Oracle E-Business Suite 12.2.10
Oracle VM Virtual Appliances for Oracle E-Business Suite 12.2.10 Here steps to install and configure Oracle EBS 12.2.10 in VirtualBox are explained so anyone can configure on a laptop/desktop to use and practice. space.png 1. Download Oracle VM VirtualBox vm.png https://www.oracle.com/virtualizatio...
- Thu Jan 27, 2022 4:44 pm
- Forum: Oracle APEX
- Topic: Built-in substitution names
- Replies: 0
- Views: 456
Built-in substitution names
The built-in substitution names are:
&APP_USER.
&APP_ID.
&APP_PAGE_ID.
&APP_SESSION.
&APP_FILES.
&WORKSPACE_FILES.
&REQUEST.
&DEBUG.
&APEX_FILES.
&IMAGE_PREFIX. (legacy- use &APEX_FILES. instead)
&APEX_VERSION.
&APP_USER.
&APP_ID.
&APP_PAGE_ID.
&APP_SESSION.
&APP_FILES.
&WORKSPACE_FILES.
&REQUEST.
&DEBUG.
&APEX_FILES.
&IMAGE_PREFIX. (legacy- use &APEX_FILES. instead)
&APEX_VERSION.
- Wed Jan 26, 2022 1:28 pm
- Forum: Oracle APEX
- Topic: Upload Multiple files into table code
- Replies: 0
- Views: 472
Upload Multiple files into table code
create table erpstuff_files (name VARCHAR2(400), filename VARCHAR2(400), mime_type VARCHAR2(255), created_on date, blob_content blob); declare l_file_names apex_t_varchar2; l_file apex_application_temp_files%rowtype; begin l_file_names := apex_string.split ( p_str => :P2_DOC, p_sep => ':' ); for i i...