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 to dump data derived from the complex queries. Read more
How to read Files from Oracle Directory using PL/SQL? File Structure ACCOUNTING RESEARCH SALES OPERATIONS 3 Records 5 Records 6 Records 0 Records How to generate files into Oracle Directory? Output ACCOUNTING RESEARCH SALES OPERATIONS 3 Records 5 Records 6... Read more
How to write file to ORACLE Directory using PL/SQL? Read more
How to open pluggable database (PDBs) in Oracle 19 C? First need to log in and check the PDB status So the open mode is mounted for PDB APEX_5. Lets open the PDB. How to Close PDBs? And to select the PDB 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: Now let’s download the database... Read more
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 c##ontoor_dev; Package to set parameter value. Create a context using... Read more
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 we can define our identifiers till 128 characters if you... Read more
Create function to convert the CLOB to BLOB Now try with clob to blob conversion You might Like Read more
Create function to convert the blob content to clob Now try with Blob content to Clob conversion Read more
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 extend if necessary. CREATE OR REPLACE TYPE l_rec_type IS OBJECT... Read more