Streams and dynamic tables¶
Streams can be created on dynamic tables, like streams on traditional tables, with the following limitations:
Refresh type: Streams can be created only on dynamic tables that refresh incrementally.
Stream type: Dynamic tables support only standard (i.e. delta) streams. For more information, see Types of Streams.
Create a stream on a dynamic table¶
The following example shows how to create a stream on a dynamic table:
-- Create the dynamic table, for reference only
CREATE OR REPLACE DYNAMIC TABLE product ...;
-- Create the stream.
CREATE OR REPLACE STREAM deltaStream ON DYNAMIC TABLE product;