{"id":227,"date":"2010-10-03T12:20:44","date_gmt":"2010-10-03T10:20:44","guid":{"rendered":"http:\/\/lwibs01.gm.fh-koeln.de\/blogs\/sqlexpert\/?p=227"},"modified":"2010-10-04T19:29:21","modified_gmt":"2010-10-04T17:29:21","slug":"fallstricke-kapitel-14","status":"publish","type":"post","link":"https:\/\/blogs.gm.fh-koeln.de\/sqlexpert\/2010\/10\/03\/fallstricke-kapitel-14\/","title":{"rendered":"Fallstricke Kapitel 14"},"content":{"rendered":"
    \n
  1. Die V$Views k\u00f6nnen nur f\u00fcr einfache Abfragen genutzt werden, Oracle garantiert keine Lesekonsistenz bei komplexen Abfragen, z.B. \u00fcber Joins.<\/li>\n
  2. Man kann Kommentare\u00a0 zu Tabellen oder Spalten einer Tabelle schreiben.<\/li>\n
  3. Die View Dictionary ist der Einstiegspunkt in das Data Dictionary.<\/li>\n
  4. USER_CATALOG enth\u00e4lt Infos \u00fcber Tabellen, Views, Synonyme und Sequences, USER_OBJECTS zus\u00e4tzlich \u00fcber alle anderen Objekte mit mehr Infos zu den einzelnen Objekten, wie z.B. den Status einer View.<\/li>\n
  5. Der CONSTRAINT-TYPE (R= Foreign Key, P=Primary Key, U = UNIQUE, C = CHECK oder\u00a0 NOT NULL) in der View USER_CONSTRAINTS hat\u00a0 etwas \u00fcberraschende Werte.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

    Die V$Views k\u00f6nnen nur f\u00fcr einfache Abfragen genutzt werden, Oracle garantiert keine Lesekonsistenz bei komplexen Abfragen, z.B. \u00fcber Joins. Man kann Kommentare\u00a0 zu Tabellen oder Spalten einer Tabelle schreiben. Die View Dictionary ist der Einstiegspunkt in das Data Dictionary. USER_CATALOG enth\u00e4lt Infos \u00fcber Tabellen, Views, Synonyme und Sequences, USER_OBJECTS zus\u00e4tzlich \u00fcber alle anderen Objekte mit… <\/a><\/p>\n","protected":false},"author":23,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[257],"tags":[354,350,298,352,353,351,349,322],"class_list":["post-227","post","type-post","status-publish","format-standard","hentry","category-14-data-dictionary","tag-constraints","tag-dictionary","tag-join","tag-user_catalog","tag-user_constraints","tag-user_objects","tag-vview","tag-view"],"acf":[],"_links":{"self":[{"href":"https:\/\/blogs.gm.fh-koeln.de\/sqlexpert\/wp-json\/wp\/v2\/posts\/227","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.gm.fh-koeln.de\/sqlexpert\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.gm.fh-koeln.de\/sqlexpert\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.gm.fh-koeln.de\/sqlexpert\/wp-json\/wp\/v2\/users\/23"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.gm.fh-koeln.de\/sqlexpert\/wp-json\/wp\/v2\/comments?post=227"}],"version-history":[{"count":9,"href":"https:\/\/blogs.gm.fh-koeln.de\/sqlexpert\/wp-json\/wp\/v2\/posts\/227\/revisions"}],"predecessor-version":[{"id":237,"href":"https:\/\/blogs.gm.fh-koeln.de\/sqlexpert\/wp-json\/wp\/v2\/posts\/227\/revisions\/237"}],"wp:attachment":[{"href":"https:\/\/blogs.gm.fh-koeln.de\/sqlexpert\/wp-json\/wp\/v2\/media?parent=227"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.gm.fh-koeln.de\/sqlexpert\/wp-json\/wp\/v2\/categories?post=227"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.gm.fh-koeln.de\/sqlexpert\/wp-json\/wp\/v2\/tags?post=227"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}