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� pr�spevky 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