add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table table_faktura (idfaktura number, extnr number, nr number, fakturadate date)
CREATE OR REPLACE VIEW view_FAKTURA (extnr, nr, fakturadate,
constraint view_FAKTURA_pk primary key (idfaktura) disable novalidate)
AS SELECT idfaktura, extnr, nr, fakturadate FROM table_faktura WHERE
fakturadate >= to_date('01.12.2019', 'dd.mm.yyyy') AND fakturadate <
to_date('31.12.2019', 'dd.mm.yyyy');
ORA-00904: "IDFAKTURA": invalid identifier
CREATE OR REPLACE VIEW view_FAKTURA (idfaktura, extnr, nr, fakturadate,
constraint view_FAKTURA_pk primary key (idfaktura) disable novalidate)
AS SELECT idfaktura, extnr, nr, fakturadate FROM table_faktura WHERE
fakturadate >= to_date('01.12.2019', 'dd.mm.yyyy') AND fakturadate <
to_date('31.12.2019', 'dd.mm.yyyy');
CREATE OR REPLACE VIEW view_FAKTURA (idfaktura, extnr, nr, fakturadate,
constraint view_FAKTURA_pk primary key (idfaktura) disable novalidate) AS
SELECT idfaktura, extnr, nr, fakturadate
FROM table_faktura
WHERE fakturadate >= to_date('01.12.2019', 'dd.mm.yyyy')
AND fakturadate < to_date('31.12.2019', 'dd.mm.yyyy');
CREATE OR REPLACE VIEW view_FAKTURA (idfaktura, extnr, nr, fakturadate,
constraint view_FAKTURA_pk primary key (idfaktura) disable novalidate) AS
SELECT idfaktura, extnr, nr, fakturadate
FROM table_faktura
WHERE fakturadate >= DATE '2019-12-01'
AND fakturadate < DATE '2019-12-31';