yes " " ' ' Oracle 2 255 30 30 2 Provider DataSource Data Source UserName User ID Password Password System.Data.OracleClient Microsoft.DataWarehouse.Design.OracleSchema, Microsoft.DataWarehouse Microsoft.DataWarehouse.Controls.OracleQueryDesigner, Microsoft.DataWarehouse System.Data.OleDb Microsoft.DataWarehouse.Design.OleDbSchema, Microsoft.DataWarehouse Microsoft.DataWarehouse.Controls.OleDbQueryDesigner, Microsoft.DataWarehouse System.Data.Odbc Microsoft.DataWarehouse.Design.OdbcSchema, Microsoft.DataWarehouse auto yes yes nosubsel no ( ) ( ) ( SELECT ) UPDATE INSERT INTO DELETE FROM DROP DROP MATERIALIZED CREATE MATERIALIZED VIEW REFRESH ON COMMIT AS UNIQUE INDEX ON ( ) ( ) DISTINCT FROM GROUP BY ORDER BY WHERE HAVING = ( ) VALUES ( ) SET DATABASE TABLE VIEW INDEX primary key ( ) ASC DESC : ? DATEPART( , ) year quarter month dayofyear day week weekday hour minute second millisecond * MIN MAX SUM ( ) COUNT ( ) = <> > >= < <= IN AND OR + - / * ( ) IS NULL ( ) varchar2 varchar2 varchar2 number(1,0) number(3,0) number(5,0) number(10,0) number(19,0) number(3,0) number(5,0) number(10,0) number(19,0) number float date date number number varchar2 long raw number ( ) ( , ) CAST( AS ) CAST( AS number) CAST( AS date) CAST( AS date) CAST( AS number)