Unanswered: Extensions to be used for pl sql packages and other programs
Can anyone tell me that what should be the extension for the source code files that contain
1. package specification
2. package body
3. trigger body
During development of this code, we are using PL SQL developer. It provides the extension 1. package specification-.spc
2. package body-.bdy
3. trigger body-.trg
I doubt that it is good practice to keep the same extensions while deploying the code at the cient side. Please suggest.
I doubt that the client side deployment may not happen properly if I keep the extensions specific to PL SQL developer and in the case, PL SQL developer is not installed at the client side. I need an advice on the same.
What do you mean by "the client side". Packages etc. are installed in the server, not on the client machine(s).
If you mean a customer's database, then you will provide them with all the necessary scripts with whatever extensions you choose and either instructions for running them or more likely a master script something like this: