Pipelined Functions in Oracle
How to create Pipelined Functions in Oracle? Pipeline functions are used to return data in tabular format. It returns the data in the nested table type. Pipeline functions are useful…
Reading File From Oracle Directory
How to read Files from Oracle Directory using PL/SQL? File Structure ACCOUNTINGRESEARCHSALESOPERATIONS3 Records5 Records6 Records0 Records How to generate files into Oracle Directory? Copy CodeCopiedUse a different Browser DECLARE l_file…
Writing File to Oracle Directory
How to write file to ORACLE Directory using PL/SQL? Creating directory Copy CodeCopiedUse a different BrowserGRANT CREATE ANY DIRECTORY TO apex_19_2; CREATE OR REPLACE DIRECTORY my_dir AS 'C:\App\MY_DIR'; Writing File…
How to open pluggable database (PDBs) in Oracle 19 C
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
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…
Posted inORACLE
Working With SYS_CONTEXT
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
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…
CLOB to BLOB using PLSQL
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;…
Posted inORACLE
Blob to Clob Using DBMS_LOB
Create function to convert the blob content to clob Copy CodeCopiedUse a different BrowserCREATE OR REPLACE FUNCTION blob_to_clob (i_blob_content IN BLOB) RETURN CLOB AS l_chunk VARCHAR2 (32767); l_position PLS_INTEGER :=…
Posted inORACLE
ORA-06533: Subscript beyond count
ORA-06533: Subscript beyond count Cause: An in-limit subscript was greater than the count of a varray or too large for a nested table. Action: Check the program logic and explicitly…