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:
- right click on object in connections tree , choose quick ddl -> save file. save file .sql extension can later change desired file system.
- open object connections tree, choose file -> save as. method defaults saving files .pls extension, can override when saving or change later file system.
- 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
Post a Comment