How to install APEX in Oracle 19 C Download APEX from Oracle products. Download APEX 19.2 Oracle 19 C is multi tenant architecture database. We can create multiple Pluggable databases (PDBs ) and each database can have one APEX instance. Extract the Zip file in the system folder. Open Command Prompt (CMD) as …

Read More

How to open pluggable database (PDBs) in Oracle 19 C? First need to log in and check the PDB status 1C:\WINDOWS\system32>sqlplus /nolog 2SQL*Plus: Release 19.0.0.0.0 - Production on Wed Mar 25 21:53:59 2020 3Version 19.3.0.0.0 4Copyright (c) 1982, 2019, Oracle. All rights reserved. 5SQL> conn sys/orcl as sysdba …

Read More

How to install ORACLE 19 C on windows 10 (64 bit) To install ORACLE 19 C we need to check system requirements first. Oracle Database for Windows x64 is supported on the following operating systems: Windows 8.1 x64 - Pro and Enterprise editions Windows 10 x64 - Pro, Enterprise, and Education editions Windows Server …

Read More

Create user 12C: 1connect system/manager as sysdba 1alter session set "_ORACLE_SCRIPT"=true; 2/ 1create user lime identified by limeoracle; 2/ 1grant dba to lime; 2/ 1connect lime/limeoracle 2/ 1create table test(lime number);

Read More

Some times we do not know about our schema exist in which db and which is our schema hare is the method to find db and schema name. 1DECLARE 2 CURSOR ashish_db_name 3 IS 4 SELECT NAME 5 FROM v$database; 6 My_db_name VARCHAR2 (4000); 7BEGIN 8 OPEN ashish_db_name; 9 FETCH ashish_db_name 10 INTO My_db_name ; 11 CLOSE …

Read More