What is a PCK File Type?
You can open and edit PCK using PL / SQL Developer, developed by Allround Automations. You can also edit and view a PCK with a text editor since' it is stored in text.
The PCK allows you to combine the d'specification; an PL/SQL packet and the body of the packet into one file. The specifications and body of the document are usually stored in separate files. The specification of the package, which declares variables, exceptions, types, constants, sliders and programs accessible to the public from d' other applications, is currently stored in the .PKS file. The package body, which includes the code implementing the procedures, functions and cursors listed in the package specification, is currently stored in the .PKB file.
SQL is an extension of the procedural language to the structured query language. Available in Oracle Database (since version 6), IBM DB2 (since version 9.7) and TimesTen (since version 11.2.1) as well.