Question

Without specification how to create the package body

Answer 1

When the package only contains variable or type declarations, e. g. Create package no body As gc_yes constant varchar2='Y' ;end.