create-package

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
create-package [2015/10/16 11:41]
dmtolpeko
create-package [2015/10/16 12:13] (current)
dmtolpeko
Line 8: Line 8:
  
 <code language=sql>​ <code language=sql>​
-[ALTER | CREATE [OR REPLACE] | REPLACE] PACKAGE package_name AS | IS package_spec END+[CREATE [OR REPLACE] | REPLACE] PACKAGE package_name AS | IS package_spec END
  
 package_spec:​ package_spec:​
Line 19: Line 19:
  
 <code language=sql>​ <code language=sql>​
-[ALTER | CREATE [OR REPLACE] | REPLACE] PACKAGE BODY package_name AS | IS package_body END+[CREATE [OR REPLACE] | REPLACE] PACKAGE BODY package_name AS | IS package_body END
  
 package_body:​ package_body:​
Line 47: Line 47:
   function get_count() return int   function get_count() return int
   is   is
 +  begin
     return session_count;​     return session_count;​
   end;    end; 
   procedure add(name varchar(100))   procedure add(name varchar(100))
   is    is 
 +  begin
     -- ...     -- ...
     session_count = session_count + 1;     session_count = session_count + 1;