When you write a pl/sql script without storing in DB its anonymous (no name) . To give a name the anonymous block can be converted to a database procedure or a function.