Yo hice las pruebas con esto:
Código SQL
[-]
set term ^;
CREATE TABLE LS01 (
IBAN VARCHAR(34),
FORPAGO VARCHAR(3)
)
^
commit work^
CREATE INDEX LS01_IDX1 ON LS01 (IBAN)
^
commit work^
CREATE INDEX LS01_IDX2 ON LS01 (FORPAGO)
^
commit work^
CREATE TABLE PAIS (
CODIGO VARCHAR(2) NOT NULL,
DESCRIPCION VARCHAR(100)
)
^
commit work^
ALTER TABLE PAIS ADD CONSTRAINT PK_PAIS PRIMARY KEY (CODIGO)
^
commit work^
INSERT INTO PAIS (CODIGO, DESCRIPCION) VALUES ('ES', 'Spain')^
INSERT INTO PAIS (CODIGO, DESCRIPCION) VALUES ('DE', 'Germany')^
INSERT INTO PAIS (CODIGO, DESCRIPCION) VALUES ('PD', 'Not a country')^
commit work^
INSERT INTO LS01 (IBAN, FORPAGO) VALUES ('', 'C')^
INSERT INTO LS01 (IBAN, FORPAGO) VALUES ('ES123456', 'C')^
INSERT INTO LS01 (IBAN, FORPAGO) VALUES ('DE456789', 'C')^
INSERT INTO LS01 (IBAN, FORPAGO) VALUES ('PD121212', 'C')^
INSERT INTO LS01 (IBAN, FORPAGO) VALUES ('ZZ989898', 'C')^
commit work^