I have 2 blocks ( master, detail- look like but not exactly)
Both blocks are form same table. Table is PROFILES
1st block (profile_type = 'CONFIGATR')
2nd block (profile_type = CONFIGVAL')
1st block queries fine as where clause in the block is profile_type = 'CONFIGATR'
2nd block that acts like detail has to query where profile_type = 'CONFIGVAL' and profile = 'AD' ( as block has various profiles)
Help is needed as I have to do this programatically - building a where clause
If user clicks on AD of the first block 3 records for AD has to be displayed. EO -1 record has to be displayed.
CREATE TABLE DSS.TAB2( PROFILE_TYPE VARCHAR2(10 BYTE) NOT NULL, PROFILE VARCHAR2(12 BYTE) NOT NULL, DESCRIPTION VARCHAR2(60 BYTE), ACTIVE VARCHAR2(1 BYTE) NOT NULL, PROFILE_ATTRIBUTE VARCHAR2(60 BYTE))SET DEFINE OFF;Insert into DSS.TAB2 (PROFILE_TYPE, PROFILE, DESCRIPTION, ACTIVE, PROFILE_ATTRIBUTE) Values ('CONFIGVAL', '100', 'Config Val M for AD', 'Y', 'AD');Insert into DSS.TAB2 (PROFILE_TYPE, PROFILE, DESCRIPTION, ACTIVE, PROFILE_ATTRIBUTE) Values ('CONFIGVAL', '101', 'Config Val M for AD', 'Y', 'AD');Insert into DSS.TAB2 (PROFILE_TYPE, PROFILE, DESCRIPTION, ACTIVE, PROFILE_ATTRIBUTE) Values ('CONFIGVAL', '102', 'Config Val M for AD', 'Y', 'AD');Insert into DSS.TAB2 (PROFILE_TYPE, PROFILE, DESCRIPTION, ACTIVE, PROFILE_ATTRIBUTE) Values ('CONFIGVAL', '200', 'Config Val O for EO', 'Y', 'EO');COMMIT;