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…
How to open pluggable database (PDBs) in Oracle 19 C? First need to log in and check the PDB status Copy CodeCopiedUse a different BrowserC:\WINDOWS\system32>sqlplus /nolog SQL*Plus: Release 19.0.0.0.0 -…
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…
How to create Oracle SYS_CONTEXT ? Oracle SYS_CONTEXT holds the value of the parameter associated with context namespace. PrerequisiteDatabase user needs grant to create context. GRANT CREATE ANY CONTEXT TO…
ORA-00972: identifier is too long. Till Oracle 12 C, the identifier length is 30 characters. Starting from 18 C Oracle increased the length of identifier to 128 character. So now…
Create function to convert the CLOB to BLOB Copy CodeCopiedUse a different BrowserCREATE OR REPLACE FUNCTION clob_to_blob (i_clob_text IN CLOB) RETURN BLOB IS /* Version 1 29-mar-2020 */ l_blob_file BLOB;…
Create user 12C: connect system/manager as sysdba alter session set "_ORACLE_SCRIPT"=true; / create user lime identified by limeoracle; / grant dba to lime; / connect lime/limeoracle / create table test(lime…
To refresh a Materialized view we need DBMS_SNAPSHOT.REFRESH procedure. Steps. CREATE TABLE demo_m ( id NUMBER (10) primary key, name VARCHAR2 (400) ); / INSERT INTO DEMO_M ( ID, NAME)…
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. Copy CodeCopiedUse…