CREATE table “PROBY” (
“ID” NUMBER(7) NOT NULL,
“DATA” DATE,
“TEMAT” VARCHAR2(250),
“FAKTURA” VARCHAR2(200),
“MASA_PROBY” NUMBER(7),
“MASA_BADANIA” NUMBER(7),
“MASA_PO_BADANIACH” NUMBER(7),
“W_ZAMRAZARCE” NUMBER(7),
“DLA_PRACOWNIKOW” NUMBER(7),
“WARTOSC” NUMBER(7),
“WARTOSC_PO_BADANIACH” NUMBER(7),
“ODPADY” NUMBER(7),
“ODPOWIEDZIALNY” VARCHAR2(150),
constraint ”PROBY_PK” primary key (“ID”)
)
/
CREATE sequence “PROBY_SEQ”
/
CREATE trigger “BI_PROBY”
before insert on “PROBY”
for each row
begin
if :NEW.”ID” is null then
select “PROBY_SEQ”.nextval into :NEW.”ID” from dual;
end if;
end;
/
alter table “PROBY” add
constraint “PROBY_UK1″
unique (“ID”)
/
Aby zmienić home page:
Go to shared component.
Click on Edit Security Attribute under Secuirty
In Home Link text box… you will find something smilar to f?p=&APP_ID.:1:&SESSION.
After &APP_ID. you see a number , that number denotes home page.. in the above example 1 denotes the home page change 1 to 4 if you want page 4 to be ur home page