DB Version InfoΒΆ


You can find these scripts inside the folder pmis/STND_PMIS/test/console/example.
If you want to execute them, you can use the Jython Console from the devtool menu.

filename => ex22.py

from pmis.common.xml import Xml
res = sql("select major,minor,type,to_char(applied,'YYYYMMDD HH24MISS')applied from(select * from db_version order by applied desc) where rownum=1;")
print '{"major":"' + str(res[0]['MAJOR']) + '","minor":"' + str(res[0]['MINOR']) + '","applied":"' + str(res[0]['APPLIED']) + '"}'