Name Value
CREATED 2011-09-19 12:29:32.0
LAST_DDL_TIME 2011-09-19 12:29:32.0
OWNER AREL
VIEW_NAME MGV_ALL_STORED_PROGRAMS
TEXT_LENGTH 1272
TEXT SELECT md_projects.id project_id , md_projects.project_name project_name , md_connections.id connection_id , md_connections.host host , md_connections.port port , md_connections.username username , md_catalogs.id catalog_id , md_catalogs.catalog_name catalog_name , md_schemas.id schema_id , md_schemas.name schema_name , md_stored_programs.id stored_program_id , md_stored_programs.programtype programtype , md_stored_programs.name stored_program_name, md_stored_programs.package_id_fk package_id_fk FROM md_projects , md_connections, md_catalogs , md_schemas , md_stored_programs WHERE md_stored_programs.schema_id_fk = md_schemas.id AND md_schemas.catalog_id_fk = md_catalogs.id AND md_catalogs.connection_id_fk = md_connections.id AND md_connections.project_id_fk = md_projects.id
TYPE_TEXT_LENGTH null
TYPE_TEXT null
OID_TEXT_LENGTH null
OID_TEXT null
VIEW_TYPE_OWNER null
VIEW_TYPE null
SUPERVIEW_NAME null