Quellcode View nmv_v1_land

[ Überblick   Tabellen  Views  Prozeduren  Trigger  nmv_v1_land ]

Das DB-Objekt selbst

create view "demoadm".nmv_v1_land (nmv_nmvid,nmv_uniqname,nmv_name,nmv_kurz,nmv_text) as
  select x0.nmv_nmvid ,x0.nmv_uniqname ,x0.nmv_name ,x0.nmv_kurz
    ,x0.nmv_text from "demoadm".numverw x0 where ((x0.nmv_nmvid
    >= 260040 ) AND (x0.nmv_nmvid <= 260049 ) ) ;

Abhängige Objekte, Rechte

grant select on "demoadm".nmv_v1_land to "public" as "demoadm";

HTML-Autor: Rohloff, Datenbank: demodb, Datenstand: 31.05.00 17:07