5. Using a Distributed Database : Connecting Directly to a Local Database : Direct Execute Immediate Statement : Example: Direct Execute Immediate
Share this page                  
Example: Direct Execute Immediate
The following example illustrates how you send a create integrity statement to a local DBMS to be executed using direct execute immediate:
create table employee (name char(100),
 dept integer, salary money)
   with node=remote1, database=mydb;
direct execute immediate ’create integrity
 on employee is salary>0’
   with node=remote1, database=mydb;