Step 1: Extract PL/SQL Source Code From Oracle

Run the following SQL query in Oracle to retrieve all PL/SQL objects from the your_schema_owner schema:

SELECT
    (CASE WHEN line = 1 THEN 'CREATE OR REPLACE ' || text ELSE text END) AS code_line
FROM all_source
WHERE owner = 'your_schema_owner'
  AND type IN ('PROCEDURE', 'FUNCTION', 'PACKAGE', 'PACKAGE BODY')
ORDER BY name, type, line;

The CREATE OR REPLACE prefix is added only to the first line of every object so the exported code can be re-imported cleanly.

Step 2: Export the Result as a Plain Text SQL File

Your goal is to produce a clean, plain text file where each line corresponds exactly to one CODE_LINE entry. Not SQL INSERT statements, not Loader format — just raw PL/SQL text.

Using DBeaver (recommended)

DBeaver cannot generate clean output using SQL export. Instead, export as text:

1. Right-click the query result grid → Export Data.
2. Choose format: CSV or TXT.
3. Select only the CODE_LINE column.
4. Configure export settings:
   • No header
   • No quotes
   • Delimiter: newline (\n)
5. Save as your_schema_owner_export.sql.

Using SQL Developer

Method A: Copy & Paste (simple)

1. Click the CODE_LINE column header to select the entire column.
2. Press Ctrl+A (select all rows) → Ctrl+C (copy).
3. Paste into a plain text editor (Notepad++, VS Code, nano).
4. Save as your_schema_owner_export.sql.

Method B: Spool to File (most reliable)

Run this in SQL Developer Worksheet to generate a clean output file:

SET PAGESIZE 0
SET LONG 2000000
SET LONGCHUNKSIZE 2000000
SET LINESIZE 2000
SET FEEDBACK OFF
SET TRIMSPOOL ON
SET TERMOUT OFF

SPOOL your_schema_owner_export.sql

SELECT
    (CASE WHEN line = 1 THEN 'CREATE OR REPLACE ' || text ELSE text END)
FROM all_source
WHERE owner = 'your_schema_owner'
  AND type IN ('PROCEDURE', 'FUNCTION', 'PACKAGE', 'PACKAGE BODY')
ORDER BY name, type, line;

SPOOL OFF

Step 3: Compress & Upload

Compress the generated your_schema_owner_export.sql file into a .zip archive (example: your_schema_owner_code.zip) and upload it using the "1. Upload ZIP" button in the assessment form.