Whould you please tell me How I can make table (ex: temp_table) shared in my application?

Example:
SELECT * FROM customer WHERE customer_id = "123456" INTO TABLE temp_table.

James