Long non-coding RNAs (lncRNAs) are a family of non-protein-coding RNAs that span a length of over 200 nucleotides. Research reports have illustrated that lncRNAs are involved in various cellular processes and that their abnormal expression leads to the occurrence and development of various tumors. Colon cancer-associated transcript 2 (CCAT2) was first reported as an oncogene in colon cancer. LncRNA CCAT2 is abnormally expressed in hepatocellular carcinoma, cholangiocarcinoma, lung cancer, breast cancer, ovarian cancer, glioma, and other tumors. In tumor tissues, abnormally overexpressed CCAT2 can affect cell proliferation, migration, epithelial-mesenchymal transition, apoptosis, and other biological behaviors through endogenous RNAs mechanisms, various signaling pathways, transcriptional regulation, and other complex mechanisms. Additionally, the overexpression of CCAT2 is also closely related to the tumor size, tumor node metastasis (TNM) stage, survival time, and other prognostic factors, suggesting that it is a potential prognostic indicator. This article reviews the biological functions of CCAT2 and its mechanisms of action in tumors from previous studies. In this review, we attempt to provide a molecular basis for future clinical applications of lncRNA CCAT2.