php
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Zobrazi prspevky MenuQuote from: sulo on 09.04.2010, 03:54:46
Nainštaloval si do virtualizovaného systému VMware Tools?
Quote from: calys on 04.04.2010, 00:58:36pred to new ma byt este aj :, ale aj tak neviem ci ti to pojde, a staci ked das do toho insertu ze values (seq_garant.nextval,...) nemusis mat na to triger
CREATE TABLE garant_predmetu (
id_ucitela NUMBER(3) PRIMARY KEY,
meno VARCHAR(15) NOT NULL,
priezvisko VARCHAR(30) NOT NULL,
titul VARCHAR(20),
pracovisko NUMBER (6) CONSTRAINT fk_gp REFERENCES pracov_kat(id_prac)
);
CREATE SEQUENCE seq_garant START WITH 1 INCREMENT BY 1 NOMINVALUE;
CREATE OR REPLACE TRIGGER gar_inc
BEFORE INSERT ON garant_predmetu
FOR EACH ROW
BEGIN
SELECT seq_garant.nextval INTO new.id_ucitela FROM dual;
END;
mne napriklad nechce zobrat ani tento trigger stale ked dam vlozit nejaku hodnotu mi vypise ze
SQL> INSERT INTO garant_predmetu(meno,priezvisko,titul,pracovisko) values('Tomas','Poklemba','Ing
3);
INSERT INTO garant_predmetu(meno,priezvisko,titul,pracovisko) values('Tomas','Poklemba','Ing.',3)
*
ERROR v riadku 1:
ORA-04098: trigger 'bb777bb.GAR_INC' is invalid and failed re-validation
Quote from: calys on 03.04.2010, 04:49:54ten ak_rok som robil cez proceduru
ahojte nevie mi niekto poradit,ako mam vytvorit ten stlpec v tabeluke ked tam mat napriklad na vyber z moznosti ano a nie, potom na autoincrement mi voberc nefunguje ze AUTO_INCREMENT ani mi to nevezme ani year v DATE
tak ako mam potom urobit id co je typu autoincrement a potom rok ktory zobrazi aktualny rok/rok+1