create table Tab1(
 ID NUMBER(10) PRIMARY KEY,
 T1FIELD1 VARCHAR2(10)
);

create table Tab2(
  ID NUMBER(10) PRIMARY KEY,
  TAB1_ID NUMBER(10) NOT NULL,
  T2FIELD1 VARCHAR2(10),
  T2FIELD2 VARCHAR2(10)
);

ALTER TABLE Tab2
ADD CONSTRAINT FK_Tab1_Tab2 FOREIGN KEY (TAB1_ID)
REFERENCES Tab1 (ID) ON DELETE CASCADE;

select t1.T1FIELD1,
(select t2.T2FIELD1 from Tab2 t2
where t2.TAB1_ID=t1.ID and rownum<=1) T2FIELD1,
(select t2.T2FIELD2 from Tab2 t2
where t2.TAB1_ID=t1.ID and rownum<=1) T2FIELD2,
from Tab1 t1

(select t2.T2FIELD1 from Tab2 t2
where t2.TAB1_ID=t1.ID and rownum<=1) T2FIELD1,

(select t2.T2FIELD2 from Tab2 t2
where t2.TAB1_ID=t1.ID and rownum<=1) T2FIELD2,