Clear cell renal cell carcinoma (ccRCC), accounting for 70-80% of all renal cell carcinomas, is a common ma-lignancy. Survival rates decrease significantly in patients with advanced and metastatic ccRCC. Furthermore, ccRCC is less responsive to radiation and chemotherapy than other cancers. Therefore, targeted therapy and immunotherapy are particularly important for ccRCC management. A growing body of literature recognizes that competitive endogenous RNA (ceRNA) regulatory networks play a crucial role in various cancers. However, the biological functions of the ceRNA network in ccRCC require further investigation. In this study, we built the ceRNA network for ccRCC using the "GDCRNATools" package. After survival analysis, the RP11-478C19.2/hsa-miR-181b-5p, hsa-miR-181a-5p, and hsa-miR-181c-5p/E2F7 axes were obtained for further analysis. Unsuper-vised clustering was conducted basing on this ceRNA network. The results indicated that the prognosis and immune infiltration levels differed between the two clusters. Furthermore, we conducted correlation analysis, immune infiltration analysis, tumor mutation burden analysis, GSEA analysis, drug sensitivity analysis and pan -cancer analysis of E2F7 to explore its potential role in oncogenesis. Experiments in vitro were performed to confirm the pro-oncogenic impact of E2F7. The results suggest that the RP11-478C19.2/E2F7 axis might be a biomarker for the inclusion of cabozantinib, pazopanib, sunitinib, and immunotherapy in the therapeutic regimen. In summary, we found that the ceRNA-based RP11-478C19.2/E2F7 axis is involved in ccRCC and that it could be a novel biomarker for treatment decisions and a possible therapeutic target to increase the success of targeted therapy and immunotherapy in ccRCC.