Oxide interfaces have sparked considerable interest due totheir fascinating physical properties and promising possibilitiesfor next-generation nanoelectronics. Three intriguing oxideinterfaces, hetero-, homo-, and tubular interfaces, will bediscussed in detail in this review. First, the development andfundamental properties of classical heterointerfaces will beelaborated. Using LaAlO₃/SrTiO₃ as a case study, we presentthe most generic approach to control the two-dimensionalelectron conduction at the heterointerface. Secondly, severalkey issues based on interesting observations on ferroichomointerfaces will be addressed. Multiple controls of fascinatingfunctionalities based on multiferroic BiFeO₃ domainwalls will be presented as a model system. Finally, as themost challenging task, we review a new type of complex oxideinterfaces, the tubular interface. Further insights of recentlyemerged tubular interfaces in BiFeO₃/CoFe₂O₄ systemwill be explored, which serve as one of the focal roles in developingnew functional interfaces and potentially new typeof nanostructures.