This shows you the differences between two versions of the page.
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] 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; |