[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select to_char(nvl(X_Validation_Date,sysdate),'YYYY/MM/DD HH24:MI:SS')
into char_date
from dual;
SELECT book_class
INTO h_book_class
FROM fa_book_controls
WHERE book_type_code = h_book_type_code;