How to get desired type of records for desired number of times in oracle
Please try this query:

select * from PROFILES where 
SCORING_RULE = 'double_scoring' and
ROWNUM &lt;= 6
union
select * from PROFILES where 
SCORING_RULE = 'single_scoring' and
ROWNUM &lt;= 4


Check it here: http://sqlfiddle.com/#!4/7ecc95/1