If the Oracle SQL Developer crashing on startup on your computer, you can follow the solutions mentioned in this post to resolve the issue.

In SQL Server, the initial dialect for stored procedures (or stored procs) was Transact-SQL, aka T-SQL; in Oracle, it was PL-SQL. Both databases have added additional languages for stored ...

You create a CLOB in Oracle through the database's Structured Query Language, or SQL. Using SQL's "ALTER TABLE" statement, you add a CLOB data item to an existing table in your business' database.

Purpose This tutorial shows you how to perform a unit test of your PL/SQL code in Oracle SQL Developer 3.0.