SQL programs

Data

Name alternate models a la showmodel

Description attempts to roughly duplicate showmodel except the bazhenov model id is provided

SQL Program select alt_mod.object_id, alt_mod.object_name, alt_mod.ver_number, list_num.value_ from objects alt_mod, eav_memo vers_name, eav_objects alt_vers, eav_int list_num where alt_vers.value_ = vers_name.object_id(+) and vers_name.attribute_id(+) = 312 and alt_vers.attribute_id = 314 and alt_mod.object_id=alt_vers.value_ and list_num.object_id(+)=alt_mod.object_id and list_num.attribute_id=310 order by list_num.value_(+)

Maximum Rows

Maximum Columns