Extracting Data From volatile table

Database

Extracting Data From volatile table

How do i Extract the Data From a volatile table that i have just created

Tags (2)
2 REPLIES
Senior Apprentice

Re: Extracting Data From volatile table

select * from my_volatile_table?

Dieter

Enthusiast

Re: Extracting Data From volatile table

Did you use "ON COMMIT PRESERVE ROWS" while creating the volatile table?