How can you create memory table in oracle and fill it by data from select statement into oracle function?

CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(create_definition,...)] [table_options] [partition_options] select_statement

temp table is real table and it will be drop from database when drop and the data will store in harddrive  but memory table not a real table it virtual table and it will store in the physical memory

 Temp table can be used for the current session or global. So that a multiple user session can utilize the results in the table

but the table memory can be used up to that program. (Stored procedure

memory table use varray Technic

using temp tables which will be deleted after closing the current session

You can create either with the wizard or with the SQL queries using the window sql commands:

CREATE TABLE table_name

(

   column1 datatype [NULL | NOT NULL]

   column2 datatype [NULL | NOT NULL]

   ...

);

The short answer is No. You can't create temp table in memory.

Temporary table need to use temporary segments which need to be allocated from temporary tablespace.but if you are talking about a normal table (not a temp) then you cache it into memory!here is good read