Oracle/PL/SQL

Block Types

Figo Kim 2006. 12. 31. 05:16
336x280(권장), 300x250(권장), 250x250, 200x200 크기의 광고 코드만 넣을 수 있습니다.

Anonymous

Procedure

Function

[DECLARE]

BEGIN

-- statements

[EXCEPTION]

END;

PROCEDURE name

IS

BEGIN

-- statements

[EXCEPTION]

END;

FUNCTION name

RETURN datatype

IS

BEGIN

-- statements

[EXCEPTION]

END;

 

Anonymous : Not stored in the database. To run the same block again, you have to rewrite the same code again.

Subprograms : Stored in the database and declared as either a Procedure or a function.

** A function is similar to a procedure, except that a function must return a value.

'Oracle > PL/SQL' 카테고리의 다른 글

Create a sample Anonymous block  (0) 2006.12.31
Create a sample Anonymous block  (0) 2006.12.31
Block Types  (0) 2006.12.31
PL/SQL Block Structure  (0) 2006.12.31
PL/SQL Block Structure  (0) 2006.12.31