Answer to Question #58308 in Databases | SQL | Oracle | MS Access for Sahn Lee

Question

Assign your last name as the value of the text variable in the executable section of the block. Include statements in the block to display each variable's value onscreen.

Answer 1

This is an example of stored procedure in Firebird:

create or alter procedure NEW_PROCEDURE
as
declare variable TEXT_VAR varchar(20);
begin
text_var = 'Globov';
suspend;
end