PREPARE 문

설명

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