PREPARE 문은 FROM 절의 preparable_stmt에 지정된 질의문을 준비하고, 이후에 해당 SQL 문을 참조할 때 사용될 이름을 stmt_name에 할당한다.
PREPARE stmt_name FROM preparable_stmt
--prepare and execute a statement without any parameter marker
PREPARE stmt1 FROM 'SELECT CURRENT_TIMESTAMP ()';
EXECUTE stmt1;
;ru
Current transaction has been committed.
=== <Result of SELECT Command in Line 2> ===
SYS_TIMESTAMP
===========================
03:49:28 PM 04/02/2010
--prepare and execute a statement with a parameter marker
PREPARE stmt1 FROM 'SELECT POWER(?,2)*PI()';
EXECUTE stmt1 USING 2;
;ru
=== <Result of SELECT Command in Line 2> ===
power( ?:0 , 2)* pi()
==========================
1.256637061435917e+01