The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Does HP Vertica fully supports ORACLE for queries ???

Does HP Vertica fully supports ORACLE for queries ??? I am not able to fire a below query: SELECT TABLE_NAME FROM ALL_TABLES WHERE OWNER='VMartDB' Which syntax does HP Vertica follow ??


  • Hello Syed, It's not clear what you mean when you request "full support" of Oracle queries. The SQL syntax is largely the same and the most commonly used catalog tables are also mostly compatible. However, some queries may need to be modified to work with Vertica if they previously worked with Oracle's database product. Please see the documentation for each case. Here is the documentation page for v_catalog.all_tables: v_catalog.tables has more information, including owner information:
  • Navin_CNavin_C Vertica Customer
    Hello Syed, The above query will work this way. SELECT TABLE_NAME FROM ALL_TABLES WHERE OWNER_NAME='VMartDB' Hope this helps..

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file