CREATE TABLE  "TABLE1" ("FOLDER_ID" VARCHAR2(100 CHAR) ,"FOLDER_NAME" VARCHAR2(100 CHAR) , "PATH" VARCHAR2(100 CHAR) );

INSERT INTO TABLE1 VALUES ('1','Folder1','');
INSERT INTO TABLE1 VALUES ('2','Folder1_1','Folder1/Folder1_1');
INSERT INTO TABLE1 VALUES ('3','Folder1_1_1','Folder1/Folder1_1/Folder1_1_1');
INSERT INTO TABLE1 VALUES ('4','Folder1_2','Folder1/Folder1_2');
INSERT INTO TABLE1 VALUES ('5','Folder1_2_1','Folder1/Folder1_2/Folder1_2_1');
INSERT INTO TABLE1 VALUES ('6','Folder1_2_2','Folder1/Folder1_2/Folder1_2_2');