Issue with creating a view (OSDM 3.1)
897831Nov 22 2011 — edited Dec 1 2011I need to create a view as follows:
CREATE OR REPLACE FORCE VIEW W_EHA_CODING_REGION_V
AS
SELECT gc.*
FROM w_eha_gene_component gc
WHERE gc.component_type = 'CDS';
I input following query in query builder window for a view:
SELECT gc.* FROM w_eha_gene_component gc WHERE gc.component_type = 'CDS'
I’m facing two issues:
1. No attributes(columns) are displayed in relational diagram in OSDM for a view (it just displays blank box).
2. Generated DDL is missing keyword “AS”. DDL provided below:
CREATE OR REPLACE VIEW W_EHA_CODING_REGION_V SELECT gc.* FROM w_eha_gene_component gc WHERE gc.component_type = 'CDS' ;
BTW, in older version (3.0.x), I think there was option to specify user defined DDL for a view. I don't see this opion in v3.1