oracle sqldeveloper - sql Developer pkg AND trg FILES -


taking sql class , using sql developer. how create file extensions .pkg , .trg. know package , triggers. when opened connection , right clicked package opened package did not create actual file able submit?

any ideas?

there various options saving code file:

  1. right click on object in connections tree , choose quick ddl -> save file. save file .sql extension can later change desired file system.
  2. open object connections tree, choose file -> save as. method defaults saving files .pls extension, can override when saving or change later file system.
  3. drag objects connections tree shopping cart (view->cart) click export cart button (db icon green arrow) , choose save separate files option. files saved .sql extensions, , table objects can optionally export data well.

Comments